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

Watercolor Pencils (EA)

by Prismacolor


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

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

ItemIDList: 30931
AvailQtyList: 2.000000000000

struct
FLAGS 0
VIP_member_discount 28
barcode 070735040176
barcode_type UPC
col1 black
col1_sortorder 402
col2 [empty string]
col3 [empty string]
color_swatch 35-31-31.jpg
cost 0.87
deal_of_the_week NO
description black
group_id 10729
group_uname prismacolor-watercolor-pencils-ea-
id 78133
list_price 1.87
map NO
mfr_num 4017
net_weight 0.01
non_member_discount 18
non_member_price 1.53
prop65 NO
ship_rule_desc STD
shipping STD
sku 78133
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.94
ta_dealer_c_price 0.94
ta_price 1.42
text
array
1 78133
2 4017
3 black
timestamp 2015-03-30T16:21:43.471Z
vip_member_price 1.35

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 2.000000000000 30931
CACHED false
EXECUTIONTIME 1
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] = '3000' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&gr=prismacolor-watercolor-pencils-ea-.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 12:46:51'}
sessionid e03013d8bc20bffd35fb13122040c5316557
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=clip-art&CatC=people-places&CatD=fb~dover~fp~11-9999.99~&gr=dover-arms-and-armor-a-pictorial-archive-from-nineteenth-century-sources.html
urltoken CFID=30526179&CFTOKEN=37369529&jsessionid=e03013d8bc20bffd35fb13122040c5316557
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 12:46:51'}
sessionid e030abbe25880ffbb8911e342251102f154c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&gr=prismacolor-watercolor-pencils-ea-.html
urltoken CFID=30526178&CFTOKEN=80341097&jsessionid=e030abbe25880ffbb8911e342251102f154c
validationerror [empty string]


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

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

ItemIDList: 30931
AvailQtyList: 2.000000000000

struct
FLAGS 0
VIP_member_discount 28
barcode 070735040633
barcode_type UPC
col1 blush pink
col1_sortorder 642
col2 [empty string]
col3 [empty string]
color_swatch 249-187-178.jpg
cost 0.87
deal_of_the_week NO
description blush pink
group_id 10729
group_uname prismacolor-watercolor-pencils-ea-
id 32168
list_price 1.87
map NO
mfr_num 4063
net_weight 0.01
non_member_discount 18
non_member_price 1.53
prop65 NO
ship_rule_desc STD
shipping STD
sku 32168
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.94
ta_dealer_c_price 0.94
ta_price 1.42
text
array
1 32168
2 4063
3 blush pink
timestamp 2015-03-30T16:20:02.228Z
vip_member_price 1.35

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 2.000000000000 30931
CACHED false
EXECUTIONTIME 1
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] = '3000' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&gr=prismacolor-watercolor-pencils-ea-.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 12:46:51'}
sessionid e03013d8bc20bffd35fb13122040c5316557
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=clip-art&CatC=people-places&CatD=fb~dover~fp~11-9999.99~&gr=dover-arms-and-armor-a-pictorial-archive-from-nineteenth-century-sources.html
urltoken CFID=30526179&CFTOKEN=37369529&jsessionid=e03013d8bc20bffd35fb13122040c5316557
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 12:46:51'}
sessionid e030abbe25880ffbb8911e342251102f154c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&gr=prismacolor-watercolor-pencils-ea-.html
urltoken CFID=30526178&CFTOKEN=80341097&jsessionid=e030abbe25880ffbb8911e342251102f154c
validationerror [empty string]


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

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

ItemIDList: 30931
AvailQtyList: 2.000000000000

struct
FLAGS 0
VIP_member_discount 28
barcode 070735040183
barcode_type UPC
col1 canary yellow
col1_sortorder 1061
col2 [empty string]
col3 [empty string]
color_swatch 255-242-1.jpg
cost 0.87
deal_of_the_week NO
description canary yellow
group_id 10729
group_uname prismacolor-watercolor-pencils-ea-
id 19050
list_price 1.87
map NO
mfr_num 4018
net_weight 0.01
non_member_discount 18
non_member_price 1.53
prop65 NO
ship_rule_desc STD
shipping STD
sku 19050
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.94
ta_dealer_c_price 0.94
ta_price 1.42
text
array
1 19050
2 4018
3 canary yellow
timestamp 2015-03-30T16:19:37.672Z
vip_member_price 1.35

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 2.000000000000 30931
CACHED false
EXECUTIONTIME 1
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] = '3000' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&gr=prismacolor-watercolor-pencils-ea-.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 12:46:51'}
sessionid e03013d8bc20bffd35fb13122040c5316557
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=clip-art&CatC=people-places&CatD=fb~dover~fp~11-9999.99~&gr=dover-arms-and-armor-a-pictorial-archive-from-nineteenth-century-sources.html
urltoken CFID=30526179&CFTOKEN=37369529&jsessionid=e03013d8bc20bffd35fb13122040c5316557
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 12:46:51'}
sessionid e030abbe25880ffbb8911e342251102f154c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&gr=prismacolor-watercolor-pencils-ea-.html
urltoken CFID=30526178&CFTOKEN=80341097&jsessionid=e030abbe25880ffbb8911e342251102f154c
validationerror [empty string]


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

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

ItemIDList: 30931
AvailQtyList: 2.000000000000

struct
FLAGS 0
VIP_member_discount 28
barcode 070735040282
barcode_type UPC
col1 carmine red
col1_sortorder 1116
col2 [empty string]
col3 [empty string]
color_swatch 241-93-89.jpg
cost 0.87
deal_of_the_week NO
description carmine red
group_id 10729
group_uname prismacolor-watercolor-pencils-ea-
id 33306
list_price 1.87
map NO
mfr_num 4028
net_weight 0.01
non_member_discount 18
non_member_price 1.53
prop65 NO
ship_rule_desc STD
shipping STD
sku 33306
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.94
ta_dealer_c_price 0.94
ta_price 1.42
text
array
1 33306
2 4028
3 carmine red
timestamp 2015-03-30T16:20:07.559Z
vip_member_price 1.35

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 2.000000000000 30931
CACHED false
EXECUTIONTIME 1
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] = '3000' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&gr=prismacolor-watercolor-pencils-ea-.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 12:46:51'}
sessionid e03013d8bc20bffd35fb13122040c5316557
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=clip-art&CatC=people-places&CatD=fb~dover~fp~11-9999.99~&gr=dover-arms-and-armor-a-pictorial-archive-from-nineteenth-century-sources.html
urltoken CFID=30526179&CFTOKEN=37369529&jsessionid=e03013d8bc20bffd35fb13122040c5316557
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 12:46:51'}
sessionid e030abbe25880ffbb8911e342251102f154c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&gr=prismacolor-watercolor-pencils-ea-.html
urltoken CFID=30526178&CFTOKEN=80341097&jsessionid=e030abbe25880ffbb8911e342251102f154c
validationerror [empty string]


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

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

