#1 Place for Craft Supplies, Art Supplies, Artist Materials and Kids Crafts

Wood Frame Kits

by Nielsen Bainbridge


Problem with item sku 11538. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a8010 8010&wt=json&indent=on&fl=*&rows=1000&fq=group_id:8010&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 23406,80148,89487
AvailQtyList: 5.000000000000,1.000000000000,7.000000000000

struct
FLAGS 0
VIP_member_discount 62
barcode 087828273700
barcode_type UPC
col1 black
col1_sortorder 402
col2 17 in.
col2_sortorder 1027
col3 [empty string]
color_swatch 0-0-0.jpg
cost 9.28
deal_of_the_week NO
description black, 17 in.
group_id 8010
group_uname nielsen-bainbridge-wood-frame-kits
id 11538
list_price 30.45
map NO
mfr_num FW16017-41
net_weight 0.56
non_member_discount 52
non_member_price 14.49
prop65 NO
ship_rule_desc STD
shipping STD
sku 11538
sku_pix YES
supplier_id 1
ta_dealer_a_price 12.18
ta_dealer_c_price 10.66
ta_price 15.23
text
array
1 11538
2 FW16017-41
3 black, 17 in.
timestamp 2015-03-31T17:52:37.571Z
vip_member_price 11.57

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 23406
2 1.000000000000 80148
3 7.000000000000 89487
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '250' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.204.246.41

URL: www.misterart.com:/index.cfm:module=framing&catB=frames&CatC=kits&gr=nielsen-bainbridge-wood-frame-kits.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:31:10'}
sessionid e030daa839daf76342b82b07c4b5b2f527b6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~&gr=paasche-model-v-airbrush-parts.html
urltoken CFID=30600717&CFTOKEN=31822076&jsessionid=e030daa839daf76342b82b07c4b5b2f527b6
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:31:10'}
sessionid e0304ac1f1941ff698217592711453643015
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=framing&catB=frames&CatC=kits&gr=nielsen-bainbridge-wood-frame-kits.html
urltoken CFID=30600716&CFTOKEN=67081466&jsessionid=e0304ac1f1941ff698217592711453643015
validationerror [empty string]


Problem with item sku 19741. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a8010 8010&wt=json&indent=on&fl=*&rows=1000&fq=group_id:8010&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 23406,80148,89487
AvailQtyList: 5.000000000000,1.000000000000,7.000000000000

struct
FLAGS 0
VIP_member_discount 62
barcode 087828263619
barcode_type UPC
col1 black
col1_sortorder 402
col2 20 in.
col2_sortorder 1253
col3 [empty string]
color_swatch 0-0-0.jpg
cost 10.61
deal_of_the_week NO
description black, 20 in.
group_id 8010
group_uname nielsen-bainbridge-wood-frame-kits
id 19741
list_price 34.81
map NO
mfr_num FW16020-41
net_weight 0.56
non_member_discount 52
non_member_price 16.57
prop65 NO
ship_rule_desc STD
shipping STD
sku 19741
sku_pix YES
supplier_id 1
ta_dealer_a_price 13.92
ta_dealer_c_price 12.18
ta_price 17.41
text
array
1 19741
2 FW16020-41
3 black, 20 in.
timestamp 2015-03-31T17:52:52.683Z
vip_member_price 13.23

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 23406
2 1.000000000000 80148
3 7.000000000000 89487
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '250' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.204.246.41

URL: www.misterart.com:/index.cfm:module=framing&catB=frames&CatC=kits&gr=nielsen-bainbridge-wood-frame-kits.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:31:10'}
sessionid e030daa839daf76342b82b07c4b5b2f527b6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~&gr=paasche-model-v-airbrush-parts.html
urltoken CFID=30600717&CFTOKEN=31822076&jsessionid=e030daa839daf76342b82b07c4b5b2f527b6
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:31:10'}
sessionid e0304ac1f1941ff698217592711453643015
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=framing&catB=frames&CatC=kits&gr=nielsen-bainbridge-wood-frame-kits.html
urltoken CFID=30600716&CFTOKEN=67081466&jsessionid=e0304ac1f1941ff698217592711453643015
validationerror [empty string]


Problem with item sku 20293. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a8010 8010&wt=json&indent=on&fl=*&rows=1000&fq=group_id:8010&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 23406,80148,89487
AvailQtyList: 5.000000000000,1.000000000000,7.000000000000

struct
FLAGS 0
VIP_member_discount 62
barcode 087828523416
barcode_type UPC
col1 black
col1_sortorder 402
col2 28 in.
col2_sortorder 1421
col3 [empty string]
color_swatch 0-0-0.jpg
cost 13.12
deal_of_the_week NO
description black, 28 in.
group_id 8010
group_uname nielsen-bainbridge-wood-frame-kits
id 20293
list_price 43
map NO
mfr_num FW16028-41
net_weight 0.63
non_member_discount 52
non_member_price 20.47
prop65 NO
ship_rule_desc STD
shipping STD
sku 20293
sku_pix YES
supplier_id 1
ta_dealer_a_price 17.2
ta_dealer_c_price 15.05
ta_price 21.5
text
array
1 20293
2 FW16028-41
3 black, 28 in.
timestamp 2015-03-31T17:52:53.511Z
vip_member_price 16.34

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 23406
2 1.000000000000 80148
3 7.000000000000 89487
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '250' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.204.246.41

URL: www.misterart.com:/index.cfm:module=framing&catB=frames&CatC=kits&gr=nielsen-bainbridge-wood-frame-kits.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:31:10'}
sessionid e030daa839daf76342b82b07c4b5b2f527b6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~&gr=paasche-model-v-airbrush-parts.html
urltoken CFID=30600717&CFTOKEN=31822076&jsessionid=e030daa839daf76342b82b07c4b5b2f527b6
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:31:10'}
sessionid e0304ac1f1941ff698217592711453643015
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=framing&catB=frames&CatC=kits&gr=nielsen-bainbridge-wood-frame-kits.html
urltoken CFID=30600716&CFTOKEN=67081466&jsessionid=e0304ac1f1941ff698217592711453643015
validationerror [empty string]


Problem with item sku 22980. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a8010 8010&wt=json&indent=on&fl=*&rows=1000&fq=group_id:8010&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 23406,80148,89487
AvailQtyList: 5.000000000000,1.000000000000,7.000000000000

struct
FLAGS 0
VIP_member_discount 62
barcode 087828263497
barcode_type UPC
col1 black
col1_sortorder 402
col2 27 in.
col2_sortorder 1415
col3 [empty string]
color_swatch 0-0-0.jpg
cost 13.05
deal_of_the_week NO
description black, 27 in.
group_id 8010
group_uname nielsen-bainbridge-wood-frame-kits
id 22980
list_price 42.79
map NO
mfr_num FW16027-41
net_weight 0.56
non_member_discount 52
non_member_price 20.37
prop65 NO
ship_rule_desc STD
shipping STD
sku 22980
sku_pix YES
supplier_id 1
ta_dealer_a_price 17.12
ta_dealer_c_price 14.98
ta_price 21.4
text
array
1 22980
2 FW16027-41
3 black, 27 in.
timestamp 2015-03-31T17:52:58.899Z
vip_member_price 16.26

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 23406
2 1.000000000000 80148
3 7.000000000000 89487
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '250' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.204.246.41

URL: www.misterart.com:/index.cfm:module=framing&catB=frames&CatC=kits&gr=nielsen-bainbridge-wood-frame-kits.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:31:10'}
sessionid e030daa839daf76342b82b07c4b5b2f527b6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~&gr=paasche-model-v-airbrush-parts.html
urltoken CFID=30600717&CFTOKEN=31822076&jsessionid=e030daa839daf76342b82b07c4b5b2f527b6
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:31:10'}
sessionid e0304ac1f1941ff698217592711453643015
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=framing&catB=frames&CatC=kits&gr=nielsen-bainbridge-wood-frame-kits.html
urltoken CFID=30600716&CFTOKEN=67081466&jsessionid=e0304ac1f1941ff698217592711453643015
validationerror [empty string]