ItemIDList: 30931
AvailQtyList: 2.000000000000

struct
FLAGS 0
VIP_member_discount 28
barcode 070735040688
barcode_type UPC
col1 cool grey
col1_sortorder 1520
col2 [empty string]
col3 [empty string]
color_swatch 201-210-214.jpg
cost 0.87
deal_of_the_week NO
description cool grey
group_id 10729
group_uname prismacolor-watercolor-pencils-ea-
id 20237
list_price 1.87
map NO
mfr_num 4068
net_weight 0.01
non_member_discount 18
non_member_price 1.53
prop65 NO
ship_rule_desc STD
shipping STD
sku 20237
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.94
ta_dealer_c_price 0.94
ta_price 1.42
text
array
1 20237
2 4068
3 cool grey
timestamp 2015-03-30T16:19:39.301Z
vip_member_price 1.35

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 2.000000000000 30931
CACHED false
EXECUTIONTIME 1
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] = '3000' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&gr=prismacolor-watercolor-pencils-ea-.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 12:46:51'}
sessionid e03013d8bc20bffd35fb13122040c5316557
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=clip-art&CatC=people-places&CatD=fb~dover~fp~11-9999.99~&gr=dover-arms-and-armor-a-pictorial-archive-from-nineteenth-century-sources.html
urltoken CFID=30526179&CFTOKEN=37369529&jsessionid=e03013d8bc20bffd35fb13122040c5316557
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 12:46:51'}
sessionid e030abbe25880ffbb8911e342251102f154c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&gr=prismacolor-watercolor-pencils-ea-.html
urltoken CFID=30526178&CFTOKEN=80341097&jsessionid=e030abbe25880ffbb8911e342251102f154c
validationerror [empty string]


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

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

ItemIDList: 30931
AvailQtyList: 2.000000000000

struct
FLAGS 0
VIP_member_discount 28
barcode 070735040343
barcode_type UPC
col1 Copenhagen blue
col1_sortorder 1528
col2 [empty string]
col3 [empty string]
color_swatch 0-123-195.jpg
cost 0.87
deal_of_the_week NO
description Copenhagen blue
group_id 10729
group_uname prismacolor-watercolor-pencils-ea-
id 59658
list_price 1.87
map NO
mfr_num 4034
net_weight 0.01
non_member_discount 18
non_member_price 1.53
prop65 NO
ship_rule_desc STD
shipping STD
sku 59658
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.94
ta_dealer_c_price 0.94
ta_price 1.42
text
array
1 59658
2 4034
3 Copenhagen blue
timestamp 2015-03-30T16:20:52.939Z
vip_member_price 1.35

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 2.000000000000 30931
CACHED false
EXECUTIONTIME 1
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] = '3000' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&gr=prismacolor-watercolor-pencils-ea-.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 12:46:51'}
sessionid e03013d8bc20bffd35fb13122040c5316557
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=clip-art&CatC=people-places&CatD=fb~dover~fp~11-9999.99~&gr=dover-arms-and-armor-a-pictorial-archive-from-nineteenth-century-sources.html
urltoken CFID=30526179&CFTOKEN=37369529&jsessionid=e03013d8bc20bffd35fb13122040c5316557
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 12:46:51'}
sessionid e030abbe25880ffbb8911e342251102f154c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&gr=prismacolor-watercolor-pencils-ea-.html
urltoken CFID=30526178&CFTOKEN=80341097&jsessionid=e030abbe25880ffbb8911e342251102f154c
validationerror [empty string]


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

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

ItemIDList: 30931
AvailQtyList: 2.000000000000

struct
FLAGS 0
VIP_member_discount 28
barcode 070735040336
barcode_type UPC
col1 cream
col1_sortorder 1595
col2 [empty string]
col3 [empty string]
color_swatch 255-252-220.jpg
cost 0.87
deal_of_the_week NO
description cream
group_id 10729
group_uname prismacolor-watercolor-pencils-ea-
id 67088
list_price 1.87
map NO
mfr_num 4033
net_weight 0.01
non_member_discount 18
non_member_price 1.53
prop65 NO
ship_rule_desc STD
shipping STD
sku 67088
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.94
ta_dealer_c_price 0.94
ta_price 1.42
text
array
1 67088
2 4033
3 cream
timestamp 2015-03-30T16:21:13.055Z
vip_member_price 1.35

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 2.000000000000 30931
CACHED false
EXECUTIONTIME 1
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] = '3000' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&gr=prismacolor-watercolor-pencils-ea-.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 12:46:51'}
sessionid e03013d8bc20bffd35fb13122040c5316557
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=clip-art&CatC=people-places&CatD=fb~dover~fp~11-9999.99~&gr=dover-arms-and-armor-a-pictorial-archive-from-nineteenth-century-sources.html
urltoken CFID=30526179&CFTOKEN=37369529&jsessionid=e03013d8bc20bffd35fb13122040c5316557
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 12:46:51'}
sessionid e030abbe25880ffbb8911e342251102f154c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&gr=prismacolor-watercolor-pencils-ea-.html
urltoken CFID=30526178&CFTOKEN=80341097&jsessionid=e030abbe25880ffbb8911e342251102f154c
validationerror [empty string]


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

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

ItemIDList: 30931
AvailQtyList: 2.000000000000

struct
FLAGS 0
VIP_member_discount 28
barcode 070735040190
barcode_type UPC
col1 crimson red
col1_sortorder 1616
col2 [empty string]
col3 [empty string]
color_swatch 198-38-43.jpg
cost 0.87
deal_of_the_week NO
description crimson red
group_id 10729
group_uname prismacolor-watercolor-pencils-ea-
id 30052
list_price 1.87
map NO
mfr_num 4019
net_weight 0.01
non_member_discount 18
non_member_price 1.53
prop65 NO
ship_rule_desc STD
shipping STD
sku 30052
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.94
ta_dealer_c_price 0.94
ta_price 1.42
text
array
1 30052
2 4019
3 crimson red
timestamp 2015-03-30T16:19:56.728Z
vip_member_price 1.35

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 2.000000000000 30931
CACHED false
EXECUTIONTIME 1
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] = '3000' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&gr=prismacolor-watercolor-pencils-ea-.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 12:46:51'}
sessionid e03013d8bc20bffd35fb13122040c5316557
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=clip-art&CatC=people-places&CatD=fb~dover~fp~11-9999.99~&gr=dover-arms-and-armor-a-pictorial-archive-from-nineteenth-century-sources.html
urltoken CFID=30526179&CFTOKEN=37369529&jsessionid=e03013d8bc20bffd35fb13122040c5316557
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 12:46:51'}
sessionid e030abbe25880ffbb8911e342251102f154c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&gr=prismacolor-watercolor-pencils-ea-.html
urltoken CFID=30526178&CFTOKEN=80341097&jsessionid=e030abbe25880ffbb8911e342251102f154c
validationerror [empty string]


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

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