Problem with item sku 24354. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a8010 8010&wt=json&indent=on&fl=*&rows=1000&fq=group_id:8010&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 23406,80148,89487
AvailQtyList: 5.000000000000,1.000000000000,7.000000000000

struct
FLAGS 0
VIP_member_discount 62
barcode 087828393590
barcode_type UPC
col1 black
col1_sortorder 402
col2 16 in.
col2_sortorder 983
col3 [empty string]
color_swatch 0-0-0.jpg
cost 9.11
deal_of_the_week NO
description black, 16 in.
group_id 8010
group_uname nielsen-bainbridge-wood-frame-kits
id 24354
list_price 29.87
map NO
mfr_num FW16016-41
net_weight 0.56
non_member_discount 52
non_member_price 14.22
prop65 NO
ship_rule_desc STD
shipping STD
sku 24354
sku_pix YES
supplier_id 1
ta_dealer_a_price 11.95
ta_dealer_c_price 10.45
ta_price 14.94
text
array
1 24354
2 FW16016-41
3 black, 16 in.
timestamp 2015-03-31T17:53:00.095Z
vip_member_price 11.35

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 23406
2 1.000000000000 80148
3 7.000000000000 89487
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '250' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.204.246.41

URL: www.misterart.com:/index.cfm:module=framing&catB=frames&CatC=kits&gr=nielsen-bainbridge-wood-frame-kits.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:31:10'}
sessionid e030daa839daf76342b82b07c4b5b2f527b6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~&gr=paasche-model-v-airbrush-parts.html
urltoken CFID=30600717&CFTOKEN=31822076&jsessionid=e030daa839daf76342b82b07c4b5b2f527b6
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:31:10'}
sessionid e0304ac1f1941ff698217592711453643015
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=framing&catB=frames&CatC=kits&gr=nielsen-bainbridge-wood-frame-kits.html
urltoken CFID=30600716&CFTOKEN=67081466&jsessionid=e0304ac1f1941ff698217592711453643015
validationerror [empty string]


Problem with item sku 25729. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a8010 8010&wt=json&indent=on&fl=*&rows=1000&fq=group_id:8010&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 23406,80148,89487
AvailQtyList: 5.000000000000,1.000000000000,7.000000000000

struct
FLAGS 0
VIP_member_discount 62
barcode 087828213768
barcode_type UPC
col1 black
col1_sortorder 402
col2 32 in.
col2_sortorder 1647
col3 [empty string]
color_swatch 0-0-0.jpg
cost 15.35
deal_of_the_week NO
description black, 32 in.
group_id 8010
group_uname nielsen-bainbridge-wood-frame-kits
id 25729
list_price 50.3
map NO
mfr_num FW16032-41
net_weight 0.75
non_member_discount 52
non_member_price 23.94
prop65 NO
ship_rule_desc STD
shipping STD
sku 25729
sku_pix YES
supplier_id 1
ta_dealer_a_price 20.12
ta_dealer_c_price 17.61
ta_price 25.15
text
array
1 25729
2 FW16032-41
3 black, 32 in.
timestamp 2015-03-31T17:53:01.838Z
vip_member_price 19.11

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 23406
2 1.000000000000 80148
3 7.000000000000 89487
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '250' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.204.246.41

URL: www.misterart.com:/index.cfm:module=framing&catB=frames&CatC=kits&gr=nielsen-bainbridge-wood-frame-kits.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:31:10'}
sessionid e030daa839daf76342b82b07c4b5b2f527b6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~&gr=paasche-model-v-airbrush-parts.html
urltoken CFID=30600717&CFTOKEN=31822076&jsessionid=e030daa839daf76342b82b07c4b5b2f527b6
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:31:10'}
sessionid e0304ac1f1941ff698217592711453643015
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=framing&catB=frames&CatC=kits&gr=nielsen-bainbridge-wood-frame-kits.html
urltoken CFID=30600716&CFTOKEN=67081466&jsessionid=e0304ac1f1941ff698217592711453643015
validationerror [empty string]


Problem with item sku 27834. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a8010 8010&wt=json&indent=on&fl=*&rows=1000&fq=group_id:8010&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 23406,80148,89487
AvailQtyList: 5.000000000000,1.000000000000,7.000000000000

struct
FLAGS 0
VIP_member_discount 62
barcode 087828323610
barcode_type UPC
col1 black
col1_sortorder 402
col2 23 in.
col2_sortorder 1314
col3 [empty string]
color_swatch 0-0-0.jpg
cost 11.61
deal_of_the_week NO
description black, 23 in.
group_id 8010
group_uname nielsen-bainbridge-wood-frame-kits
id 27834
list_price 38.06
map NO
mfr_num FW16023-41
net_weight 0.56
non_member_discount 52
non_member_price 18.12
prop65 NO
ship_rule_desc STD
shipping STD
sku 27834
sku_pix YES
supplier_id 1
ta_dealer_a_price 15.22
ta_dealer_c_price 13.32
ta_price 19.03
text
array
1 27834
2 FW16023-41
3 black, 23 in.
timestamp 2015-03-31T17:53:05.04Z
vip_member_price 14.46

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 23406
2 1.000000000000 80148
3 7.000000000000 89487
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '250' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.204.246.41

URL: www.misterart.com:/index.cfm:module=framing&catB=frames&CatC=kits&gr=nielsen-bainbridge-wood-frame-kits.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:31:10'}
sessionid e030daa839daf76342b82b07c4b5b2f527b6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~&gr=paasche-model-v-airbrush-parts.html
urltoken CFID=30600717&CFTOKEN=31822076&jsessionid=e030daa839daf76342b82b07c4b5b2f527b6
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:31:10'}
sessionid e0304ac1f1941ff698217592711453643015
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=framing&catB=frames&CatC=kits&gr=nielsen-bainbridge-wood-frame-kits.html
urltoken CFID=30600716&CFTOKEN=67081466&jsessionid=e0304ac1f1941ff698217592711453643015
validationerror [empty string]


Problem with item sku 33185. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a8010 8010&wt=json&indent=on&fl=*&rows=1000&fq=group_id:8010&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 23406,80148,89487
AvailQtyList: 5.000000000000,1.000000000000,7.000000000000

struct
FLAGS 0
VIP_member_discount 62
barcode 087828263541
barcode_type UPC
col1 black
col1_sortorder 402
col2 26 in.
col2_sortorder 1407
col3 [empty string]
color_swatch 0-0-0.jpg
cost 12.85
deal_of_the_week NO
description black, 26 in.
group_id 8010
group_uname nielsen-bainbridge-wood-frame-kits
id 33185
list_price 42.11
map NO
mfr_num FW16026-41
net_weight 0.56
non_member_discount 52
non_member_price 20.04
prop65 NO
ship_rule_desc STD
shipping STD
sku 33185
sku_pix YES
supplier_id 1
ta_dealer_a_price 16.84
ta_dealer_c_price 14.74
ta_price 21.06
text
array
1 33185
2 FW16026-41
3 black, 26 in.
timestamp 2015-03-31T17:53:14.283Z
vip_member_price 16

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 23406
2 1.000000000000 80148
3 7.000000000000 89487
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '250' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.204.246.41

URL: www.misterart.com:/index.cfm:module=framing&catB=frames&CatC=kits&gr=nielsen-bainbridge-wood-frame-kits.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:31:10'}
sessionid e030daa839daf76342b82b07c4b5b2f527b6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~&gr=paasche-model-v-airbrush-parts.html
urltoken CFID=30600717&CFTOKEN=31822076&jsessionid=e030daa839daf76342b82b07c4b5b2f527b6
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:31:10'}
sessionid e0304ac1f1941ff698217592711453643015
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=framing&catB=frames&CatC=kits&gr=nielsen-bainbridge-wood-frame-kits.html
urltoken CFID=30600716&CFTOKEN=67081466&jsessionid=e0304ac1f1941ff698217592711453643015
validationerror [empty string]