ItemIDList: 30931
AvailQtyList: 2.000000000000

struct
FLAGS 0
VIP_member_discount 28
barcode 070735040350
barcode_type UPC
col1 dark brown
col1_sortorder 1683
col2 [empty string]
col3 [empty string]
color_swatch 89-87-74.jpg
cost 0.87
deal_of_the_week NO
description dark brown
group_id 10729
group_uname prismacolor-watercolor-pencils-ea-
id 76214
list_price 1.87
map NO
mfr_num 4035
net_weight 0.01
non_member_discount 18
non_member_price 1.53
prop65 NO
ship_rule_desc STD
shipping STD
sku 76214
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.94
ta_dealer_c_price 0.94
ta_price 1.42
text
array
1 76214
2 4035
3 dark brown
timestamp 2015-03-30T16:21:41.275Z
vip_member_price 1.35

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 2.000000000000 30931
CACHED false
EXECUTIONTIME 1
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] = '3000' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&gr=prismacolor-watercolor-pencils-ea-.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 12:46:51'}
sessionid e03013d8bc20bffd35fb13122040c5316557
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=clip-art&CatC=people-places&CatD=fb~dover~fp~11-9999.99~&gr=dover-arms-and-armor-a-pictorial-archive-from-nineteenth-century-sources.html
urltoken CFID=30526179&CFTOKEN=37369529&jsessionid=e03013d8bc20bffd35fb13122040c5316557
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 12:46:51'}
sessionid e030abbe25880ffbb8911e342251102f154c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&gr=prismacolor-watercolor-pencils-ea-.html
urltoken CFID=30526178&CFTOKEN=80341097&jsessionid=e030abbe25880ffbb8911e342251102f154c
validationerror [empty string]


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

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

ItemIDList: 30931
AvailQtyList: 2.000000000000

struct
FLAGS 0
VIP_member_discount 28
barcode 070735040374
barcode_type UPC
col1 dark green
col1_sortorder 1711
col2 [empty string]
col3 [empty string]
color_swatch 2-108-73.jpg
cost 0.87
deal_of_the_week NO
description dark green
group_id 10729
group_uname prismacolor-watercolor-pencils-ea-
id 34226
list_price 1.87
map NO
mfr_num 4037
net_weight 0.01
non_member_discount 18
non_member_price 1.53
prop65 NO
ship_rule_desc STD
shipping STD
sku 34226
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.94
ta_dealer_c_price 0.94
ta_price 1.42
text
array
1 34226
2 4037
3 dark green
timestamp 2015-03-30T16:20:10.519Z
vip_member_price 1.35

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 2.000000000000 30931
CACHED false
EXECUTIONTIME 1
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] = '3000' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&gr=prismacolor-watercolor-pencils-ea-.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 12:46:51'}
sessionid e03013d8bc20bffd35fb13122040c5316557
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=clip-art&CatC=people-places&CatD=fb~dover~fp~11-9999.99~&gr=dover-arms-and-armor-a-pictorial-archive-from-nineteenth-century-sources.html
urltoken CFID=30526179&CFTOKEN=37369529&jsessionid=e03013d8bc20bffd35fb13122040c5316557
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 12:46:51'}
sessionid e030abbe25880ffbb8911e342251102f154c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&gr=prismacolor-watercolor-pencils-ea-.html
urltoken CFID=30526178&CFTOKEN=80341097&jsessionid=e030abbe25880ffbb8911e342251102f154c
validationerror [empty string]


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

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

ItemIDList: 30931
AvailQtyList: 2.000000000000

struct
FLAGS 0
VIP_member_discount 28
barcode 070735040305
barcode_type UPC
col1 dark umber
col1_sortorder 1767
col2 [empty string]
col3 [empty string]
color_swatch 62-56-50.jpg
cost 0.87
deal_of_the_week NO
description dark umber
group_id 10729
group_uname prismacolor-watercolor-pencils-ea-
id 35091
list_price 1.87
map NO
mfr_num 4030
net_weight 0.01
non_member_discount 18
non_member_price 1.53
prop65 NO
ship_rule_desc STD
shipping STD
sku 35091
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.94
ta_dealer_c_price 0.94
ta_price 1.42
text
array
1 35091
2 4030
3 dark umber
timestamp 2015-03-30T16:20:11.803Z
vip_member_price 1.35

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 2.000000000000 30931
CACHED false
EXECUTIONTIME 1
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] = '3000' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&gr=prismacolor-watercolor-pencils-ea-.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 12:46:51'}
sessionid e03013d8bc20bffd35fb13122040c5316557
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=clip-art&CatC=people-places&CatD=fb~dover~fp~11-9999.99~&gr=dover-arms-and-armor-a-pictorial-archive-from-nineteenth-century-sources.html
urltoken CFID=30526179&CFTOKEN=37369529&jsessionid=e03013d8bc20bffd35fb13122040c5316557
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 12:46:51'}
sessionid e030abbe25880ffbb8911e342251102f154c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&gr=prismacolor-watercolor-pencils-ea-.html
urltoken CFID=30526178&CFTOKEN=80341097&jsessionid=e030abbe25880ffbb8911e342251102f154c
validationerror [empty string]


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

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

ItemIDList: 30931
AvailQtyList: 2.000000000000

struct
FLAGS 0
VIP_member_discount 28
barcode 070735040749
barcode_type UPC
col1 French grey
col1_sortorder 2307
col2 [empty string]
col3 [empty string]
color_swatch 233-228-225.jpg
cost 0.87
deal_of_the_week NO
description French grey
group_id 10729
group_uname prismacolor-watercolor-pencils-ea-
id 23572
list_price 1.87
map NO
mfr_num 4074
net_weight 0.01
non_member_discount 18
non_member_price 1.53
prop65 NO
ship_rule_desc STD
shipping STD
sku 23572
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.94
ta_dealer_c_price 0.94
ta_price 1.42
text
array
1 23572
2 4074
3 French grey
timestamp 2015-03-30T16:19:45.497Z
vip_member_price 1.35

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 2.000000000000 30931
CACHED false
EXECUTIONTIME 1
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] = '3000' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&gr=prismacolor-watercolor-pencils-ea-.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 12:46:51'}
sessionid e03013d8bc20bffd35fb13122040c5316557
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=clip-art&CatC=people-places&CatD=fb~dover~fp~11-9999.99~&gr=dover-arms-and-armor-a-pictorial-archive-from-nineteenth-century-sources.html
urltoken CFID=30526179&CFTOKEN=37369529&jsessionid=e03013d8bc20bffd35fb13122040c5316557
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 12:46:51'}
sessionid e030abbe25880ffbb8911e342251102f154c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&gr=prismacolor-watercolor-pencils-ea-.html
urltoken CFID=30526178&CFTOKEN=80341097&jsessionid=e030abbe25880ffbb8911e342251102f154c
validationerror [empty string]


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

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

ItemIDList: 30931
AvailQtyList: 2.000000000000

struct
FLAGS 0
VIP_member_discount 28
barcode 070735040701
barcode_type UPC
col1 goldenrod
col1_sortorder 2565
col2 [empty string]
col3 [empty string]
color_swatch 245-184-48.jpg
cost 0.87
deal_of_the_week NO
description goldenrod
group_id 10729
group_uname prismacolor-watercolor-pencils-ea-
id 60579
list_price 1.87
map NO
mfr_num 4070
net_weight 0.02
non_member_discount 18
non_member_price 1.53
prop65 NO
ship_rule_desc STD
shipping STD
sku 60579
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.94
ta_dealer_c_price 0.94
ta_price 1.42
text
array
1 60579
2 4070
3 goldenrod
timestamp 2015-03-30T16:20:56.298Z
vip_member_price 1.35

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 2.000000000000 30931
CACHED false
EXECUTIONTIME 1
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] = '3000' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&gr=prismacolor-watercolor-pencils-ea-.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 12:46:51'}
sessionid e03013d8bc20bffd35fb13122040c5316557
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=clip-art&CatC=people-places&CatD=fb~dover~fp~11-9999.99~&gr=dover-arms-and-armor-a-pictorial-archive-from-nineteenth-century-sources.html
urltoken CFID=30526179&CFTOKEN=37369529&jsessionid=e03013d8bc20bffd35fb13122040c5316557
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 12:46:51'}
sessionid e030abbe25880ffbb8911e342251102f154c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&gr=prismacolor-watercolor-pencils-ea-.html
urltoken CFID=30526178&CFTOKEN=80341097&jsessionid=e030abbe25880ffbb8911e342251102f154c
validationerror [empty string]


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

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

ItemIDList: 30931
AvailQtyList: 2.000000000000

struct
FLAGS 0
VIP_member_discount 28
barcode 070735040268
barcode_type UPC
col1 grass green
col1_sortorder 2598
col2 [empty string]
col3 [empty string]
color_swatch 0-159-79.jpg
cost 0.87
deal_of_the_week NO
description grass green
group_id 10729
group_uname prismacolor-watercolor-pencils-ea-
id 64144
list_price 1.87
map NO
mfr_num 4026
net_weight 0.01
non_member_discount 18
non_member_price 1.53
prop65 NO
ship_rule_desc STD
shipping STD
sku 64144
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.94
ta_dealer_c_price 0.94
ta_price 1.42
text
array
1 64144
2 4026
3 grass green
timestamp 2015-03-30T16:21:05.622Z
vip_member_price 1.35

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 2.000000000000 30931
CACHED false
EXECUTIONTIME 1
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] = '3000' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&gr=prismacolor-watercolor-pencils-ea-.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 12:46:51'}
sessionid e03013d8bc20bffd35fb13122040c5316557
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=clip-art&CatC=people-places&CatD=fb~dover~fp~11-9999.99~&gr=dover-arms-and-armor-a-pictorial-archive-from-nineteenth-century-sources.html
urltoken CFID=30526179&CFTOKEN=37369529&jsessionid=e03013d8bc20bffd35fb13122040c5316557
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 12:46:51'}
sessionid e030abbe25880ffbb8911e342251102f154c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&gr=prismacolor-watercolor-pencils-ea-.html
urltoken CFID=30526178&CFTOKEN=80341097&jsessionid=e030abbe25880ffbb8911e342251102f154c
validationerror [empty string]


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

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

ItemIDList: 30931
AvailQtyList: 2.000000000000

struct
FLAGS 0
VIP_member_discount 28
barcode 070735040213
barcode_type UPC
col1 indigo blue
col1_sortorder 2954
col2 [empty string]
col3 [empty string]
color_swatch 0-70-117.jpg
cost 0.87
deal_of_the_week NO
description indigo blue
group_id 10729
group_uname prismacolor-watercolor-pencils-ea-
id 66814
list_price 1.87
map NO
mfr_num 4021
net_weight 0.01
non_member_discount 18
non_member_price 1.53
prop65 NO
ship_rule_desc STD
shipping STD
sku 66814
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.94
ta_dealer_c_price 0.94
ta_price 1.42
text
array
1 66814
2 4021
3 indigo blue
timestamp 2015-03-30T16:21:12.141Z
vip_member_price 1.35

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 2.000000000000 30931
CACHED false
EXECUTIONTIME 1
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] = '3000' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&gr=prismacolor-watercolor-pencils-ea-.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 12:46:51'}
sessionid e03013d8bc20bffd35fb13122040c5316557
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=clip-art&CatC=people-places&CatD=fb~dover~fp~11-9999.99~&gr=dover-arms-and-armor-a-pictorial-archive-from-nineteenth-century-sources.html
urltoken CFID=30526179&CFTOKEN=37369529&jsessionid=e03013d8bc20bffd35fb13122040c5316557
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 12:46:51'}
sessionid e030abbe25880ffbb8911e342251102f154c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&gr=prismacolor-watercolor-pencils-ea-.html
urltoken CFID=30526178&CFTOKEN=80341097&jsessionid=e030abbe25880ffbb8911e342251102f154c
validationerror [empty string]


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

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

ItemIDList: 30931
AvailQtyList: 2.000000000000

struct
FLAGS 0
VIP_member_discount 28
barcode 070735040312
barcode_type UPC
col1 light peach
col1_sortorder 3393
col2 [empty string]
col3 [empty string]
color_swatch 253-218-196.jpg
cost 0.87
deal_of_the_week NO
description light peach
group_id 10729
group_uname prismacolor-watercolor-pencils-ea-
id 34104
list_price 1.87
map NO
mfr_num 4031
net_weight 0.01
non_member_discount 18
non_member_price 1.53
prop65 NO
ship_rule_desc STD
shipping STD
sku 34104
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.94
ta_dealer_c_price 0.94
ta_price 1.42
text
array
1 34104
2 4031
3 light peach
timestamp 2015-03-30T16:20:10.255Z
vip_member_price 1.35

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 2.000000000000 30931
CACHED false
EXECUTIONTIME 1
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] = '3000' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&gr=prismacolor-watercolor-pencils-ea-.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 12:46:51'}
sessionid e03013d8bc20bffd35fb13122040c5316557
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=clip-art&CatC=people-places&CatD=fb~dover~fp~11-9999.99~&gr=dover-arms-and-armor-a-pictorial-archive-from-nineteenth-century-sources.html
urltoken CFID=30526179&CFTOKEN=37369529&jsessionid=e03013d8bc20bffd35fb13122040c5316557
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 12:46:51'}
sessionid e030abbe25880ffbb8911e342251102f154c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&gr=prismacolor-watercolor-pencils-ea-.html
urltoken CFID=30526178&CFTOKEN=80341097&jsessionid=e030abbe25880ffbb8911e342251102f154c
validationerror [empty string]


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

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