Problem with item sku 40820. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a8010 8010&wt=json&indent=on&fl=*&rows=1000&fq=group_id:8010&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 23406,80148,89487
AvailQtyList: 5.000000000000,1.000000000000,7.000000000000

struct
FLAGS 0
VIP_member_discount 62
barcode 087828363098
barcode_type UPC
col1 black
col1_sortorder 402
col2 34 in.
col2_sortorder 1671
col3 [empty string]
color_swatch 0-0-0.jpg
cost 15.77
deal_of_the_week NO
description black, 34 in.
group_id 8010
group_uname nielsen-bainbridge-wood-frame-kits
id 40820
list_price 51.71
map NO
mfr_num FW16034-41
net_weight 0.75
non_member_discount 52
non_member_price 24.61
prop65 NO
ship_rule_desc STD
shipping STD
sku 40820
sku_pix YES
supplier_id 1
ta_dealer_a_price 20.68
ta_dealer_c_price 18.1
ta_price 25.86
text
array
1 40820
2 FW16034-41
3 black, 34 in.
timestamp 2015-03-31T17:53:24.298Z
vip_member_price 19.65

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 23406
2 1.000000000000 80148
3 7.000000000000 89487
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '250' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.204.246.41

URL: www.misterart.com:/index.cfm:module=framing&catB=frames&CatC=kits&gr=nielsen-bainbridge-wood-frame-kits.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:31:10'}
sessionid e030daa839daf76342b82b07c4b5b2f527b6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~&gr=paasche-model-v-airbrush-parts.html
urltoken CFID=30600717&CFTOKEN=31822076&jsessionid=e030daa839daf76342b82b07c4b5b2f527b6
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:31:10'}
sessionid e0304ac1f1941ff698217592711453643015
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=framing&catB=frames&CatC=kits&gr=nielsen-bainbridge-wood-frame-kits.html
urltoken CFID=30600716&CFTOKEN=67081466&jsessionid=e0304ac1f1941ff698217592711453643015
validationerror [empty string]


Problem with item sku 43767. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a8010 8010&wt=json&indent=on&fl=*&rows=1000&fq=group_id:8010&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 23406,80148,89487
AvailQtyList: 5.000000000000,1.000000000000,7.000000000000

struct
FLAGS 0
VIP_member_discount 62
barcode 087828613735
barcode_type UPC
col1 black
col1_sortorder 402
col2 12 in.
col2_sortorder 832
col3 [empty string]
color_swatch 0-0-0.jpg
cost 7.88
deal_of_the_week NO
description black, 12 in.
group_id 8010
group_uname nielsen-bainbridge-wood-frame-kits
id 43767
list_price 25.83
map NO
mfr_num FW16012-41
net_weight 0.56
non_member_discount 52
non_member_price 12.3
prop65 NO
ship_rule_desc STD
shipping STD
sku 43767
sku_pix YES
supplier_id 1
ta_dealer_a_price 10.33
ta_dealer_c_price 9.04
ta_price 12.92
text
array
1 43767
2 FW16012-41
3 black, 12 in.
timestamp 2015-03-31T17:53:28.686Z
vip_member_price 9.82

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 23406
2 1.000000000000 80148
3 7.000000000000 89487
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '250' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.204.246.41

URL: www.misterart.com:/index.cfm:module=framing&catB=frames&CatC=kits&gr=nielsen-bainbridge-wood-frame-kits.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:31:10'}
sessionid e030daa839daf76342b82b07c4b5b2f527b6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~&gr=paasche-model-v-airbrush-parts.html
urltoken CFID=30600717&CFTOKEN=31822076&jsessionid=e030daa839daf76342b82b07c4b5b2f527b6
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:31:10'}
sessionid e0304ac1f1941ff698217592711453643015
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=framing&catB=frames&CatC=kits&gr=nielsen-bainbridge-wood-frame-kits.html
urltoken CFID=30600716&CFTOKEN=67081466&jsessionid=e0304ac1f1941ff698217592711453643015
validationerror [empty string]


Problem with item sku 44303. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a8010 8010&wt=json&indent=on&fl=*&rows=1000&fq=group_id:8010&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 23406,80148,89487
AvailQtyList: 5.000000000000,1.000000000000,7.000000000000

struct
FLAGS 0
VIP_member_discount 62
barcode 087828143218
barcode_type UPC
col1 black
col1_sortorder 402
col2 9 in.
col2_sortorder 2368
col3 [empty string]
color_swatch 0-0-0.jpg
cost 7.06
deal_of_the_week NO
description black, 9 in.
group_id 8010
group_uname nielsen-bainbridge-wood-frame-kits
id 44303
list_price 23.15
map NO
mfr_num FW16009-41
net_weight 0.56
non_member_discount 52
non_member_price 11.02
prop65 NO
ship_rule_desc STD
shipping STD
sku 44303
sku_pix YES
supplier_id 1
ta_dealer_a_price 9.26
ta_dealer_c_price 8.1
ta_price 11.58
text
array
1 44303
2 FW16009-41
3 black, 9 in.
timestamp 2015-03-31T17:53:29.555Z
vip_member_price 8.8

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 23406
2 1.000000000000 80148
3 7.000000000000 89487
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '250' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.204.246.41

URL: www.misterart.com:/index.cfm:module=framing&catB=frames&CatC=kits&gr=nielsen-bainbridge-wood-frame-kits.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:31:10'}
sessionid e030daa839daf76342b82b07c4b5b2f527b6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~&gr=paasche-model-v-airbrush-parts.html
urltoken CFID=30600717&CFTOKEN=31822076&jsessionid=e030daa839daf76342b82b07c4b5b2f527b6
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:31:10'}
sessionid e0304ac1f1941ff698217592711453643015
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=framing&catB=frames&CatC=kits&gr=nielsen-bainbridge-wood-frame-kits.html
urltoken CFID=30600716&CFTOKEN=67081466&jsessionid=e0304ac1f1941ff698217592711453643015
validationerror [empty string]


Problem with item sku 45260. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a8010 8010&wt=json&indent=on&fl=*&rows=1000&fq=group_id:8010&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 23406,80148,89487
AvailQtyList: 5.000000000000,1.000000000000,7.000000000000

struct
FLAGS 0
VIP_member_discount 62
barcode 087828213508
barcode_type UPC
col1 black
col1_sortorder 402
col2 8 in.
col2_sortorder 2283
col3 [empty string]
color_swatch 0-0-0.jpg
cost 6.64
deal_of_the_week NO
description black, 8 in.
group_id 8010
group_uname nielsen-bainbridge-wood-frame-kits
id 45260
list_price 21.74
map NO
mfr_num FW16008-41
net_weight 0.56
non_member_discount 52
non_member_price 10.35
prop65 NO
ship_rule_desc STD
shipping STD
sku 45260
sku_pix YES
supplier_id 1
ta_dealer_a_price 8.7
ta_dealer_c_price 7.61
ta_price 10.87
text
array
1 45260
2 FW16008-41
3 black, 8 in.
timestamp 2015-03-31T17:53:30.675Z
vip_member_price 8.26

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 23406
2 1.000000000000 80148
3 7.000000000000 89487
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '250' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.204.246.41

URL: www.misterart.com:/index.cfm:module=framing&catB=frames&CatC=kits&gr=nielsen-bainbridge-wood-frame-kits.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:31:10'}
sessionid e030daa839daf76342b82b07c4b5b2f527b6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~&gr=paasche-model-v-airbrush-parts.html
urltoken CFID=30600717&CFTOKEN=31822076&jsessionid=e030daa839daf76342b82b07c4b5b2f527b6
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:31:10'}
sessionid e0304ac1f1941ff698217592711453643015
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=framing&catB=frames&CatC=kits&gr=nielsen-bainbridge-wood-frame-kits.html
urltoken CFID=30600716&CFTOKEN=67081466&jsessionid=e0304ac1f1941ff698217592711453643015
validationerror [empty string]