ItemIDList: 30931
AvailQtyList: 2.000000000000

struct
FLAGS 0
VIP_member_discount 28
barcode 070735040695
barcode_type UPC
col1 lilac
col1_sortorder 3454
col2 [empty string]
col3 [empty string]
color_swatch 161-126-158.jpg
cost 0.87
deal_of_the_week NO
description lilac
group_id 10729
group_uname prismacolor-watercolor-pencils-ea-
id 13668
list_price 1.87
map NO
mfr_num 4069
net_weight 0.01
non_member_discount 18
non_member_price 1.53
prop65 NO
ship_rule_desc STD
shipping STD
sku 13668
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.94
ta_dealer_c_price 0.94
ta_price 1.42
text
array
1 13668
2 4069
3 lilac
timestamp 2015-03-30T16:19:21.573Z
vip_member_price 1.35

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 2.000000000000 30931
CACHED false
EXECUTIONTIME 1
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] = '3000' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&gr=prismacolor-watercolor-pencils-ea-.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 12:46:51'}
sessionid e03013d8bc20bffd35fb13122040c5316557
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=clip-art&CatC=people-places&CatD=fb~dover~fp~11-9999.99~&gr=dover-arms-and-armor-a-pictorial-archive-from-nineteenth-century-sources.html
urltoken CFID=30526179&CFTOKEN=37369529&jsessionid=e03013d8bc20bffd35fb13122040c5316557
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 12:46:51'}
sessionid e030abbe25880ffbb8911e342251102f154c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&gr=prismacolor-watercolor-pencils-ea-.html
urltoken CFID=30526178&CFTOKEN=80341097&jsessionid=e030abbe25880ffbb8911e342251102f154c
validationerror [empty string]


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

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

ItemIDList: 30931
AvailQtyList: 2.000000000000

struct
FLAGS 0
VIP_member_discount 28
barcode 070735040732
barcode_type UPC
col1 mulberry
col1_sortorder 3870
col2 [empty string]
col3 [empty string]
color_swatch 156-37-142.jpg
cost 0.87
deal_of_the_week NO
description mulberry
group_id 10729
group_uname prismacolor-watercolor-pencils-ea-
id 80811
list_price 1.87
map NO
mfr_num 4073
net_weight 0.01
non_member_discount 18
non_member_price 1.53
prop65 NO
ship_rule_desc STD
shipping STD
sku 80811
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.94
ta_dealer_c_price 0.94
ta_price 1.42
text
array
1 80811
2 4073
3 mulberry
timestamp 2015-03-30T16:21:46.642Z
vip_member_price 1.35

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 2.000000000000 30931
CACHED false
EXECUTIONTIME 1
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] = '3000' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&gr=prismacolor-watercolor-pencils-ea-.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 12:46:51'}
sessionid e03013d8bc20bffd35fb13122040c5316557
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=clip-art&CatC=people-places&CatD=fb~dover~fp~11-9999.99~&gr=dover-arms-and-armor-a-pictorial-archive-from-nineteenth-century-sources.html
urltoken CFID=30526179&CFTOKEN=37369529&jsessionid=e03013d8bc20bffd35fb13122040c5316557
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 12:46:51'}
sessionid e030abbe25880ffbb8911e342251102f154c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&gr=prismacolor-watercolor-pencils-ea-.html
urltoken CFID=30526178&CFTOKEN=80341097&jsessionid=e030abbe25880ffbb8911e342251102f154c
validationerror [empty string]


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

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

ItemIDList: 30931
AvailQtyList: 2.000000000000

struct
FLAGS 0
VIP_member_discount 28
barcode 070735040220
barcode_type UPC
col1 non-photo blue
col1_sortorder 4105
col2 [empty string]
col3 [empty string]
color_swatch 68-197-224.jpg
cost 0.87
deal_of_the_week NO
description non-photo blue
group_id 10729
group_uname prismacolor-watercolor-pencils-ea-
id 57345
list_price 1.87
map NO
mfr_num 4022
net_weight 0.01
non_member_discount 18
non_member_price 1.53
prop65 NO
ship_rule_desc STD
shipping STD
sku 57345
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.94
ta_dealer_c_price 0.94
ta_price 1.42
text
array
1 57345
2 4022
3 non-photo blue
timestamp 2015-03-30T16:20:49.678Z
vip_member_price 1.35

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 2.000000000000 30931
CACHED false
EXECUTIONTIME 1
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] = '3000' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&gr=prismacolor-watercolor-pencils-ea-.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 12:46:51'}
sessionid e03013d8bc20bffd35fb13122040c5316557
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=clip-art&CatC=people-places&CatD=fb~dover~fp~11-9999.99~&gr=dover-arms-and-armor-a-pictorial-archive-from-nineteenth-century-sources.html
urltoken CFID=30526179&CFTOKEN=37369529&jsessionid=e03013d8bc20bffd35fb13122040c5316557
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 12:46:51'}
sessionid e030abbe25880ffbb8911e342251102f154c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&gr=prismacolor-watercolor-pencils-ea-.html
urltoken CFID=30526178&CFTOKEN=80341097&jsessionid=e030abbe25880ffbb8911e342251102f154c
validationerror [empty string]


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

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

ItemIDList: 30931
AvailQtyList: 2.000000000000

struct
FLAGS 0
VIP_member_discount 28
barcode 070735040411
barcode_type UPC
col1 olive green
col1_sortorder 4171
col2 [empty string]
col3 [empty string]
color_swatch 15-136-94.jpg
cost 0.87
deal_of_the_week NO
description olive green
group_id 10729
group_uname prismacolor-watercolor-pencils-ea-
id 57251
list_price 1.87
map NO
mfr_num 4041
net_weight 0.01
non_member_discount 18
non_member_price 1.53
prop65 NO
ship_rule_desc STD
shipping STD
sku 57251
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.94
ta_dealer_c_price 0.94
ta_price 1.42
text
array
1 57251
2 4041
3 olive green
timestamp 2015-03-30T16:20:49.635Z
vip_member_price 1.35

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 2.000000000000 30931
CACHED false
EXECUTIONTIME 1
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] = '3000' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&gr=prismacolor-watercolor-pencils-ea-.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 12:46:51'}
sessionid e03013d8bc20bffd35fb13122040c5316557
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=clip-art&CatC=people-places&CatD=fb~dover~fp~11-9999.99~&gr=dover-arms-and-armor-a-pictorial-archive-from-nineteenth-century-sources.html
urltoken CFID=30526179&CFTOKEN=37369529&jsessionid=e03013d8bc20bffd35fb13122040c5316557
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 12:46:51'}
sessionid e030abbe25880ffbb8911e342251102f154c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&gr=prismacolor-watercolor-pencils-ea-.html
urltoken CFID=30526178&CFTOKEN=80341097&jsessionid=e030abbe25880ffbb8911e342251102f154c
validationerror [empty string]


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

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

ItemIDList: 30931
AvailQtyList: 2.000000000000

struct
FLAGS 0
VIP_member_discount 28
barcode 070735040329
barcode_type UPC
col1 orange
col1_sortorder 4222
col2 [empty string]
col3 [empty string]
color_swatch 243-111-50.jpg
cost 0.87
deal_of_the_week NO
description orange
group_id 10729
group_uname prismacolor-watercolor-pencils-ea-
id 62776
list_price 1.87
map NO
mfr_num 4032
net_weight 0.01
non_member_discount 18
non_member_price 1.53
prop65 NO
ship_rule_desc STD
shipping STD
sku 62776
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.94
ta_dealer_c_price 0.94
ta_price 1.42
text
array
1 62776
2 4032
3 orange
timestamp 2015-03-30T16:21:02.873Z
vip_member_price 1.35

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 2.000000000000 30931
CACHED false
EXECUTIONTIME 1
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] = '3000' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&gr=prismacolor-watercolor-pencils-ea-.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 12:46:51'}
sessionid e03013d8bc20bffd35fb13122040c5316557
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=clip-art&CatC=people-places&CatD=fb~dover~fp~11-9999.99~&gr=dover-arms-and-armor-a-pictorial-archive-from-nineteenth-century-sources.html
urltoken CFID=30526179&CFTOKEN=37369529&jsessionid=e03013d8bc20bffd35fb13122040c5316557
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 12:46:51'}
sessionid e030abbe25880ffbb8911e342251102f154c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&gr=prismacolor-watercolor-pencils-ea-.html
urltoken CFID=30526178&CFTOKEN=80341097&jsessionid=e030abbe25880ffbb8911e342251102f154c
validationerror [empty string]


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

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

ItemIDList: 30931
AvailQtyList: 2.000000000000

struct
FLAGS 0
VIP_member_discount 28
barcode 070735040718
barcode_type UPC
col1 parrot green
col1_sortorder 4395
col2 [empty string]
col3 [empty string]
color_swatch 0-164-133.jpg
cost 0.87
deal_of_the_week NO
description parrot green
group_id 10729
group_uname prismacolor-watercolor-pencils-ea-
id 29161
list_price 1.87
map NO
mfr_num 4071
net_weight 0.01
non_member_discount 18
non_member_price 1.53
prop65 NO
ship_rule_desc STD
shipping STD
sku 29161
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.94
ta_dealer_c_price 0.94
ta_price 1.42
text
array
1 29161
2 4071
3 parrot green
timestamp 2015-03-30T16:19:55.33Z
vip_member_price 1.35

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 2.000000000000 30931
CACHED false
EXECUTIONTIME 1
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] = '3000' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&gr=prismacolor-watercolor-pencils-ea-.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 12:46:51'}
sessionid e03013d8bc20bffd35fb13122040c5316557
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=clip-art&CatC=people-places&CatD=fb~dover~fp~11-9999.99~&gr=dover-arms-and-armor-a-pictorial-archive-from-nineteenth-century-sources.html
urltoken CFID=30526179&CFTOKEN=37369529&jsessionid=e03013d8bc20bffd35fb13122040c5316557
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 12:46:51'}
sessionid e030abbe25880ffbb8911e342251102f154c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&gr=prismacolor-watercolor-pencils-ea-.html
urltoken CFID=30526178&CFTOKEN=80341097&jsessionid=e030abbe25880ffbb8911e342251102f154c
validationerror [empty string]


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

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

ItemIDList: 30931
AvailQtyList: 2.000000000000

struct
FLAGS 0
VIP_member_discount 28
barcode 070735040725
barcode_type UPC
col1 peacock blue
col1_sortorder 4448
col2 [empty string]
col3 [empty string]
color_swatch 0-123-167.jpg
cost 0.87
deal_of_the_week NO
description peacock blue
group_id 10729
group_uname prismacolor-watercolor-pencils-ea-
id 41864
list_price 1.87
map NO
mfr_num 4072
net_weight 0.01
non_member_discount 18
non_member_price 1.53
prop65 NO
ship_rule_desc STD
shipping STD
sku 41864
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.94
ta_dealer_c_price 0.94
ta_price 1.42
text
array
1 41864
2 4072
3 peacock blue
timestamp 2015-03-30T16:20:25.923Z
vip_member_price 1.35

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 2.000000000000 30931
CACHED false
EXECUTIONTIME 1
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] = '3000' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&gr=prismacolor-watercolor-pencils-ea-.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 12:46:51'}
sessionid e03013d8bc20bffd35fb13122040c5316557
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=clip-art&CatC=people-places&CatD=fb~dover~fp~11-9999.99~&gr=dover-arms-and-armor-a-pictorial-archive-from-nineteenth-century-sources.html
urltoken CFID=30526179&CFTOKEN=37369529&jsessionid=e03013d8bc20bffd35fb13122040c5316557
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 12:46:51'}
sessionid e030abbe25880ffbb8911e342251102f154c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&gr=prismacolor-watercolor-pencils-ea-.html
urltoken CFID=30526178&CFTOKEN=80341097&jsessionid=e030abbe25880ffbb8911e342251102f154c
validationerror [empty string]


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

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

ItemIDList: 30931
AvailQtyList: 2.000000000000

struct
FLAGS 0
VIP_member_discount 28
barcode 070735040534
barcode_type UPC
col1 pink
col1_sortorder 4724
col2 [empty string]
col3 [empty string]
color_swatch 242-126-157.jpg
cost 0.87
deal_of_the_week NO
description pink
group_id 10729
group_uname prismacolor-watercolor-pencils-ea-
id 31781
list_price 1.87
map NO
mfr_num 4053
net_weight 0.01
non_member_discount 18
non_member_price 1.53
prop65 NO
ship_rule_desc STD
shipping STD
sku 31781
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.94
ta_dealer_c_price 0.94
ta_price 1.42
text
array
1 31781
2 4053
3 pink
timestamp 2015-03-30T16:20:01.44Z
vip_member_price 1.35

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 2.000000000000 30931
CACHED false
EXECUTIONTIME 1
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] = '3000' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&gr=prismacolor-watercolor-pencils-ea-.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 12:46:51'}
sessionid e03013d8bc20bffd35fb13122040c5316557
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=clip-art&CatC=people-places&CatD=fb~dover~fp~11-9999.99~&gr=dover-arms-and-armor-a-pictorial-archive-from-nineteenth-century-sources.html
urltoken CFID=30526179&CFTOKEN=37369529&jsessionid=e03013d8bc20bffd35fb13122040c5316557
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 12:46:51'}
sessionid e030abbe25880ffbb8911e342251102f154c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&gr=prismacolor-watercolor-pencils-ea-.html
urltoken CFID=30526178&CFTOKEN=80341097&jsessionid=e030abbe25880ffbb8911e342251102f154c
validationerror [empty string]


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

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