Problem with item sku 45760. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a8010 8010&wt=json&indent=on&fl=*&rows=1000&fq=group_id:8010&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 23406,80148,89487
AvailQtyList: 5.000000000000,1.000000000000,7.000000000000

struct
FLAGS 0
VIP_member_discount 62
barcode 087828513677
barcode_type UPC
col1 black
col1_sortorder 402
col2 14 in.
col2_sortorder 917
col3 [empty string]
color_swatch 0-0-0.jpg
cost 8.45
deal_of_the_week NO
description black, 14 in.
group_id 8010
group_uname nielsen-bainbridge-wood-frame-kits
id 45760
list_price 27.72
map NO
mfr_num FW16014-41
net_weight 0.56
non_member_discount 52
non_member_price 13.19
prop65 NO
ship_rule_desc STD
shipping STD
sku 45760
sku_pix YES
supplier_id 1
ta_dealer_a_price 11.09
ta_dealer_c_price 9.7
ta_price 13.86
text
array
1 45760
2 FW16014-41
3 black, 14 in.
timestamp 2015-03-31T17:53:31.204Z
vip_member_price 10.53

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 23406
2 1.000000000000 80148
3 7.000000000000 89487
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '250' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.204.246.41

URL: www.misterart.com:/index.cfm:module=framing&catB=frames&CatC=kits&gr=nielsen-bainbridge-wood-frame-kits.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:31:10'}
sessionid e030daa839daf76342b82b07c4b5b2f527b6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~&gr=paasche-model-v-airbrush-parts.html
urltoken CFID=30600717&CFTOKEN=31822076&jsessionid=e030daa839daf76342b82b07c4b5b2f527b6
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:31:10'}
sessionid e0304ac1f1941ff698217592711453643015
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=framing&catB=frames&CatC=kits&gr=nielsen-bainbridge-wood-frame-kits.html
urltoken CFID=30600716&CFTOKEN=67081466&jsessionid=e0304ac1f1941ff698217592711453643015
validationerror [empty string]


Problem with item sku 46906. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a8010 8010&wt=json&indent=on&fl=*&rows=1000&fq=group_id:8010&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 23406,80148,89487
AvailQtyList: 5.000000000000,1.000000000000,7.000000000000

struct
FLAGS 0
VIP_member_discount 62
barcode 087828643299
barcode_type UPC
col1 black
col1_sortorder 402
col2 11 in.
col2_sortorder 778
col3 [empty string]
color_swatch 0-0-0.jpg
cost 7.47
deal_of_the_week NO
description black, 11 in.
group_id 8010
group_uname nielsen-bainbridge-wood-frame-kits
id 46906
list_price 24.47
map NO
mfr_num FW16011-41
net_weight 0.56
non_member_discount 52
non_member_price 11.65
prop65 NO
ship_rule_desc STD
shipping STD
sku 46906
sku_pix YES
supplier_id 1
ta_dealer_a_price 9.79
ta_dealer_c_price 8.56
ta_price 12.24
text
array
1 46906
2 FW16011-41
3 black, 11 in.
timestamp 2015-03-31T17:53:32.448Z
vip_member_price 9.3

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 23406
2 1.000000000000 80148
3 7.000000000000 89487
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '250' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.204.246.41

URL: www.misterart.com:/index.cfm:module=framing&catB=frames&CatC=kits&gr=nielsen-bainbridge-wood-frame-kits.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:31:10'}
sessionid e030daa839daf76342b82b07c4b5b2f527b6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~&gr=paasche-model-v-airbrush-parts.html
urltoken CFID=30600717&CFTOKEN=31822076&jsessionid=e030daa839daf76342b82b07c4b5b2f527b6
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:31:10'}
sessionid e0304ac1f1941ff698217592711453643015
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=framing&catB=frames&CatC=kits&gr=nielsen-bainbridge-wood-frame-kits.html
urltoken CFID=30600716&CFTOKEN=67081466&jsessionid=e0304ac1f1941ff698217592711453643015
validationerror [empty string]


Problem with item sku 50179. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a8010 8010&wt=json&indent=on&fl=*&rows=1000&fq=group_id:8010&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 23406,80148,89487
AvailQtyList: 5.000000000000,1.000000000000,7.000000000000

struct
FLAGS 0
VIP_member_discount 62
barcode 087828643855
barcode_type UPC
col1 black
col1_sortorder 402
col2 30 in.
col2_sortorder 1607
col3 [empty string]
color_swatch 0-0-0.jpg
cost 13.69
deal_of_the_week NO
description black, 30 in.
group_id 8010
group_uname nielsen-bainbridge-wood-frame-kits
id 50179
list_price 44.89
map NO
mfr_num FW16030-41
net_weight 0.63
non_member_discount 52
non_member_price 21.37
prop65 NO
ship_rule_desc STD
shipping STD
sku 50179
sku_pix YES
supplier_id 1
ta_dealer_a_price 17.96
ta_dealer_c_price 15.71
ta_price 22.45
text
array
1 50179
2 FW16030-41
3 black, 30 in.
timestamp 2015-03-31T17:53:36.964Z
vip_member_price 17.06

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 23406
2 1.000000000000 80148
3 7.000000000000 89487
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '250' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.204.246.41

URL: www.misterart.com:/index.cfm:module=framing&catB=frames&CatC=kits&gr=nielsen-bainbridge-wood-frame-kits.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:31:10'}
sessionid e030daa839daf76342b82b07c4b5b2f527b6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~&gr=paasche-model-v-airbrush-parts.html
urltoken CFID=30600717&CFTOKEN=31822076&jsessionid=e030daa839daf76342b82b07c4b5b2f527b6
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:31:10'}
sessionid e0304ac1f1941ff698217592711453643015
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=framing&catB=frames&CatC=kits&gr=nielsen-bainbridge-wood-frame-kits.html
urltoken CFID=30600716&CFTOKEN=67081466&jsessionid=e0304ac1f1941ff698217592711453643015
validationerror [empty string]


Problem with item sku 54822. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a8010 8010&wt=json&indent=on&fl=*&rows=1000&fq=group_id:8010&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 23406,80148,89487
AvailQtyList: 5.000000000000,1.000000000000,7.000000000000

struct
FLAGS 0
VIP_member_discount 62
barcode 087828523652
barcode_type UPC
col1 black
col1_sortorder 402
col2 36 in.
col2_sortorder 1679
col3 [empty string]
color_swatch 0-0-0.jpg
cost 16.18
deal_of_the_week NO
description black, 36 in.
group_id 8010
group_uname nielsen-bainbridge-wood-frame-kits
id 54822
list_price 53.03
map NO
mfr_num FW16036-41
net_weight 0.75
non_member_discount 52
non_member_price 25.24
prop65 NO
ship_rule_desc STD
shipping STD
sku 54822
sku_pix YES
supplier_id 1
ta_dealer_a_price 21.21
ta_dealer_c_price 18.56
ta_price 26.52
text
array
1 54822
2 FW16036-41
3 black, 36 in.
timestamp 2015-03-31T17:53:48.003Z
vip_member_price 20.15

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 23406
2 1.000000000000 80148
3 7.000000000000 89487
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '250' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.204.246.41

URL: www.misterart.com:/index.cfm:module=framing&catB=frames&CatC=kits&gr=nielsen-bainbridge-wood-frame-kits.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:31:10'}
sessionid e030daa839daf76342b82b07c4b5b2f527b6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~&gr=paasche-model-v-airbrush-parts.html
urltoken CFID=30600717&CFTOKEN=31822076&jsessionid=e030daa839daf76342b82b07c4b5b2f527b6
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:31:10'}
sessionid e0304ac1f1941ff698217592711453643015
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=framing&catB=frames&CatC=kits&gr=nielsen-bainbridge-wood-frame-kits.html
urltoken CFID=30600716&CFTOKEN=67081466&jsessionid=e0304ac1f1941ff698217592711453643015
validationerror [empty string]


Problem with item sku 57043. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a8010 8010&wt=json&indent=on&fl=*&rows=1000&fq=group_id:8010&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 23406,80148,89487
AvailQtyList: 5.000000000000,1.000000000000,7.000000000000

struct
FLAGS 0
VIP_member_discount 62
barcode 087828943634
barcode_type UPC
col1 black
col1_sortorder 402
col2 21 in.
col2_sortorder 1284
col3 [empty string]
color_swatch 0-0-0.jpg
cost 10.77
deal_of_the_week NO
description black, 21 in.
group_id 8010
group_uname nielsen-bainbridge-wood-frame-kits
id 57043
list_price 35.33
map NO
mfr_num FW16021-41
net_weight 0.56
non_member_discount 52
non_member_price 16.82
prop65 NO
ship_rule_desc STD
shipping STD
sku 57043
sku_pix YES
supplier_id 1
ta_dealer_a_price 14.13
ta_dealer_c_price 12.37
ta_price 17.67
text
array
1 57043
2 FW16021-41
3 black, 21 in.
timestamp 2015-03-31T17:53:51.15Z
vip_member_price 13.43

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 23406
2 1.000000000000 80148
3 7.000000000000 89487
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '250' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.204.246.41

URL: www.misterart.com:/index.cfm:module=framing&catB=frames&CatC=kits&gr=nielsen-bainbridge-wood-frame-kits.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:31:10'}
sessionid e030daa839daf76342b82b07c4b5b2f527b6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~&gr=paasche-model-v-airbrush-parts.html
urltoken CFID=30600717&CFTOKEN=31822076&jsessionid=e030daa839daf76342b82b07c4b5b2f527b6
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:31:10'}
sessionid e0304ac1f1941ff698217592711453643015
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=framing&catB=frames&CatC=kits&gr=nielsen-bainbridge-wood-frame-kits.html
urltoken CFID=30600716&CFTOKEN=67081466&jsessionid=e0304ac1f1941ff698217592711453643015
validationerror [empty string]


Problem with item sku 59668. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a8010 8010&wt=json&indent=on&fl=*&rows=1000&fq=group_id:8010&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 23406,80148,89487
AvailQtyList: 5.000000000000,1.000000000000,7.000000000000

struct
FLAGS 0
VIP_member_discount 62
barcode 087828363609
barcode_type UPC
col1 black
col1_sortorder 402
col2 13 in.
col2_sortorder 900
col3 [empty string]
color_swatch 0-0-0.jpg
cost 8.21
deal_of_the_week NO
description black, 13 in.
group_id 8010
group_uname nielsen-bainbridge-wood-frame-kits
id 59668
list_price 26.93
map NO
mfr_num FW16013-41
net_weight 0.56
non_member_discount 52
non_member_price 12.82
prop65 NO
ship_rule_desc STD
shipping STD
sku 59668
sku_pix YES
supplier_id 1
ta_dealer_a_price 10.77
ta_dealer_c_price 9.43
ta_price 13.47
text
array
1 59668
2 FW16013-41
3 black, 13 in.
timestamp 2015-03-31T17:53:53.92Z
vip_member_price 10.23

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 23406
2 1.000000000000 80148
3 7.000000000000 89487
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '250' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.204.246.41

URL: www.misterart.com:/index.cfm:module=framing&catB=frames&CatC=kits&gr=nielsen-bainbridge-wood-frame-kits.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:31:10'}
sessionid e030daa839daf76342b82b07c4b5b2f527b6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~&gr=paasche-model-v-airbrush-parts.html
urltoken CFID=30600717&CFTOKEN=31822076&jsessionid=e030daa839daf76342b82b07c4b5b2f527b6
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:31:10'}
sessionid e0304ac1f1941ff698217592711453643015
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=framing&catB=frames&CatC=kits&gr=nielsen-bainbridge-wood-frame-kits.html
urltoken CFID=30600716&CFTOKEN=67081466&jsessionid=e0304ac1f1941ff698217592711453643015
validationerror [empty string]


Problem with item sku 61319. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a8010 8010&wt=json&indent=on&fl=*&rows=1000&fq=group_id:8010&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 23406,80148,89487
AvailQtyList: 5.000000000000,1.000000000000,7.000000000000

struct
FLAGS 0
VIP_member_discount 62
barcode 087828103878
barcode_type UPC
col1 black
col1_sortorder 402
col2 15 in.
col2_sortorder 952
col3 [empty string]
color_swatch 0-0-0.jpg
cost 8.7
deal_of_the_week NO
description black, 15 in.
group_id 8010
group_uname nielsen-bainbridge-wood-frame-kits
id 61319
list_price 28.51
map NO
mfr_num FW16015-41
net_weight 0.56
non_member_discount 52
non_member_price 13.57
prop65 NO
ship_rule_desc STD
shipping STD
sku 61319
sku_pix YES
supplier_id 1
ta_dealer_a_price 11.4
ta_dealer_c_price 9.98
ta_price 14.26
text
array
1 61319
2 FW16015-41
3 black, 15 in.
timestamp 2015-03-31T17:54:00.651Z
vip_member_price 10.83

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 23406
2 1.000000000000 80148
3 7.000000000000 89487
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '250' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.204.246.41

URL: www.misterart.com:/index.cfm:module=framing&catB=frames&CatC=kits&gr=nielsen-bainbridge-wood-frame-kits.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:31:10'}
sessionid e030daa839daf76342b82b07c4b5b2f527b6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~&gr=paasche-model-v-airbrush-parts.html
urltoken CFID=30600717&CFTOKEN=31822076&jsessionid=e030daa839daf76342b82b07c4b5b2f527b6
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:31:10'}
sessionid e0304ac1f1941ff698217592711453643015
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=framing&catB=frames&CatC=kits&gr=nielsen-bainbridge-wood-frame-kits.html
urltoken CFID=30600716&CFTOKEN=67081466&jsessionid=e0304ac1f1941ff698217592711453643015
validationerror [empty string]


Problem with item sku 61633. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a8010 8010&wt=json&indent=on&fl=*&rows=1000&fq=group_id:8010&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 23406,80148,89487
AvailQtyList: 5.000000000000,1.000000000000,7.000000000000

struct
FLAGS 0
VIP_member_discount 62
barcode 087828843293
barcode_type UPC
col1 black
col1_sortorder 402
col2 22 in.
col2_sortorder 1296
col3 [empty string]
color_swatch 0-0-0.jpg
cost 11.22
deal_of_the_week NO
description black, 22 in.
group_id 8010
group_uname nielsen-bainbridge-wood-frame-kits
id 61633
list_price 36.8
map NO
mfr_num FW16022-41
net_weight 0.56
non_member_discount 52
non_member_price 17.52
prop65 NO
ship_rule_desc STD
shipping STD
sku 61633
sku_pix YES
supplier_id 1
ta_dealer_a_price 14.72
ta_dealer_c_price 12.88
ta_price 18.4
text
array
1 61633
2 FW16022-41
3 black, 22 in.
timestamp 2015-03-31T17:54:01.559Z
vip_member_price 13.98

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 23406
2 1.000000000000 80148
3 7.000000000000 89487
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '250' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.204.246.41