ItemIDList: 30931
AvailQtyList: 2.000000000000

struct
FLAGS 0
VIP_member_discount 28
barcode 070735040299
barcode_type UPC
col1 poppy red
col1_sortorder 4823
col2 [empty string]
col3 [empty string]
color_swatch 241-92-45.jpg
cost 0.87
deal_of_the_week NO
description poppy red
group_id 10729
group_uname prismacolor-watercolor-pencils-ea-
id 63004
list_price 1.87
map NO
mfr_num 4029
net_weight 0.01
non_member_discount 18
non_member_price 1.53
prop65 NO
ship_rule_desc STD
shipping STD
sku 63004
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.94
ta_dealer_c_price 0.94
ta_price 1.42
text
array
1 63004
2 4029
3 poppy red
timestamp 2015-03-30T16:21:03.696Z
vip_member_price 1.35

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 2.000000000000 30931
CACHED false
EXECUTIONTIME 1
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] = '3000' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&gr=prismacolor-watercolor-pencils-ea-.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 12:46:51'}
sessionid e03013d8bc20bffd35fb13122040c5316557
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=clip-art&CatC=people-places&CatD=fb~dover~fp~11-9999.99~&gr=dover-arms-and-armor-a-pictorial-archive-from-nineteenth-century-sources.html
urltoken CFID=30526179&CFTOKEN=37369529&jsessionid=e03013d8bc20bffd35fb13122040c5316557
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 12:46:51'}
sessionid e030abbe25880ffbb8911e342251102f154c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&gr=prismacolor-watercolor-pencils-ea-.html
urltoken CFID=30526178&CFTOKEN=80341097&jsessionid=e030abbe25880ffbb8911e342251102f154c
validationerror [empty string]


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

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

ItemIDList: 30931
AvailQtyList: 2.000000000000

struct
FLAGS 0
VIP_member_discount 28
barcode 070735040428
barcode_type UPC
col1 sienna brown
col1_sortorder 5557
col2 [empty string]
col3 [empty string]
color_swatch 159-110-72.jpg
cost 0.87
deal_of_the_week NO
description sienna brown
group_id 10729
group_uname prismacolor-watercolor-pencils-ea-
id 73450
list_price 1.87
map NO
mfr_num 4042
net_weight 0.01
non_member_discount 18
non_member_price 1.53
prop65 NO
ship_rule_desc STD
shipping STD
sku 73450
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.94
ta_dealer_c_price 0.94
ta_price 1.42
text
array
1 73450
2 4042
3 sienna brown
timestamp 2015-03-30T16:21:37.167Z
vip_member_price 1.35

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 2.000000000000 30931
CACHED false
EXECUTIONTIME 1
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] = '3000' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&gr=prismacolor-watercolor-pencils-ea-.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 12:46:51'}
sessionid e03013d8bc20bffd35fb13122040c5316557
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=clip-art&CatC=people-places&CatD=fb~dover~fp~11-9999.99~&gr=dover-arms-and-armor-a-pictorial-archive-from-nineteenth-century-sources.html
urltoken CFID=30526179&CFTOKEN=37369529&jsessionid=e03013d8bc20bffd35fb13122040c5316557
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 12:46:51'}
sessionid e030abbe25880ffbb8911e342251102f154c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&gr=prismacolor-watercolor-pencils-ea-.html
urltoken CFID=30526178&CFTOKEN=80341097&jsessionid=e030abbe25880ffbb8911e342251102f154c
validationerror [empty string]


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

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

ItemIDList: 30931
AvailQtyList: 2.000000000000

struct
FLAGS 0
VIP_member_discount 28
barcode 070735040756
barcode_type UPC
col1 Spanish orange
col1_sortorder 5713
col2 [empty string]
col3 [empty string]
color_swatch 255-192-15.jpg
cost 0.87
deal_of_the_week NO
description Spanish orange
group_id 10729
group_uname prismacolor-watercolor-pencils-ea-
id 73492
list_price 1.87
map NO
mfr_num 4075
net_weight 0.01
non_member_discount 18
non_member_price 1.53
prop65 NO
ship_rule_desc STD
shipping STD
sku 73492
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.94
ta_dealer_c_price 0.94
ta_price 1.42
text
array
1 73492
2 4075
3 Spanish orange
timestamp 2015-03-30T16:21:37.224Z
vip_member_price 1.35

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 2.000000000000 30931
CACHED false
EXECUTIONTIME 1
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] = '3000' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&gr=prismacolor-watercolor-pencils-ea-.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 12:46:51'}
sessionid e03013d8bc20bffd35fb13122040c5316557
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=clip-art&CatC=people-places&CatD=fb~dover~fp~11-9999.99~&gr=dover-arms-and-armor-a-pictorial-archive-from-nineteenth-century-sources.html
urltoken CFID=30526179&CFTOKEN=37369529&jsessionid=e03013d8bc20bffd35fb13122040c5316557
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 12:46:51'}
sessionid e030abbe25880ffbb8911e342251102f154c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&gr=prismacolor-watercolor-pencils-ea-.html
urltoken CFID=30526178&CFTOKEN=80341097&jsessionid=e030abbe25880ffbb8911e342251102f154c
validationerror [empty string]


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

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

ItemIDList: 30931
AvailQtyList: 2.000000000000

struct
FLAGS 0
VIP_member_discount 28
barcode 070735040589
barcode_type UPC
col1 spring green
col1_sortorder 5768
col2 [empty string]
col3 [empty string]
color_swatch 156-203-58.jpg
cost 0.87
deal_of_the_week NO
description spring green
group_id 10729
group_uname prismacolor-watercolor-pencils-ea-
id 85095
list_price 1.87
map NO
mfr_num 4058
net_weight 0.01
non_member_discount 18
non_member_price 1.53
prop65 NO
ship_rule_desc STD
shipping STD
sku 85095
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.94
ta_dealer_c_price 0.94
ta_price 1.42
text
array
1 85095
2 4058
3 spring green
timestamp 2015-03-30T16:21:53.732Z
vip_member_price 1.35

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 2.000000000000 30931
CACHED false
EXECUTIONTIME 1
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] = '3000' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&gr=prismacolor-watercolor-pencils-ea-.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 12:46:51'}
sessionid e03013d8bc20bffd35fb13122040c5316557
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=clip-art&CatC=people-places&CatD=fb~dover~fp~11-9999.99~&gr=dover-arms-and-armor-a-pictorial-archive-from-nineteenth-century-sources.html
urltoken CFID=30526179&CFTOKEN=37369529&jsessionid=e03013d8bc20bffd35fb13122040c5316557
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 12:46:51'}
sessionid e030abbe25880ffbb8911e342251102f154c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&gr=prismacolor-watercolor-pencils-ea-.html
urltoken CFID=30526178&CFTOKEN=80341097&jsessionid=e030abbe25880ffbb8911e342251102f154c
validationerror [empty string]


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

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