URL: www.misterart.com:/index.cfm:module=framing&catB=frames&CatC=kits&gr=nielsen-bainbridge-wood-frame-kits.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:31:10'}
sessionid e030daa839daf76342b82b07c4b5b2f527b6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~&gr=paasche-model-v-airbrush-parts.html
urltoken CFID=30600717&CFTOKEN=31822076&jsessionid=e030daa839daf76342b82b07c4b5b2f527b6
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:31:10'}
sessionid e0304ac1f1941ff698217592711453643015
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=framing&catB=frames&CatC=kits&gr=nielsen-bainbridge-wood-frame-kits.html
urltoken CFID=30600716&CFTOKEN=67081466&jsessionid=e0304ac1f1941ff698217592711453643015
validationerror [empty string]


Problem with item sku 62196. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a8010 8010&wt=json&indent=on&fl=*&rows=1000&fq=group_id:8010&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 23406,80148,89487
AvailQtyList: 5.000000000000,1.000000000000,7.000000000000

struct
FLAGS 0
VIP_member_discount 62
barcode 087828863802
barcode_type UPC
col1 black
col1_sortorder 402
col2 25 in.
col2_sortorder 1382
col3 [empty string]
color_swatch 0-0-0.jpg
cost 12.43
deal_of_the_week NO
description black, 25 in.
group_id 8010
group_uname nielsen-bainbridge-wood-frame-kits
id 62196
list_price 40.74
map NO
mfr_num FW16025-41
net_weight 0.56
non_member_discount 52
non_member_price 19.39
prop65 NO
ship_rule_desc STD
shipping STD
sku 62196
sku_pix YES
supplier_id 1
ta_dealer_a_price 16.3
ta_dealer_c_price 14.26
ta_price 20.37
text
array
1 62196
2 FW16025-41
3 black, 25 in.
timestamp 2015-03-31T17:54:02.698Z
vip_member_price 15.48

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 23406
2 1.000000000000 80148
3 7.000000000000 89487
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '250' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.204.246.41

URL: www.misterart.com:/index.cfm:module=framing&catB=frames&CatC=kits&gr=nielsen-bainbridge-wood-frame-kits.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:31:10'}
sessionid e030daa839daf76342b82b07c4b5b2f527b6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~&gr=paasche-model-v-airbrush-parts.html
urltoken CFID=30600717&CFTOKEN=31822076&jsessionid=e030daa839daf76342b82b07c4b5b2f527b6
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:31:10'}
sessionid e0304ac1f1941ff698217592711453643015
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=framing&catB=frames&CatC=kits&gr=nielsen-bainbridge-wood-frame-kits.html
urltoken CFID=30600716&CFTOKEN=67081466&jsessionid=e0304ac1f1941ff698217592711453643015
validationerror [empty string]


Problem with item sku 69398. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a8010 8010&wt=json&indent=on&fl=*&rows=1000&fq=group_id:8010&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 23406,80148,89487
AvailQtyList: 5.000000000000,1.000000000000,7.000000000000

struct
FLAGS 0
VIP_member_discount 62
barcode 087828973136
barcode_type UPC
col1 black
col1_sortorder 402
col2 10 in.
col2_sortorder 711
col3 [empty string]
color_swatch 0-0-0.jpg
cost 7.17
deal_of_the_week NO
description black, 10 in.
group_id 8010
group_uname nielsen-bainbridge-wood-frame-kits
id 69398
list_price 23.52
map NO
mfr_num FW16010-41
net_weight 0.56
non_member_discount 52
non_member_price 11.2
prop65 NO
ship_rule_desc STD
shipping STD
sku 69398
sku_pix YES
supplier_id 1
ta_dealer_a_price 9.41
ta_dealer_c_price 8.23
ta_price 11.76
text
array
1 69398
2 FW16010-41
3 black, 10 in.
timestamp 2015-03-31T17:54:16.752Z
vip_member_price 8.94

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 23406
2 1.000000000000 80148
3 7.000000000000 89487
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '250' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.204.246.41

URL: www.misterart.com:/index.cfm:module=framing&catB=frames&CatC=kits&gr=nielsen-bainbridge-wood-frame-kits.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:31:10'}
sessionid e030daa839daf76342b82b07c4b5b2f527b6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~&gr=paasche-model-v-airbrush-parts.html
urltoken CFID=30600717&CFTOKEN=31822076&jsessionid=e030daa839daf76342b82b07c4b5b2f527b6
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:31:10'}
sessionid e0304ac1f1941ff698217592711453643015
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=framing&catB=frames&CatC=kits&gr=nielsen-bainbridge-wood-frame-kits.html
urltoken CFID=30600716&CFTOKEN=67081466&jsessionid=e0304ac1f1941ff698217592711453643015
validationerror [empty string]


Problem with item sku 71154. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a8010 8010&wt=json&indent=on&fl=*&rows=1000&fq=group_id:8010&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 23406,80148,89487
AvailQtyList: 5.000000000000,1.000000000000,7.000000000000

struct
FLAGS 0
VIP_member_discount 62
barcode 087828183566
barcode_type UPC
col1 black
col1_sortorder 402
col2 19 in.
col2_sortorder 1103
col3 [empty string]
color_swatch 0-0-0.jpg
cost 10.2
deal_of_the_week NO
description black, 19 in.
group_id 8010
group_uname nielsen-bainbridge-wood-frame-kits
id 71154
list_price 33.44
map NO
mfr_num FW16019-41
net_weight 0.56
non_member_discount 52
non_member_price 15.92
prop65 NO
ship_rule_desc STD
shipping STD
sku 71154
sku_pix YES
supplier_id 1
ta_dealer_a_price 13.38
ta_dealer_c_price 11.7
ta_price 16.72
text
array
1 71154
2 FW16019-41
3 black, 19 in.
timestamp 2015-03-31T17:54:20.57Z
vip_member_price 12.71

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 23406
2 1.000000000000 80148
3 7.000000000000 89487
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '250' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.204.246.41

URL: www.misterart.com:/index.cfm:module=framing&catB=frames&CatC=kits&gr=nielsen-bainbridge-wood-frame-kits.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:31:10'}
sessionid e030daa839daf76342b82b07c4b5b2f527b6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~&gr=paasche-model-v-airbrush-parts.html
urltoken CFID=30600717&CFTOKEN=31822076&jsessionid=e030daa839daf76342b82b07c4b5b2f527b6
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:31:10'}
sessionid e0304ac1f1941ff698217592711453643015
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=framing&catB=frames&CatC=kits&gr=nielsen-bainbridge-wood-frame-kits.html
urltoken CFID=30600716&CFTOKEN=67081466&jsessionid=e0304ac1f1941ff698217592711453643015
validationerror [empty string]


Problem with item sku 72011. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a8010 8010&wt=json&indent=on&fl=*&rows=1000&fq=group_id:8010&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 23406,80148,89487
AvailQtyList: 5.000000000000,1.000000000000,7.000000000000

struct
FLAGS 0
VIP_member_discount 62
barcode 087828603255
barcode_type UPC
col1 black
col1_sortorder 402
col2 38 in.
col2_sortorder 1717
col3 [empty string]
color_swatch 0-0-0.jpg
cost 16.59
deal_of_the_week NO
description black, 38 in.
group_id 8010
group_uname nielsen-bainbridge-wood-frame-kits
id 72011
list_price 54.39
map NO
mfr_num FW16038-41
net_weight 0.88
non_member_discount 52
non_member_price 25.89
prop65 NO
ship_rule_desc STD
shipping STD
sku 72011
sku_pix YES
supplier_id 1
ta_dealer_a_price 21.76
ta_dealer_c_price 19.04
ta_price 27.2
text
array
1 72011
2 FW16038-41
3 black, 38 in.
timestamp 2015-03-31T17:54:22.273Z
vip_member_price 20.67

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 23406
2 1.000000000000 80148
3 7.000000000000 89487
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '250' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.204.246.41

URL: www.misterart.com:/index.cfm:module=framing&catB=frames&CatC=kits&gr=nielsen-bainbridge-wood-frame-kits.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:31:10'}
sessionid e030daa839daf76342b82b07c4b5b2f527b6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~&gr=paasche-model-v-airbrush-parts.html
urltoken CFID=30600717&CFTOKEN=31822076&jsessionid=e030daa839daf76342b82b07c4b5b2f527b6
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:31:10'}
sessionid e0304ac1f1941ff698217592711453643015
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=framing&catB=frames&CatC=kits&gr=nielsen-bainbridge-wood-frame-kits.html
urltoken CFID=30600716&CFTOKEN=67081466&jsessionid=e0304ac1f1941ff698217592711453643015
validationerror [empty string]


Problem with item sku 72189. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a8010 8010&wt=json&indent=on&fl=*&rows=1000&fq=group_id:8010&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 23406,80148,89487
AvailQtyList: 5.000000000000,1.000000000000,7.000000000000

struct
FLAGS 0
VIP_member_discount 62
barcode 087828823905
barcode_type UPC
col1 black
col1_sortorder 402
col2 40 in.
col2_sortorder 1833
col3 [empty string]
color_swatch 0-0-0.jpg
cost 17.01
deal_of_the_week NO
description black, 40 in.
group_id 8010
group_uname nielsen-bainbridge-wood-frame-kits
id 72189
list_price 55.76
map NO
mfr_num FW16040-41
net_weight 0.88
non_member_discount 52
non_member_price 26.54
prop65 NO
ship_rule_desc STD
shipping STD
sku 72189
sku_pix YES
supplier_id 1
ta_dealer_a_price 22.3
ta_dealer_c_price 19.52
ta_price 27.88
text
array
1 72189
2 FW16040-41
3 black, 40 in.
timestamp 2015-03-31T17:54:22.53Z
vip_member_price 21.19

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 23406
2 1.000000000000 80148
3 7.000000000000 89487
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '250' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.204.246.41

URL: www.misterart.com:/index.cfm:module=framing&catB=frames&CatC=kits&gr=nielsen-bainbridge-wood-frame-kits.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:31:10'}
sessionid e030daa839daf76342b82b07c4b5b2f527b6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~&gr=paasche-model-v-airbrush-parts.html
urltoken CFID=30600717&CFTOKEN=31822076&jsessionid=e030daa839daf76342b82b07c4b5b2f527b6
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:31:10'}
sessionid e0304ac1f1941ff698217592711453643015
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=framing&catB=frames&CatC=kits&gr=nielsen-bainbridge-wood-frame-kits.html
urltoken CFID=30600716&CFTOKEN=67081466&jsessionid=e0304ac1f1941ff698217592711453643015
validationerror [empty string]


Problem with item sku 87357. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a8010 8010&wt=json&indent=on&fl=*&rows=1000&fq=group_id:8010&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 23406,80148,89487
AvailQtyList: 5.000000000000,1.000000000000,7.000000000000

struct
FLAGS 0
VIP_member_discount 62
barcode 087828893588
barcode_type UPC
col1 black
col1_sortorder 402
col2 18 in.
col2_sortorder 1055
col3 [empty string]
color_swatch 0-0-0.jpg
cost 9.8
deal_of_the_week NO
description black, 18 in.
group_id 8010
group_uname nielsen-bainbridge-wood-frame-kits
id 87357
list_price 32.13
map NO
mfr_num FW16018-41
net_weight 0.56
non_member_discount 52
non_member_price 15.29
prop65 NO
ship_rule_desc STD
shipping STD
sku 87357
sku_pix YES
supplier_id 1
ta_dealer_a_price 12.85
ta_dealer_c_price 11.25
ta_price 16.07
text
array
1 87357
2 FW16018-41
3 black, 18 in.
timestamp 2015-03-31T17:54:40.628Z
vip_member_price 12.21

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 23406
2 1.000000000000 80148
3 7.000000000000 89487
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '250' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.204.246.41

URL: www.misterart.com:/index.cfm:module=framing&catB=frames&CatC=kits&gr=nielsen-bainbridge-wood-frame-kits.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:31:10'}
sessionid e030daa839daf76342b82b07c4b5b2f527b6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~&gr=paasche-model-v-airbrush-parts.html
urltoken CFID=30600717&CFTOKEN=31822076&jsessionid=e030daa839daf76342b82b07c4b5b2f527b6
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:31:10'}
sessionid e0304ac1f1941ff698217592711453643015
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=framing&catB=frames&CatC=kits&gr=nielsen-bainbridge-wood-frame-kits.html
urltoken CFID=30600716&CFTOKEN=67081466&jsessionid=e0304ac1f1941ff698217592711453643015
validationerror [empty string]


Problem with item sku 89557. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a8010 8010&wt=json&indent=on&fl=*&rows=1000&fq=group_id:8010&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 23406,80148,89487
AvailQtyList: 5.000000000000,1.000000000000,7.000000000000

struct
FLAGS 0
VIP_member_discount 62
barcode 087828923582
barcode_type UPC
col1 black
col1_sortorder 402
col2 24 in.
col2_sortorder 1331
col3 [empty string]
color_swatch 0-0-0.jpg
cost 12.02
deal_of_the_week NO
description black, 24 in.
group_id 8010
group_uname nielsen-bainbridge-wood-frame-kits
id 89557
list_price 39.38
map NO
mfr_num FW16024-41
net_weight 0.56
non_member_discount 52
non_member_price 18.74
prop65 NO
ship_rule_desc STD
shipping STD
sku 89557
sku_pix YES
supplier_id 1
ta_dealer_a_price 15.75
ta_dealer_c_price 13.78
ta_price 19.69
text
array
1 89557
2 FW16024-41
3 black, 24 in.
timestamp 2015-03-31T17:54:43.081Z
vip_member_price 14.96

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 23406
2 1.000000000000 80148
3 7.000000000000 89487
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '250' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.204.246.41

URL: www.misterart.com:/index.cfm:module=framing&catB=frames&CatC=kits&gr=nielsen-bainbridge-wood-frame-kits.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:31:10'}
sessionid e030daa839daf76342b82b07c4b5b2f527b6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~&gr=paasche-model-v-airbrush-parts.html
urltoken CFID=30600717&CFTOKEN=31822076&jsessionid=e030daa839daf76342b82b07c4b5b2f527b6
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:31:10'}
sessionid e0304ac1f1941ff698217592711453643015
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=framing&catB=frames&CatC=kits&gr=nielsen-bainbridge-wood-frame-kits.html
urltoken CFID=30600716&CFTOKEN=67081466&jsessionid=e0304ac1f1941ff698217592711453643015
validationerror [empty string]


Problem with item sku 17549. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a8010 8010&wt=json&indent=on&fl=*&rows=1000&fq=group_id:8010&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 23406,80148,89487
AvailQtyList: 5.000000000000,1.000000000000,7.000000000000

struct
FLAGS 0
VIP_member_discount 62
barcode 087828323740
barcode_type UPC
col1 natural
col1_sortorder 3932
col2 13 in.
col2_sortorder 900
col3 [empty string]
color_swatch 240-208-183.jpg
cost 8.21
deal_of_the_week NO
description natural, 13 in.
group_id 8010
group_uname nielsen-bainbridge-wood-frame-kits
id 17549
list_price 26.93
map NO
mfr_num FW16013-46
net_weight 0.56
non_member_discount 52
non_member_price 12.82
prop65 NO
ship_rule_desc STD
shipping STD
sku 17549
sku_pix YES
supplier_id 1
ta_dealer_a_price 10.77
ta_dealer_c_price 9.43
ta_price 13.47
text
array
1 17549
2 FW16013-46
3 natural, 13 in.
timestamp 2015-03-31T17:52:48.896Z
vip_member_price 10.23

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 23406
2 1.000000000000 80148
3 7.000000000000 89487
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '250' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.204.246.41