ItemIDList: 30931
AvailQtyList: 2.000000000000

struct
FLAGS 0
VIP_member_discount 28
barcode 070735040466
barcode_type UPC
col1 sunburst
col1_sortorder 5870
col2 [empty string]
col3 [empty string]
color_swatch 247-148-50.jpg
cost 0.87
deal_of_the_week NO
description sunburst
group_id 10729
group_uname prismacolor-watercolor-pencils-ea-
id 84049
list_price 1.87
map NO
mfr_num 4046
net_weight 0.01
non_member_discount 18
non_member_price 1.53
prop65 NO
ship_rule_desc STD
shipping STD
sku 84049
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.94
ta_dealer_c_price 0.94
ta_price 1.42
text
array
1 84049
2 4046
3 sunburst
timestamp 2015-03-30T16:21:52.008Z
vip_member_price 1.35

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 2.000000000000 30931
CACHED false
EXECUTIONTIME 1
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] = '3000' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&gr=prismacolor-watercolor-pencils-ea-.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 12:46:51'}
sessionid e03013d8bc20bffd35fb13122040c5316557
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=clip-art&CatC=people-places&CatD=fb~dover~fp~11-9999.99~&gr=dover-arms-and-armor-a-pictorial-archive-from-nineteenth-century-sources.html
urltoken CFID=30526179&CFTOKEN=37369529&jsessionid=e03013d8bc20bffd35fb13122040c5316557
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 12:46:51'}
sessionid e030abbe25880ffbb8911e342251102f154c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&gr=prismacolor-watercolor-pencils-ea-.html
urltoken CFID=30526178&CFTOKEN=80341097&jsessionid=e030abbe25880ffbb8911e342251102f154c
validationerror [empty string]


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

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

ItemIDList: 30931
AvailQtyList: 2.000000000000

struct
FLAGS 0
VIP_member_discount 28
barcode 070735040275
barcode_type UPC
col1 terra cotta
col1_sortorder 5961
col2 [empty string]
col3 [empty string]
color_swatch 160-88-52.jpg
cost 0.87
deal_of_the_week NO
description terra cotta
group_id 10729
group_uname prismacolor-watercolor-pencils-ea-
id 12178
list_price 1.87
map NO
mfr_num 4027
net_weight 0.01
non_member_discount 18
non_member_price 1.53
prop65 NO
ship_rule_desc STD
shipping STD
sku 12178
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.94
ta_dealer_c_price 0.94
ta_price 1.42
text
array
1 12178
2 4027
3 terra cotta
timestamp 2015-03-30T16:19:17.492Z
vip_member_price 1.35

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 2.000000000000 30931
CACHED false
EXECUTIONTIME 1
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] = '3000' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&gr=prismacolor-watercolor-pencils-ea-.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 12:46:51'}
sessionid e03013d8bc20bffd35fb13122040c5316557
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=clip-art&CatC=people-places&CatD=fb~dover~fp~11-9999.99~&gr=dover-arms-and-armor-a-pictorial-archive-from-nineteenth-century-sources.html
urltoken CFID=30526179&CFTOKEN=37369529&jsessionid=e03013d8bc20bffd35fb13122040c5316557
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 12:46:51'}
sessionid e030abbe25880ffbb8911e342251102f154c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&gr=prismacolor-watercolor-pencils-ea-.html
urltoken CFID=30526178&CFTOKEN=80341097&jsessionid=e030abbe25880ffbb8911e342251102f154c
validationerror [empty string]


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

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

ItemIDList: 30931
AvailQtyList: 2.000000000000

struct
FLAGS 0
VIP_member_discount 28
barcode 070735040251
barcode_type UPC
col1 true blue
col1_sortorder 6197
col2 [empty string]
col3 [empty string]
color_swatch 0-148-216.jpg
cost 0.87
deal_of_the_week NO
description true blue
group_id 10729
group_uname prismacolor-watercolor-pencils-ea-
id 15048
list_price 1.87
map NO
mfr_num 4025
net_weight 0.01
non_member_discount 18
non_member_price 1.53
prop65 NO
ship_rule_desc STD
shipping STD
sku 15048
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.94
ta_dealer_c_price 0.94
ta_price 1.42
text
array
1 15048
2 4025
3 true blue
timestamp 2015-03-30T16:19:29.425Z
vip_member_price 1.35

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 2.000000000000 30931
CACHED false
EXECUTIONTIME 1
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] = '3000' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&gr=prismacolor-watercolor-pencils-ea-.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 12:46:51'}
sessionid e03013d8bc20bffd35fb13122040c5316557
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=clip-art&CatC=people-places&CatD=fb~dover~fp~11-9999.99~&gr=dover-arms-and-armor-a-pictorial-archive-from-nineteenth-century-sources.html
urltoken CFID=30526179&CFTOKEN=37369529&jsessionid=e03013d8bc20bffd35fb13122040c5316557
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 12:46:51'}
sessionid e030abbe25880ffbb8911e342251102f154c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&gr=prismacolor-watercolor-pencils-ea-.html
urltoken CFID=30526178&CFTOKEN=80341097&jsessionid=e030abbe25880ffbb8911e342251102f154c
validationerror [empty string]


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

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

ItemIDList: 30931
AvailQtyList: 2.000000000000

struct
FLAGS 0
VIP_member_discount 28
barcode 070735040206
barcode_type UPC
col1 true green
col1_sortorder 6201
col2 [empty string]
col3 [empty string]
color_swatch 42-153-99.jpg
cost 0.87
deal_of_the_week NO
description true green
group_id 10729
group_uname prismacolor-watercolor-pencils-ea-
id 76978
list_price 1.87
map NO
mfr_num 4020
net_weight 0.01
non_member_discount 18
non_member_price 1.53
prop65 NO
ship_rule_desc STD
shipping STD
sku 76978
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.94
ta_dealer_c_price 0.94
ta_price 1.42
text
array
1 76978
2 4020
3 true green
timestamp 2015-03-30T16:21:41.921Z
vip_member_price 1.35

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 2.000000000000 30931
CACHED false
EXECUTIONTIME 1
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] = '3000' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&gr=prismacolor-watercolor-pencils-ea-.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 12:46:51'}
sessionid e03013d8bc20bffd35fb13122040c5316557
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=clip-art&CatC=people-places&CatD=fb~dover~fp~11-9999.99~&gr=dover-arms-and-armor-a-pictorial-archive-from-nineteenth-century-sources.html
urltoken CFID=30526179&CFTOKEN=37369529&jsessionid=e03013d8bc20bffd35fb13122040c5316557
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 12:46:51'}
sessionid e030abbe25880ffbb8911e342251102f154c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&gr=prismacolor-watercolor-pencils-ea-.html
urltoken CFID=30526178&CFTOKEN=80341097&jsessionid=e030abbe25880ffbb8911e342251102f154c
validationerror [empty string]


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

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