URL: www.misterart.com:/index.cfm:module=framing&catB=frames&CatC=kits&gr=nielsen-bainbridge-wood-frame-kits.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:31:10'}
sessionid e030daa839daf76342b82b07c4b5b2f527b6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~&gr=paasche-model-v-airbrush-parts.html
urltoken CFID=30600717&CFTOKEN=31822076&jsessionid=e030daa839daf76342b82b07c4b5b2f527b6
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:31:10'}
sessionid e0304ac1f1941ff698217592711453643015
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=framing&catB=frames&CatC=kits&gr=nielsen-bainbridge-wood-frame-kits.html
urltoken CFID=30600716&CFTOKEN=67081466&jsessionid=e0304ac1f1941ff698217592711453643015
validationerror [empty string]


Problem with item sku 18310. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a8010 8010&wt=json&indent=on&fl=*&rows=1000&fq=group_id:8010&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 23406,80148,89487
AvailQtyList: 5.000000000000,1.000000000000,7.000000000000

struct
FLAGS 0
VIP_member_discount 62
barcode 087828903614
barcode_type UPC
col1 natural
col1_sortorder 3932
col2 30 in.
col2_sortorder 1607
col3 [empty string]
color_swatch 240-208-183.jpg
cost 13.69
deal_of_the_week NO
description natural, 30 in.
group_id 8010
group_uname nielsen-bainbridge-wood-frame-kits
id 18310
list_price 44.89
map NO
mfr_num FW16030-46
net_weight 0.75
non_member_discount 52
non_member_price 21.37
prop65 NO
ship_rule_desc STD
shipping STD
sku 18310
sku_pix YES
supplier_id 1
ta_dealer_a_price 17.96
ta_dealer_c_price 15.71
ta_price 22.45
text
array
1 18310
2 FW16030-46
3 natural, 30 in.
timestamp 2015-03-31T17:52:50.209Z
vip_member_price 17.06

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 23406
2 1.000000000000 80148
3 7.000000000000 89487
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '250' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.204.246.41

URL: www.misterart.com:/index.cfm:module=framing&catB=frames&CatC=kits&gr=nielsen-bainbridge-wood-frame-kits.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:31:10'}
sessionid e030daa839daf76342b82b07c4b5b2f527b6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~&gr=paasche-model-v-airbrush-parts.html
urltoken CFID=30600717&CFTOKEN=31822076&jsessionid=e030daa839daf76342b82b07c4b5b2f527b6
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:31:10'}
sessionid e0304ac1f1941ff698217592711453643015
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=framing&catB=frames&CatC=kits&gr=nielsen-bainbridge-wood-frame-kits.html
urltoken CFID=30600716&CFTOKEN=67081466&jsessionid=e0304ac1f1941ff698217592711453643015
validationerror [empty string]


Problem with item sku 18719. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a8010 8010&wt=json&indent=on&fl=*&rows=1000&fq=group_id:8010&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 23406,80148,89487
AvailQtyList: 5.000000000000,1.000000000000,7.000000000000

struct
FLAGS 0
VIP_member_discount 62
barcode 087828243840
barcode_type UPC
col1 natural
col1_sortorder 3932
col2 15 in.
col2_sortorder 952
col3 [empty string]
color_swatch 240-208-183.jpg
cost 8.7
deal_of_the_week NO
description natural, 15 in.
group_id 8010
group_uname nielsen-bainbridge-wood-frame-kits
id 18719
list_price 28.51
map NO
mfr_num FW16015-46
net_weight 0.56
non_member_discount 52
non_member_price 13.57
prop65 NO
ship_rule_desc STD
shipping STD
sku 18719
sku_pix YES
supplier_id 1
ta_dealer_a_price 11.4
ta_dealer_c_price 9.98
ta_price 14.26
text
array
1 18719
2 FW16015-46
3 natural, 15 in.
timestamp 2015-03-31T17:52:50.799Z
vip_member_price 10.83

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 23406
2 1.000000000000 80148
3 7.000000000000 89487
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '250' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.204.246.41

URL: www.misterart.com:/index.cfm:module=framing&catB=frames&CatC=kits&gr=nielsen-bainbridge-wood-frame-kits.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:31:10'}
sessionid e030daa839daf76342b82b07c4b5b2f527b6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~&gr=paasche-model-v-airbrush-parts.html
urltoken CFID=30600717&CFTOKEN=31822076&jsessionid=e030daa839daf76342b82b07c4b5b2f527b6
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:31:10'}
sessionid e0304ac1f1941ff698217592711453643015
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=framing&catB=frames&CatC=kits&gr=nielsen-bainbridge-wood-frame-kits.html
urltoken CFID=30600716&CFTOKEN=67081466&jsessionid=e0304ac1f1941ff698217592711453643015
validationerror [empty string]


Problem with item sku 18811. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a8010 8010&wt=json&indent=on&fl=*&rows=1000&fq=group_id:8010&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 23406,80148,89487
AvailQtyList: 5.000000000000,1.000000000000,7.000000000000

struct
FLAGS 0
VIP_member_discount 62
barcode 087828513240
barcode_type UPC
col1 natural
col1_sortorder 3932
col2 34 in.
col2_sortorder 1671
col3 [empty string]
color_swatch 240-208-183.jpg
cost 15.77
deal_of_the_week NO
description natural, 34 in.
group_id 8010
group_uname nielsen-bainbridge-wood-frame-kits
id 18811
list_price 51.71
map NO
mfr_num FW16034-46
net_weight 0.88
non_member_discount 52
non_member_price 24.61
prop65 NO
ship_rule_desc STD
shipping STD
sku 18811
sku_pix YES
supplier_id 1
ta_dealer_a_price 20.68
ta_dealer_c_price 18.1
ta_price 25.86
text
array
1 18811
2 FW16034-46
3 natural, 34 in.
timestamp 2015-03-31T17:52:50.912Z
vip_member_price 19.65

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 23406
2 1.000000000000 80148
3 7.000000000000 89487
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '250' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.204.246.41

URL: www.misterart.com:/index.cfm:module=framing&catB=frames&CatC=kits&gr=nielsen-bainbridge-wood-frame-kits.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:31:10'}
sessionid e030daa839daf76342b82b07c4b5b2f527b6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~&gr=paasche-model-v-airbrush-parts.html
urltoken CFID=30600717&CFTOKEN=31822076&jsessionid=e030daa839daf76342b82b07c4b5b2f527b6
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:31:10'}
sessionid e0304ac1f1941ff698217592711453643015
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=framing&catB=frames&CatC=kits&gr=nielsen-bainbridge-wood-frame-kits.html
urltoken CFID=30600716&CFTOKEN=67081466&jsessionid=e0304ac1f1941ff698217592711453643015
validationerror [empty string]


Problem with item sku 22977. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a8010 8010&wt=json&indent=on&fl=*&rows=1000&fq=group_id:8010&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 23406,80148,89487
AvailQtyList: 5.000000000000,1.000000000000,7.000000000000

struct
FLAGS 0
VIP_member_discount 62
barcode 087828643732
barcode_type UPC
col1 natural
col1_sortorder 3932
col2 27 in.
col2_sortorder 1415
col3 [empty string]
color_swatch 240-208-183.jpg
cost 13.05
deal_of_the_week NO
description natural, 27 in.
group_id 8010
group_uname nielsen-bainbridge-wood-frame-kits
id 22977
list_price 42.79
map NO
mfr_num FW16027-46
net_weight 0.75
non_member_discount 52
non_member_price 20.37
prop65 NO
ship_rule_desc STD
shipping STD
sku 22977
sku_pix YES
supplier_id 1
ta_dealer_a_price 17.12
ta_dealer_c_price 14.98
ta_price 21.4
text
array
1 22977
2 FW16027-46
3 natural, 27 in.
timestamp 2015-03-31T17:52:58.893Z
vip_member_price 16.26

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 23406
2 1.000000000000 80148
3 7.000000000000