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

Premier Colored Pencils

by Prismacolor


Problem with item sku 71208-PK. Item is found in Solr index but not found in vAvailQtyTbl.

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

ItemIDList: 65465
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 43
col1 apple green
col1_sortorder 175
col2 912
col2_sortorder 1067
col3 [empty string]
color_swatch 132-189-96.jpg
cost 9.96
deal_of_the_week NO
description apple green, 912
group_id 1326
group_uname prismacolor-premier-colored-pencils
id 71208-PK
list_price 20.52
map NO
net_weight 0.16
non_member_discount 35
non_member_price 13.34
prop65 NO
ship_rule_desc STD
shipping STD
sku 71208-PK
sku_pix NO
supplier_id 1
ta_dealer_a_price 0
ta_dealer_c_price 0
ta_price 0
text
array
1 71208-PK
2 apple green, 912
timestamp 2015-03-31T17:54:20.82Z
vip_member_price 11.79

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 65465
CACHED false
EXECUTIONTIME 17
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] = '10927' 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.159.161.138

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=fb~prismacolor~&gr=prismacolor-premier-colored-pencils.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:16:50'}
sessionid e03045fbd689a71c9130a5ca5f11213e6171
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=accessories&CatC=sort~1~fp~3-9~&gr=derwent-artbar-scraper.html
urltoken CFID=30711386&CFTOKEN=70774374&jsessionid=e03045fbd689a71c9130a5ca5f11213e6171
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:16:50'}
sessionid e030f9774879bb8799de1b40b691027e4b12
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=fb~prismacolor~&gr=prismacolor-premier-colored-pencils.html
urltoken CFID=30711387&CFTOKEN=86935984&jsessionid=e030f9774879bb8799de1b40b691027e4b12
validationerror [empty string]


Problem with item sku 55570-PK. Item is found in Solr index but not found in vAvailQtyTbl.

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

ItemIDList: 65465
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 43
col1 aquamarine
col1_sortorder 191
col2 905
col2_sortorder 1058
col3 [empty string]
color_swatch 3-138-138.jpg
cost 9.96
deal_of_the_week NO
description aquamarine, 905
group_id 1326
group_uname prismacolor-premier-colored-pencils
id 55570-PK
list_price 20.52
map NO
net_weight 0.16
non_member_discount 35
non_member_price 13.34
prop65 NO
ship_rule_desc STD
shipping STD
sku 55570-PK
sku_pix NO
supplier_id 1
ta_dealer_a_price 0
ta_dealer_c_price 0
ta_price 0
text
array
1 55570-PK
2 aquamarine, 905
timestamp 2015-03-31T17:53:48.83Z
vip_member_price 11.79

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 65465
CACHED false
EXECUTIONTIME 17
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] = '10927' 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.159.161.138

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=fb~prismacolor~&gr=prismacolor-premier-colored-pencils.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:16:50'}
sessionid e03045fbd689a71c9130a5ca5f11213e6171
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=accessories&CatC=sort~1~fp~3-9~&gr=derwent-artbar-scraper.html
urltoken CFID=30711386&CFTOKEN=70774374&jsessionid=e03045fbd689a71c9130a5ca5f11213e6171
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:16:50'}
sessionid e030f9774879bb8799de1b40b691027e4b12
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=fb~prismacolor~&gr=prismacolor-premier-colored-pencils.html
urltoken CFID=30711387&CFTOKEN=86935984&jsessionid=e030f9774879bb8799de1b40b691027e4b12
validationerror [empty string]


Problem with item sku 55711-PK. Item is found in Solr index but not found in vAvailQtyTbl.

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

ItemIDList: 65465
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 43
col1 beige
col1_sortorder 365
col2 997
col2_sortorder 1137
col3 [empty string]
color_swatch 239-194-149.jpg
cost 9.96
deal_of_the_week NO
description beige, 997
group_id 1326
group_uname prismacolor-premier-colored-pencils
id 55711-PK
list_price 20.52
map NO
net_weight 0.16
non_member_discount 35
non_member_price 13.34
prop65 NO
ship_rule_desc STD
shipping STD
sku 55711-PK
sku_pix NO
supplier_id 1
ta_dealer_a_price 0
ta_dealer_c_price 0
ta_price 0
text
array
1 55711-PK
2 beige, 997
timestamp 2015-03-31T17:53:48.93Z
vip_member_price 11.79

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 65465
CACHED false
EXECUTIONTIME 17
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] = '10927' 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.159.161.138

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=fb~prismacolor~&gr=prismacolor-premier-colored-pencils.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:16:50'}
sessionid e03045fbd689a71c9130a5ca5f11213e6171
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=accessories&CatC=sort~1~fp~3-9~&gr=derwent-artbar-scraper.html
urltoken CFID=30711386&CFTOKEN=70774374&jsessionid=e03045fbd689a71c9130a5ca5f11213e6171
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:16:50'}
sessionid e030f9774879bb8799de1b40b691027e4b12
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=fb~prismacolor~&gr=prismacolor-premier-colored-pencils.html
urltoken CFID=30711387&CFTOKEN=86935984&jsessionid=e030f9774879bb8799de1b40b691027e4b12
validationerror [empty string]


Problem with item sku 33244-PK. Item is found in Solr index but not found in vAvailQtyTbl.

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

ItemIDList: 65465
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 43
col1 beige sienna
col1_sortorder 368
col2 1080
col2_sortorder 1206
col3 [empty string]
color_swatch 212-148-138.jpg
cost 9.96
deal_of_the_week NO
description beige sienna, 1080
group_id 1326
group_uname prismacolor-premier-colored-pencils
id 33244-PK
list_price 20.52
map NO
net_weight 0.16
non_member_discount 35
non_member_price 13.34
prop65 NO
ship_rule_desc STD
shipping STD
sku 33244-PK
sku_pix NO
supplier_id 1
ta_dealer_a_price 0
ta_dealer_c_price 0
ta_price 0
text
array
1 33244-PK
2 beige sienna, 1080
timestamp 2015-03-31T17:53:14.52Z
vip_member_price 11.79

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 65465
CACHED false
EXECUTIONTIME 17
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] = '10927' 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.159.161.138

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=fb~prismacolor~&gr=prismacolor-premier-colored-pencils.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:16:50'}
sessionid e03045fbd689a71c9130a5ca5f11213e6171
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=accessories&CatC=sort~1~fp~3-9~&gr=derwent-artbar-scraper.html
urltoken CFID=30711386&CFTOKEN=70774374&jsessionid=e03045fbd689a71c9130a5ca5f11213e6171
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:16:50'}
sessionid e030f9774879bb8799de1b40b691027e4b12
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=fb~prismacolor~&gr=prismacolor-premier-colored-pencils.html
urltoken CFID=30711387&CFTOKEN=86935984&jsessionid=e030f9774879bb8799de1b40b691027e4b12
validationerror [empty string]


Problem with item sku 29556-PK. Item is found in Solr index but not found in vAvailQtyTbl.

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

ItemIDList: 65465
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 43
col1 black
col1_sortorder 402
col2 935
col2_sortorder 1095
col3 [empty string]
color_swatch 0-0-0.jpg
cost 9.96
deal_of_the_week NO
description black, 935
group_id 1326
group_uname prismacolor-premier-colored-pencils
id 29556-PK
list_price 20.52
map NO
net_weight 0.16
non_member_discount 35
non_member_price 13.34
prop65 NO
ship_rule_desc STD
shipping STD
sku 29556-PK
sku_pix NO
supplier_id 1
ta_dealer_a_price 0
ta_dealer_c_price 0
ta_price 0
text
array
1 29556-PK
2 black, 935
timestamp 2015-03-31T17:53:07.075Z
vip_member_price 11.79

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 65465
CACHED false
EXECUTIONTIME 17
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] = '10927' 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.159.161.138

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=fb~prismacolor~&gr=prismacolor-premier-colored-pencils.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:16:50'}
sessionid e03045fbd689a71c9130a5ca5f11213e6171
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=accessories&CatC=sort~1~fp~3-9~&gr=derwent-artbar-scraper.html
urltoken CFID=30711386&CFTOKEN=70774374&jsessionid=e03045fbd689a71c9130a5ca5f11213e6171
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:16:50'}
sessionid e030f9774879bb8799de1b40b691027e4b12
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=fb~prismacolor~&gr=prismacolor-premier-colored-pencils.html
urltoken CFID=30711387&CFTOKEN=86935984&jsessionid=e030f9774879bb8799de1b40b691027e4b12
validationerror [empty string]


Problem with item sku 43071-PK. Item is found in Solr index but not found in vAvailQtyTbl.

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

ItemIDList: 65465
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 43
col1 black grape
col1_sortorder 438
col2 996
col2_sortorder 1136
col3 [empty string]
color_swatch 50-35-123.jpg
cost 9.96
deal_of_the_week NO
description black grape, 996
group_id 1326
group_uname prismacolor-premier-colored-pencils
id 43071-PK
list_price 20.52
map NO
net_weight 0.16
non_member_discount 35
non_member_price 13.34
prop65 NO
ship_rule_desc STD
shipping STD
sku 43071-PK
sku_pix NO
supplier_id 1
ta_dealer_a_price 0
ta_dealer_c_price 0
ta_price 0
text
array
1 43071-PK
2 black grape, 996
timestamp 2015-03-31T17:53:27.432Z
vip_member_price 11.79

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 65465
CACHED false
EXECUTIONTIME 17
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] = '10927' 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.159.161.138

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=fb~prismacolor~&gr=prismacolor-premier-colored-pencils.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:16:50'}
sessionid e03045fbd689a71c9130a5ca5f11213e6171
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=accessories&CatC=sort~1~fp~3-9~&gr=derwent-artbar-scraper.html
urltoken CFID=30711386&CFTOKEN=70774374&jsessionid=e03045fbd689a71c9130a5ca5f11213e6171
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:16:50'}
sessionid e030f9774879bb8799de1b40b691027e4b12
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=fb~prismacolor~&gr=prismacolor-premier-colored-pencils.html
urltoken CFID=30711387&CFTOKEN=86935984&jsessionid=e030f9774879bb8799de1b40b691027e4b12
validationerror [empty string]


Problem with item sku 37101-PK. Item is found in Solr index but not found in vAvailQtyTbl.

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

ItemIDList: 65465
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 43
col1 blue slate
col1_sortorder 604
col2 1024
col2_sortorder 1159
col3 [empty string]
color_swatch 138-194-233.jpg
cost 9.96
deal_of_the_week NO
description blue slate, 1024
group_id 1326
group_uname prismacolor-premier-colored-pencils
id 37101-PK
list_price 20.52
map NO
net_weight 0.16
non_member_discount 35
non_member_price 13.34
prop65 NO
ship_rule_desc STD
shipping STD
sku 37101-PK
sku_pix NO
supplier_id 1
ta_dealer_a_price 0
ta_dealer_c_price 0
ta_price 0
text
array
1 37101-PK
2 blue slate, 1024
timestamp 2015-03-31T17:53:20.126Z
vip_member_price 11.79

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 65465
CACHED false
EXECUTIONTIME 17
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] = '10927' 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.159.161.138

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=fb~prismacolor~&gr=prismacolor-premier-colored-pencils.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:16:50'}
sessionid e03045fbd689a71c9130a5ca5f11213e6171
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=accessories&CatC=sort~1~fp~3-9~&gr=derwent-artbar-scraper.html
urltoken CFID=30711386&CFTOKEN=70774374&jsessionid=e03045fbd689a71c9130a5ca5f11213e6171
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:16:50'}
sessionid e030f9774879bb8799de1b40b691027e4b12
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=fb~prismacolor~&gr=prismacolor-premier-colored-pencils.html
urltoken CFID=30711387&CFTOKEN=86935984&jsessionid=e030f9774879bb8799de1b40b691027e4b12
validationerror [empty string]


Problem with item sku 76703-PK. Item is found in Solr index but not found in vAvailQtyTbl.

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

ItemIDList: 65465
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 43
col1 blue violet lake
col1_sortorder 614
col2 1079
col2_sortorder 1205
col3 [empty string]
color_swatch 25-50-130.jpg
cost 9.96
deal_of_the_week NO
description blue violet lake, 1079
group_id 1326
group_uname prismacolor-premier-colored-pencils
id 76703-PK
list_price 20.52
map NO
net_weight 0.16
non_member_discount 35
non_member_price 13.34
prop65 NO
ship_rule_desc STD
shipping STD
sku 76703-PK
sku_pix NO
supplier_id 1
ta_dealer_a_price 0
ta_dealer_c_price 0
ta_price 0
text
array
1 76703-PK
2 blue violet lake, 1079
timestamp 2015-03-31T17:54:29.259Z
vip_member_price 11.79

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 65465
CACHED false
EXECUTIONTIME 17
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] = '10927' 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.159.161.138

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=fb~prismacolor~&gr=prismacolor-premier-colored-pencils.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:16:50'}
sessionid e03045fbd689a71c9130a5ca5f11213e6171
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=accessories&CatC=sort~1~fp~3-9~&gr=derwent-artbar-scraper.html
urltoken CFID=30711386&CFTOKEN=70774374&jsessionid=e03045fbd689a71c9130a5ca5f11213e6171
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:16:50'}
sessionid e030f9774879bb8799de1b40b691027e4b12
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=fb~prismacolor~&gr=prismacolor-premier-colored-pencils.html
urltoken CFID=30711387&CFTOKEN=86935984&jsessionid=e030f9774879bb8799de1b40b691027e4b12
validationerror [empty string]


Problem with item sku 59187-PK. Item is found in Solr index but not found in vAvailQtyTbl.

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

ItemIDList: 65465
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 43
col1 blush pink
col1_sortorder 642
col2 928
col2_sortorder 1086
col3 [empty string]
color_swatch 249-187-179.jpg
cost 9.96
deal_of_the_week NO
description blush pink, 928
group_id 1326
group_uname prismacolor-premier-colored-pencils
id 59187-PK
list_price 20.52
map NO
net_weight 0.16
non_member_discount 35
non_member_price 13.34
prop65 NO
ship_rule_desc STD
shipping STD
sku 59187-PK
sku_pix NO
supplier_id 1
ta_dealer_a_price 0
ta_dealer_c_price 0
ta_price 0
text
array
1 59187-PK
2 blush pink, 928
timestamp 2015-03-31T17:53:53.014Z
vip_member_price 11.79

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 65465
CACHED false
EXECUTIONTIME 17
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] = '10927' 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.159.161.138

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=fb~prismacolor~&gr=prismacolor-premier-colored-pencils.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:16:50'}
sessionid e03045fbd689a71c9130a5ca5f11213e6171
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=accessories&CatC=sort~1~fp~3-9~&gr=derwent-artbar-scraper.html
urltoken CFID=30711386&CFTOKEN=70774374&jsessionid=e03045fbd689a71c9130a5ca5f11213e6171
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:16:50'}
sessionid e030f9774879bb8799de1b40b691027e4b12
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=fb~prismacolor~&gr=prismacolor-premier-colored-pencils.html
urltoken CFID=30711387&CFTOKEN=86935984&jsessionid=e030f9774879bb8799de1b40b691027e4b12
validationerror [empty string]


Problem with item sku 58102-PK. Item is found in Solr index but not found in vAvailQtyTbl.

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

ItemIDList: 65465
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 43
col1 bronze
col1_sortorder 791
col2 1028
col2_sortorder 1163
col3 [empty string]
color_swatch 191-167-129.jpg
cost 9.96
deal_of_the_week NO
description bronze, 1028
group_id 1326
group_uname prismacolor-premier-colored-pencils
id 58102-PK
list_price 20.52
map NO
net_weight 0.16
non_member_discount 35
non_member_price 13.34
prop65 NO
ship_rule_desc STD
shipping STD
sku 58102-PK
sku_pix NO
supplier_id 1
ta_dealer_a_price 0
ta_dealer_c_price 0
ta_price 0
text
array
1 58102-PK
2 bronze, 1028
timestamp 2015-03-31T17:53:52.01Z
vip_member_price 11.79

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 65465
CACHED false
EXECUTIONTIME 17
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] = '10927' 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.159.161.138

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=fb~prismacolor~&gr=prismacolor-premier-colored-pencils.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:16:50'}
sessionid e03045fbd689a71c9130a5ca5f11213e6171
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=accessories&CatC=sort~1~fp~3-9~&gr=derwent-artbar-scraper.html
urltoken CFID=30711386&CFTOKEN=70774374&jsessionid=e03045fbd689a71c9130a5ca5f11213e6171
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:16:50'}
sessionid e030f9774879bb8799de1b40b691027e4b12
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=fb~prismacolor~&gr=prismacolor-premier-colored-pencils.html
urltoken CFID=30711387&CFTOKEN=86935984&jsessionid=e030f9774879bb8799de1b40b691027e4b12
validationerror [empty string]


Problem with item sku 33616-PK. Item is found in Solr index but not found in vAvailQtyTbl.

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

ItemIDList: 65465
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 43
col1 burnt ochre
col1_sortorder 869
col2 943
col2_sortorder 1103
col3 [empty string]
color_swatch 180-116-79.jpg
cost 9.96
deal_of_the_week NO
description burnt ochre, 943
group_id 1326
group_uname prismacolor-premier-colored-pencils
id 33616-PK
list_price 20.52
map NO
net_weight 0.16
non_member_discount 35
non_member_price 13.34
prop65 NO
ship_rule_desc STD
shipping STD
sku 33616-PK
sku_pix NO
supplier_id 1
ta_dealer_a_price 0
ta_dealer_c_price 0
ta_price 0
text
array
1 33616-PK
2 burnt ochre, 943
timestamp 2015-03-31T17:53:15.309Z
vip_member_price 11.79

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 65465
CACHED false
EXECUTIONTIME 17
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] = '10927' 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.159.161.138

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=fb~prismacolor~&gr=prismacolor-premier-colored-pencils.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:16:50'}
sessionid e03045fbd689a71c9130a5ca5f11213e6171
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=accessories&CatC=sort~1~fp~3-9~&gr=derwent-artbar-scraper.html
urltoken CFID=30711386&CFTOKEN=70774374&jsessionid=e03045fbd689a71c9130a5ca5f11213e6171
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:16:50'}
sessionid e030f9774879bb8799de1b40b691027e4b12
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=fb~prismacolor~&gr=prismacolor-premier-colored-pencils.html
urltoken CFID=30711387&CFTOKEN=86935984&jsessionid=e030f9774879bb8799de1b40b691027e4b12
validationerror [empty string]


Problem with item sku 20543-PK. Item is found in Solr index but not found in vAvailQtyTbl.

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

ItemIDList: 65465
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 43
col1 canary yellow
col1_sortorder 1061
col2 916
col2_sortorder 1071
col3 [empty string]
color_swatch 255-242-0.jpg
cost 9.96
deal_of_the_week NO
description canary yellow, 916
group_id 1326
group_uname prismacolor-premier-colored-pencils
id 20543-PK
list_price 20.52
map NO
net_weight 0.16
non_member_discount 35
non_member_price 13.34
prop65 NO
ship_rule_desc STD
shipping STD
sku 20543-PK
sku_pix NO
supplier_id 1
ta_dealer_a_price 0
ta_dealer_c_price 0
ta_price 0
text
array
1 20543-PK
2 canary yellow, 916
timestamp 2015-03-31T17:52:54.097Z
vip_member_price 11.79

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 65465
CACHED false
EXECUTIONTIME 17
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] = '10927' 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.159.161.138

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=fb~prismacolor~&gr=prismacolor-premier-colored-pencils.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:16:50'}
sessionid e03045fbd689a71c9130a5ca5f11213e6171
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=accessories&CatC=sort~1~fp~3-9~&gr=derwent-artbar-scraper.html
urltoken CFID=30711386&CFTOKEN=70774374&jsessionid=e03045fbd689a71c9130a5ca5f11213e6171
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:16:50'}
sessionid e030f9774879bb8799de1b40b691027e4b12
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=fb~prismacolor~&gr=prismacolor-premier-colored-pencils.html
urltoken CFID=30711387&CFTOKEN=86935984&jsessionid=e030f9774879bb8799de1b40b691027e4b12
validationerror [empty string]


Problem with item sku 48581-PK. Item is found in Solr index but not found in vAvailQtyTbl.

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

ItemIDList: 65465
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 43
col1 carmine red
col1_sortorder 1116
col2 926
col2_sortorder 1084
col3 [empty string]
color_swatch 241-93-90.jpg
cost 9.96
deal_of_the_week NO
description carmine red, 926
group_id 1326
group_uname prismacolor-premier-colored-pencils
id 48581-PK
list_price 20.52
map NO
net_weight 0.16
non_member_discount 35
non_member_price 13.34
prop65 NO
ship_rule_desc STD
shipping STD
sku 48581-PK
sku_pix NO
supplier_id 1
ta_dealer_a_price 0
ta_dealer_c_price 0
ta_price 0
text
array
1 48581-PK
2 carmine red, 926
timestamp 2015-03-31T17:53:35.032Z
vip_member_price 11.79

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 65465
CACHED false
EXECUTIONTIME 17
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] = '10927' 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.159.161.138

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=fb~prismacolor~&gr=prismacolor-premier-colored-pencils.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:16:50'}
sessionid e03045fbd689a71c9130a5ca5f11213e6171
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=accessories&CatC=sort~1~fp~3-9~&gr=derwent-artbar-scraper.html
urltoken CFID=30711386&CFTOKEN=70774374&jsessionid=e03045fbd689a71c9130a5ca5f11213e6171
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:16:50'}
sessionid e030f9774879bb8799de1b40b691027e4b12
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=fb~prismacolor~&gr=prismacolor-premier-colored-pencils.html
urltoken CFID=30711387&CFTOKEN=86935984&jsessionid=e030f9774879bb8799de1b40b691027e4b12
validationerror [empty string]


Problem with item sku 84258-PK. Item is found in Solr index but not found in vAvailQtyTbl.

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

ItemIDList: 65465
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 43
col1 celadon green
col1_sortorder 1143
col2 1020
col2_sortorder 1155
col3 [empty string]
color_swatch 176-201-198.jpg
cost 9.96
deal_of_the_week NO
description celadon green, 1020
group_id 1326
group_uname prismacolor-premier-colored-pencils
id 84258-PK
list_price 20.52
map NO
net_weight 0.16
non_member_discount 35
non_member_price 13.34
prop65 NO
ship_rule_desc STD
shipping STD
sku 84258-PK
sku_pix NO
supplier_id 1
ta_dealer_a_price 0
ta_dealer_c_price 0
ta_price 0
text
array
1 84258-PK
2 celadon green, 1020
timestamp 2015-03-31T17:54:37.968Z
vip_member_price 11.79

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 65465
CACHED false
EXECUTIONTIME 17
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] = '10927' 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.159.161.138

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=fb~prismacolor~&gr=prismacolor-premier-colored-pencils.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:16:50'}
sessionid e03045fbd689a71c9130a5ca5f11213e6171
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=accessories&CatC=sort~1~fp~3-9~&gr=derwent-artbar-scraper.html
urltoken CFID=30711386&CFTOKEN=70774374&jsessionid=e03045fbd689a71c9130a5ca5f11213e6171
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:16:50'}
sessionid e030f9774879bb8799de1b40b691027e4b12
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=fb~prismacolor~&gr=prismacolor-premier-colored-pencils.html
urltoken CFID=30711387&CFTOKEN=86935984&jsessionid=e030f9774879bb8799de1b40b691027e4b12
validationerror [empty string]


Problem with item sku 81416-PK. Item is found in Solr index but not found in vAvailQtyTbl.

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

ItemIDList: 65465
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 43
col1 chartreuse
col1_sortorder 1192
col2 989
col2_sortorder 1130
col3 [empty string]
color_swatch 197-200-46.jpg
cost 9.96
deal_of_the_week NO
description chartreuse, 989
group_id 1326
group_uname prismacolor-premier-colored-pencils
id 81416-PK
list_price 20.52
map NO
net_weight 0.16
non_member_discount 35
non_member_price 13.34
prop65 NO
ship_rule_desc STD
shipping STD
sku 81416-PK
sku_pix NO
supplier_id 1
ta_dealer_a_price 0
ta_dealer_c_price 0
ta_price 0
text
array
1 81416-PK
2 chartreuse, 989
timestamp 2015-03-31T17:54:34.669Z
vip_member_price 11.79

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 65465
CACHED false
EXECUTIONTIME 17
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] = '10927' 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.159.161.138

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=fb~prismacolor~&gr=prismacolor-premier-colored-pencils.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:16:50'}
sessionid e03045fbd689a71c9130a5ca5f11213e6171
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=accessories&CatC=sort~1~fp~3-9~&gr=derwent-artbar-scraper.html
urltoken CFID=30711386&CFTOKEN=70774374&jsessionid=e03045fbd689a71c9130a5ca5f11213e6171
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:16:50'}
sessionid e030f9774879bb8799de1b40b691027e4b12
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=fb~prismacolor~&gr=prismacolor-premier-colored-pencils.html
urltoken CFID=30711387&CFTOKEN=86935984&jsessionid=e030f9774879bb8799de1b40b691027e4b12
validationerror [empty string]


Problem with item sku 33245-PK. Item is found in Solr index but not found in vAvailQtyTbl.

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

ItemIDList: 65465
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 43
col1 chestnut
col1_sortorder 1206
col2 1081
col2_sortorder 1207
col3 [empty string]
color_swatch 137-48-3.jpg
cost 9.96
deal_of_the_week NO
description chestnut, 1081
group_id 1326
group_uname prismacolor-premier-colored-pencils
id 33245-PK
list_price 20.52
map NO
net_weight 0.16
non_member_discount 35
non_member_price 13.34
prop65 NO
ship_rule_desc STD
shipping STD
sku 33245-PK
sku_pix NO
supplier_id 1
ta_dealer_a_price 0
ta_dealer_c_price 0
ta_price 0
text
array
1 33245-PK
2 chestnut, 1081
timestamp 2015-03-31T17:53:14.524Z
vip_member_price 11.79

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 65465
CACHED false
EXECUTIONTIME 17
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] = '10927' 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.159.161.138

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=fb~prismacolor~&gr=prismacolor-premier-colored-pencils.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:16:50'}
sessionid e03045fbd689a71c9130a5ca5f11213e6171
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=accessories&CatC=sort~1~fp~3-9~&gr=derwent-artbar-scraper.html
urltoken CFID=30711386&CFTOKEN=70774374&jsessionid=e03045fbd689a71c9130a5ca5f11213e6171
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:16:50'}
sessionid e030f9774879bb8799de1b40b691027e4b12
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=fb~prismacolor~&gr=prismacolor-premier-colored-pencils.html
urltoken CFID=30711387&CFTOKEN=86935984&jsessionid=e030f9774879bb8799de1b40b691027e4b12
validationerror [empty string]


Problem with item sku 33246-PK. Item is found in Solr index but not found in vAvailQtyTbl.

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

ItemIDList: 65465
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 43
col1 chocolate
col1_sortorder 1221
col2 1082
col2_sortorder 1208
col3 [empty string]
color_swatch 126-85-58.jpg
cost 9.96
deal_of_the_week NO
description chocolate, 1082
group_id 1326
group_uname prismacolor-premier-colored-pencils
id 33246-PK
list_price 20.52
map NO
net_weight 0.16
non_member_discount 35
non_member_price 13.34
prop65 NO
ship_rule_desc STD
shipping STD
sku 33246-PK
sku_pix NO
supplier_id 1
ta_dealer_a_price 0
ta_dealer_c_price 0
ta_price 0
text
array
1 33246-PK
2 chocolate, 1082
timestamp 2015-03-31T17:53:14.528Z
vip_member_price 11.79

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 65465
CACHED false
EXECUTIONTIME 17
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] = '10927' 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.159.161.138

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=fb~prismacolor~&gr=prismacolor-premier-colored-pencils.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:16:50'}
sessionid e03045fbd689a71c9130a5ca5f11213e6171
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=accessories&CatC=sort~1~fp~3-9~&gr=derwent-artbar-scraper.html
urltoken CFID=30711386&CFTOKEN=70774374&jsessionid=e03045fbd689a71c9130a5ca5f11213e6171
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:16:50'}
sessionid e030f9774879bb8799de1b40b691027e4b12
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=fb~prismacolor~&gr=prismacolor-premier-colored-pencils.html
urltoken CFID=30711387&CFTOKEN=86935984&jsessionid=e030f9774879bb8799de1b40b691027e4b12
validationerror [empty string]


Problem with item sku 33271-PK. Item is found in Solr index but not found in vAvailQtyTbl.

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

ItemIDList: 65465
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 43
col1 clay rose
col1_sortorder 1318
col2 1017
col2_sortorder 1152
col3 [empty string]
color_swatch 187-160-166.jpg
cost 9.96
deal_of_the_week NO
description clay rose, 1017
group_id 1326
group_uname prismacolor-premier-colored-pencils
id 33271-PK
list_price 20.52
map NO
net_weight 0.16
non_member_discount 35
non_member_price 13.34
prop65 NO
ship_rule_desc STD
shipping STD
sku 33271-PK
sku_pix NO
supplier_id 1
ta_dealer_a_price 0
ta_dealer_c_price 0
ta_price 0
text
array
1 33271-PK
2 clay rose, 1017
timestamp 2015-03-31T17:53:14.588Z
vip_member_price 11.79

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 65465
CACHED false
EXECUTIONTIME 17
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] = '10927' 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.159.161.138

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=fb~prismacolor~&gr=prismacolor-premier-colored-pencils.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:16:50'}
sessionid e03045fbd689a71c9130a5ca5f11213e6171
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=accessories&CatC=sort~1~fp~3-9~&gr=derwent-artbar-scraper.html
urltoken CFID=30711386&CFTOKEN=70774374&jsessionid=e03045fbd689a71c9130a5ca5f11213e6171
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:16:50'}
sessionid e030f9774879bb8799de1b40b691027e4b12
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=fb~prismacolor~&gr=prismacolor-premier-colored-pencils.html
urltoken CFID=30711387&CFTOKEN=86935984&jsessionid=e030f9774879bb8799de1b40b691027e4b12
validationerror [empty string]


Problem with item sku 80012-PK. Item is found in Solr index but not found in vAvailQtyTbl.

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

ItemIDList: 65465
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 43
col1 cloud blue
col1_sortorder 1339
col2 1023
col2_sortorder 1158
col3 [empty string]
color_swatch 194-226-247.jpg
cost 9.96
deal_of_the_week NO
description cloud blue, 1023
group_id 1326
group_uname prismacolor-premier-colored-pencils
id 80012-PK
list_price 20.52
map NO
net_weight 0.16
non_member_discount 35
non_member_price 13.34
prop65 NO
ship_rule_desc STD
shipping STD
sku 80012-PK
sku_pix NO
supplier_id 1
ta_dealer_a_price 0
ta_dealer_c_price 0
ta_price 0
text
array
1 80012-PK
2 cloud blue, 1023
timestamp 2015-03-31T17:54:33.047Z
vip_member_price 11.79

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 65465
CACHED false
EXECUTIONTIME 17
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] = '10927' 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.159.161.138

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=fb~prismacolor~&gr=prismacolor-premier-colored-pencils.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:16:50'}
sessionid e03045fbd689a71c9130a5ca5f11213e6171
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=accessories&CatC=sort~1~fp~3-9~&gr=derwent-artbar-scraper.html
urltoken CFID=30711386&CFTOKEN=70774374&jsessionid=e03045fbd689a71c9130a5ca5f11213e6171
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:16:50'}
sessionid e030f9774879bb8799de1b40b691027e4b12
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=fb~prismacolor~&gr=prismacolor-premier-colored-pencils.html
urltoken CFID=30711387&CFTOKEN=86935984&jsessionid=e030f9774879bb8799de1b40b691027e4b12
validationerror [empty string]


Problem with item sku 38795-PK. Item is found in Solr index but not found in vAvailQtyTbl.

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

ItemIDList: 65465
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 43
col1 colorless blender
col1_sortorder 1467
col2 1077
col2_sortorder 1203
col3 [empty string]
color_swatch 255-255-255.jpg
cost 9.96
deal_of_the_week NO
description colorless blender, 1077
group_id 1326
group_uname prismacolor-premier-colored-pencils
id 38795-PK
list_price 20.52
map NO
net_weight 0.16
non_member_discount 35
non_member_price 13.34
prop65 NO
ship_rule_desc STD
shipping STD
sku 38795-PK
sku_pix NO
supplier_id 1
ta_dealer_a_price 0
ta_dealer_c_price 0
ta_price 0
text
array
1 38795-PK
2 colorless blender, 1077
timestamp 2015-03-31T17:53:22.654Z
vip_member_price 11.79

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 65465
CACHED false
EXECUTIONTIME 17
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] = '10927' 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.159.161.138

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=fb~prismacolor~&gr=prismacolor-premier-colored-pencils.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:16:50'}
sessionid e03045fbd689a71c9130a5ca5f11213e6171
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=accessories&CatC=sort~1~fp~3-9~&gr=derwent-artbar-scraper.html
urltoken CFID=30711386&CFTOKEN=70774374&jsessionid=e03045fbd689a71c9130a5ca5f11213e6171
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:16:50'}
sessionid e030f9774879bb8799de1b40b691027e4b12
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=fb~prismacolor~&gr=prismacolor-premier-colored-pencils.html
urltoken CFID=30711387&CFTOKEN=86935984&jsessionid=e030f9774879bb8799de1b40b691027e4b12
validationerror [empty string]


Problem with item sku 31139-PK. Item is found in Solr index but not found in vAvailQtyTbl.

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

ItemIDList: 65465
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 43
col1 cool grey 10%
col1_sortorder 1497
col2 1059
col2_sortorder 1189
col3 [empty string]
color_swatch 249-251-252.jpg
cost 9.96
deal_of_the_week NO
description cool grey 10%, 1059
group_id 1326
group_uname prismacolor-premier-colored-pencils
id 31139-PK
list_price 20.52
map NO
net_weight 0.16
non_member_discount 35
non_member_price 13.34
prop65 NO
ship_rule_desc STD
shipping STD
sku 31139-PK
sku_pix NO
supplier_id 1
ta_dealer_a_price 0
ta_dealer_c_price 0
ta_price 0
text
array
1 31139-PK
2 cool grey 10%, 1059
timestamp 2015-03-31T17:53:09.402Z
vip_member_price 11.79

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 65465
CACHED false
EXECUTIONTIME 17
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] = '10927' 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.159.161.138

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=fb~prismacolor~&gr=prismacolor-premier-colored-pencils.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:16:50'}
sessionid e03045fbd689a71c9130a5ca5f11213e6171
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=accessories&CatC=sort~1~fp~3-9~&gr=derwent-artbar-scraper.html
urltoken CFID=30711386&CFTOKEN=70774374&jsessionid=e03045fbd689a71c9130a5ca5f11213e6171
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:16:50'}
sessionid e030f9774879bb8799de1b40b691027e4b12
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=fb~prismacolor~&gr=prismacolor-premier-colored-pencils.html
urltoken CFID=30711387&CFTOKEN=86935984&jsessionid=e030f9774879bb8799de1b40b691027e4b12
validationerror [empty string]


Problem with item sku 68712-PK. Item is found in Solr index but not found in vAvailQtyTbl.

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

ItemIDList: 65465
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 43
col1 cool grey 20%
col1_sortorder 1502
col2 1061
col2_sortorder 1191
col3 [empty string]
color_swatch 245-242-244.jpg
cost 9.96
deal_of_the_week NO
description cool grey 20%, 1061
group_id 1326
group_uname prismacolor-premier-colored-pencils
id 68712-PK
list_price 20.52
map NO
net_weight 0.16
non_member_discount 35
non_member_price 13.34
prop65 NO
ship_rule_desc STD
shipping STD
sku 68712-PK
sku_pix NO
supplier_id 1
ta_dealer_a_price 0
ta_dealer_c_price 0
ta_price 0
text
array
1 68712-PK
2 cool grey 20%, 1061
timestamp 2015-03-31T17:54:15.066Z
vip_member_price 11.79

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 65465
CACHED false
EXECUTIONTIME 17
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] = '10927' 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.159.161.138

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=fb~prismacolor~&gr=prismacolor-premier-colored-pencils.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:16:50'}
sessionid e03045fbd689a71c9130a5ca5f11213e6171
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=accessories&CatC=sort~1~fp~3-9~&gr=derwent-artbar-scraper.html
urltoken CFID=30711386&CFTOKEN=70774374&jsessionid=e03045fbd689a71c9130a5ca5f11213e6171
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:16:50'}
sessionid e030f9774879bb8799de1b40b691027e4b12
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=fb~prismacolor~&gr=prismacolor-premier-colored-pencils.html
urltoken CFID=30711387&CFTOKEN=86935984&jsessionid=e030f9774879bb8799de1b40b691027e4b12
validationerror [empty string]


Problem with item sku 73970-PK. Item is found in Solr index but not found in vAvailQtyTbl.

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

ItemIDList: 65465
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 43
col1 cool grey 30%
col1_sortorder 1505
col2 1062
col2_sortorder 1192
col3 [empty string]
color_swatch 219-229-234.jpg
cost 9.96
deal_of_the_week NO
description cool grey 30%, 1062
group_id 1326
group_uname prismacolor-premier-colored-pencils
id 73970-PK
list_price 20.52
map NO
net_weight 0.16
non_member_discount 35
non_member_price 13.34
prop65 NO
ship_rule_desc STD
shipping STD
sku 73970-PK
sku_pix NO
supplier_id 1
ta_dealer_a_price 0
ta_dealer_c_price 0
ta_price 0
text
array
1 73970-PK
2 cool grey 30%, 1062
timestamp 2015-03-31T17:54:25.514Z
vip_member_price 11.79

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 65465
CACHED false
EXECUTIONTIME 17
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] = '10927' 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.159.161.138

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=fb~prismacolor~&gr=prismacolor-premier-colored-pencils.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:16:50'}
sessionid e03045fbd689a71c9130a5ca5f11213e6171
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=accessories&CatC=sort~1~fp~3-9~&gr=derwent-artbar-scraper.html
urltoken CFID=30711386&CFTOKEN=70774374&jsessionid=e03045fbd689a71c9130a5ca5f11213e6171
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:16:50'}
sessionid e030f9774879bb8799de1b40b691027e4b12
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=fb~prismacolor~&gr=prismacolor-premier-colored-pencils.html
urltoken CFID=30711387&CFTOKEN=86935984&jsessionid=e030f9774879bb8799de1b40b691027e4b12
validationerror [empty string]


Problem with item sku 30626-PK. Item is found in Solr index but not found in vAvailQtyTbl.

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

ItemIDList: 65465
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 43
col1 cool grey 50%
col1_sortorder 1510
col2 1063
col2_sortorder 1193
col3 [empty string]
color_swatch 201-210-215.jpg
cost 9.96
deal_of_the_week NO
description cool grey 50%, 1063
group_id 1326
group_uname prismacolor-premier-colored-pencils
id 30626-PK
list_price 20.52
map NO
net_weight 0.16
non_member_discount 35
non_member_price 13.34
prop65 NO
ship_rule_desc STD
shipping STD
sku 30626-PK
sku_pix NO
supplier_id 1
ta_dealer_a_price 0
ta_dealer_c_price 0
ta_price 0
text
array
1 30626-PK
2 cool grey 50%, 1063
timestamp 2015-03-31T17:53:08.86Z
vip_member_price 11.79

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 65465
CACHED false
EXECUTIONTIME 17
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] = '10927' 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.159.161.138

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=fb~prismacolor~&gr=prismacolor-premier-colored-pencils.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:16:50'}
sessionid e03045fbd689a71c9130a5ca5f11213e6171
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=accessories&CatC=sort~1~fp~3-9~&gr=derwent-artbar-scraper.html
urltoken CFID=30711386&CFTOKEN=70774374&jsessionid=e03045fbd689a71c9130a5ca5f11213e6171
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:16:50'}
sessionid e030f9774879bb8799de1b40b691027e4b12
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=fb~prismacolor~&gr=prismacolor-premier-colored-pencils.html
urltoken CFID=30711387&CFTOKEN=86935984&jsessionid=e030f9774879bb8799de1b40b691027e4b12
validationerror [empty string]


Problem with item sku 37665-PK. Item is found in Solr index but not found in vAvailQtyTbl.

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

ItemIDList: 65465
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 43
col1 cool grey 70%
col1_sortorder 1515
col2 1065
col2_sortorder 1194
col3 [empty string]
color_swatch 112-137-150.jpg
cost 9.96
deal_of_the_week NO
description cool grey 70%, 1065
group_id 1326
group_uname prismacolor-premier-colored-pencils
id 37665-PK
list_price 20.52
map NO
net_weight 0.16
non_member_discount 35
non_member_price 13.34
prop65 NO
ship_rule_desc STD
shipping STD
sku 37665-PK
sku_pix NO
supplier_id 1
ta_dealer_a_price 0
ta_dealer_c_price 0
ta_price 0
text
array
1 37665-PK
2 cool grey 70%, 1065
timestamp 2015-03-31T17:53:20.867Z
vip_member_price 11.79

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 65465
CACHED false
EXECUTIONTIME 17
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] = '10927' 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.159.161.138

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=fb~prismacolor~&gr=prismacolor-premier-colored-pencils.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:16:50'}
sessionid e03045fbd689a71c9130a5ca5f11213e6171
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=accessories&CatC=sort~1~fp~3-9~&gr=derwent-artbar-scraper.html
urltoken CFID=30711386&CFTOKEN=70774374&jsessionid=e03045fbd689a71c9130a5ca5f11213e6171
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:16:50'}
sessionid e030f9774879bb8799de1b40b691027e4b12
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=fb~prismacolor~&gr=prismacolor-premier-colored-pencils.html
urltoken CFID=30711387&CFTOKEN=86935984&jsessionid=e030f9774879bb8799de1b40b691027e4b12
validationerror [empty string]


Problem with item sku 30462-PK. Item is found in Solr index but not found in vAvailQtyTbl.

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

ItemIDList: 65465
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 43
col1 cool grey 90%
col1_sortorder 1519
col2 1067
col2_sortorder 1195
col3 [empty string]
color_swatch 64-80-90.jpg
cost 9.96
deal_of_the_week NO
description cool grey 90%, 1067
group_id 1326
group_uname prismacolor-premier-colored-pencils
id 30462-PK
list_price 20.52
map NO
net_weight 0.16
non_member_discount 35
non_member_price 13.34
prop65 NO
ship_rule_desc STD
shipping STD
sku 30462-PK
sku_pix NO
supplier_id 1
ta_dealer_a_price 0
ta_dealer_c_price 0
ta_price 0
text
array
1 30462-PK
2 cool grey 90%, 1067
timestamp 2015-03-31T17:53:08.54Z
vip_member_price 11.79

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 65465
CACHED false
EXECUTIONTIME 17
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] = '10927' 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.159.161.138

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=fb~prismacolor~&gr=prismacolor-premier-colored-pencils.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:16:50'}
sessionid e03045fbd689a71c9130a5ca5f11213e6171
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=accessories&CatC=sort~1~fp~3-9~&gr=derwent-artbar-scraper.html
urltoken CFID=30711386&CFTOKEN=70774374&jsessionid=e03045fbd689a71c9130a5ca5f11213e6171
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:16:50'}
sessionid e030f9774879bb8799de1b40b691027e4b12
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=fb~prismacolor~&gr=prismacolor-premier-colored-pencils.html
urltoken CFID=30711387&CFTOKEN=86935984&jsessionid=e030f9774879bb8799de1b40b691027e4b12
validationerror [empty string]


Problem with item sku 35040-PK. Item is found in Solr index but not found in vAvailQtyTbl.

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

ItemIDList: 65465
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 43
col1 Copenhagen blue
col1_sortorder 1528
col2 906
col2_sortorder 1059
col3 [empty string]
color_swatch 0-123-196.jpg
cost 9.96
deal_of_the_week NO
description Copenhagen blue, 906
group_id 1326
group_uname prismacolor-premier-colored-pencils
id 35040-PK
list_price 20.52
map NO
net_weight 0.16
non_member_discount 35
non_member_price 13.34
prop65 NO
ship_rule_desc STD
shipping STD
sku 35040-PK
sku_pix NO
supplier_id 1
ta_dealer_a_price 0
ta_dealer_c_price 0
ta_price 0
text
array
1 35040-PK
2 Copenhagen blue, 906
timestamp 2015-03-31T17:53:17.045Z
vip_member_price 11.79

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 65465
CACHED false
EXECUTIONTIME 17
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] = '10927' 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.159.161.138

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=fb~prismacolor~&gr=prismacolor-premier-colored-pencils.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:16:50'}
sessionid e03045fbd689a71c9130a5ca5f11213e6171
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=accessories&CatC=sort~1~fp~3-9~&gr=derwent-artbar-scraper.html
urltoken CFID=30711386&CFTOKEN=70774374&jsessionid=e03045fbd689a71c9130a5ca5f11213e6171
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:16:50'}
sessionid e030f9774879bb8799de1b40b691027e4b12
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=fb~prismacolor~&gr=prismacolor-premier-colored-pencils.html
urltoken CFID=30711387&CFTOKEN=86935984&jsessionid=e030f9774879bb8799de1b40b691027e4b12
validationerror [empty string]


Problem with item sku 10808-PK. Item is found in Solr index but not found in vAvailQtyTbl.

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

ItemIDList: 65465
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 43
col1 cream
col1_sortorder 1595
col2 914
col2_sortorder 1069
col3 [empty string]
color_swatch 255-252-221.jpg
cost 9.96
deal_of_the_week NO
description cream, 914
group_id 1326
group_uname prismacolor-premier-colored-pencils
id 10808-PK
list_price 20.52
map NO
net_weight 0.16
non_member_discount 35
non_member_price 13.34
prop65 NO
ship_rule_desc STD
shipping STD
sku 10808-PK
sku_pix NO
supplier_id 1
ta_dealer_a_price 0
ta_dealer_c_price 0
ta_price 0
text
array
1 10808-PK
2 cream, 914
timestamp 2015-03-31T17:52:36.371Z
vip_member_price 11.79

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 65465
CACHED false
EXECUTIONTIME 17
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] = '10927' 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.159.161.138

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=fb~prismacolor~&gr=prismacolor-premier-colored-pencils.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:16:50'}
sessionid e03045fbd689a71c9130a5ca5f11213e6171
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=accessories&CatC=sort~1~fp~3-9~&gr=derwent-artbar-scraper.html
urltoken CFID=30711386&CFTOKEN=70774374&jsessionid=e03045fbd689a71c9130a5ca5f11213e6171
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:16:50'}
sessionid e030f9774879bb8799de1b40b691027e4b12
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=fb~prismacolor~&gr=prismacolor-premier-colored-pencils.html
urltoken CFID=30711387&CFTOKEN=86935984&jsessionid=e030f9774879bb8799de1b40b691027e4b12
validationerror [empty string]


Problem with item sku 46644-PK. Item is found in Solr index but not found in vAvailQtyTbl.

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

ItemIDList: 65465
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 43
col1 crimson lake
col1_sortorder 1611
col2 925
col2_sortorder 1083
col3 [empty string]
color_swatch 137-22-53.jpg
cost 9.96
deal_of_the_week NO
description crimson lake, 925
group_id 1326
group_uname prismacolor-premier-colored-pencils
id 46644-PK
list_price 20.52
map NO
net_weight 0.16
non_member_discount 35
non_member_price 13.34
prop65 NO
ship_rule_desc STD
shipping STD
sku 46644-PK
sku_pix NO
supplier_id 1
ta_dealer_a_price 0
ta_dealer_c_price 0
ta_price 0
text
array
1 46644-PK
2 crimson lake, 925
timestamp 2015-03-31T17:53:32.003Z
vip_member_price 11.79

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 65465
CACHED false
EXECUTIONTIME 17
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] = '10927' 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.159.161.138

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=fb~prismacolor~&gr=prismacolor-premier-colored-pencils.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:16:50'}
sessionid e03045fbd689a71c9130a5ca5f11213e6171
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=accessories&CatC=sort~1~fp~3-9~&gr=derwent-artbar-scraper.html
urltoken CFID=30711386&CFTOKEN=70774374&jsessionid=e03045fbd689a71c9130a5ca5f11213e6171
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:16:50'}
sessionid e030f9774879bb8799de1b40b691027e4b12
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=fb~prismacolor~&gr=prismacolor-premier-colored-pencils.html
urltoken CFID=30711387&CFTOKEN=86935984&jsessionid=e030f9774879bb8799de1b40b691027e4b12
validationerror [empty string]


Problem with item sku 20604-PK. Item is found in Solr index but not found in vAvailQtyTbl.

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

ItemIDList: 65465
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 43
col1 crimson red
col1_sortorder 1616
col2 924
col2_sortorder 1082
col3 [empty string]
color_swatch 198-38-44.jpg
cost 9.96
deal_of_the_week NO
description crimson red, 924
group_id 1326
group_uname prismacolor-premier-colored-pencils
id 20604-PK
list_price 20.52
map NO
net_weight 0.16
non_member_discount 35
non_member_price 13.34
prop65 NO
ship_rule_desc STD
shipping STD
sku 20604-PK
sku_pix NO
supplier_id 1
ta_dealer_a_price 0
ta_dealer_c_price 0
ta_price 0
text
array
1 20604-PK
2 crimson red, 924
timestamp 2015-03-31T17:52:54.191Z
vip_member_price 11.79

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 65465
CACHED false
EXECUTIONTIME 17
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] = '10927' 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.159.161.138

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=fb~prismacolor~&gr=prismacolor-premier-colored-pencils.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:16:50'}
sessionid e03045fbd689a71c9130a5ca5f11213e6171
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=accessories&CatC=sort~1~fp~3-9~&gr=derwent-artbar-scraper.html
urltoken CFID=30711386&CFTOKEN=70774374&jsessionid=e03045fbd689a71c9130a5ca5f11213e6171
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:16:50'}
sessionid e030f9774879bb8799de1b40b691027e4b12
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=fb~prismacolor~&gr=prismacolor-premier-colored-pencils.html
urltoken CFID=30711387&CFTOKEN=86935984&jsessionid=e030f9774879bb8799de1b40b691027e4b12
validationerror [empty string]


Problem with item sku 63119-PK. Item is found in Solr index but not found in vAvailQtyTbl.

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

ItemIDList: 65465
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 43
col1 dark brown
col1_sortorder 1683
col2 946
col2_sortorder 1106
col3 [empty string]
color_swatch 89-87-75.jpg
cost 9.96
deal_of_the_week NO
description dark brown, 946
group_id 1326
group_uname prismacolor-premier-colored-pencils
id 63119-PK
list_price 20.52
map NO
net_weight 0.16
non_member_discount 35
non_member_price 13.34
prop65 NO
ship_rule_desc STD
shipping STD
sku 63119-PK
sku_pix NO
supplier_id 1
ta_dealer_a_price 0
ta_dealer_c_price 0
ta_price 0
text
array
1 63119-PK
2 dark brown, 946
timestamp 2015-03-31T17:54:05.12Z
vip_member_price 11.79

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 65465
CACHED false
EXECUTIONTIME 17
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] = '10927' 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.159.161.138

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=fb~prismacolor~&gr=prismacolor-premier-colored-pencils.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:16:50'}
sessionid e03045fbd689a71c9130a5ca5f11213e6171
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=accessories&CatC=sort~1~fp~3-9~&gr=derwent-artbar-scraper.html
urltoken CFID=30711386&CFTOKEN=70774374&jsessionid=e03045fbd689a71c9130a5ca5f11213e6171
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:16:50'}
sessionid e030f9774879bb8799de1b40b691027e4b12
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=fb~prismacolor~&gr=prismacolor-premier-colored-pencils.html
urltoken CFID=30711387&CFTOKEN=86935984&jsessionid=e030f9774879bb8799de1b40b691027e4b12
validationerror [empty string]


Problem with item sku 78259-PK. Item is found in Solr index but not found in vAvailQtyTbl.

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

ItemIDList: 65465
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 43
col1 dark green
col1_sortorder 1711
col2 908
col2_sortorder 1061
col3 [empty string]
color_swatch 2-108-74.jpg
cost 9.96
deal_of_the_week NO
description dark green, 908
group_id 1326
group_uname prismacolor-premier-colored-pencils
id 78259-PK
list_price 20.52
map NO
net_weight 0.16
non_member_discount 35
non_member_price 13.34
prop65 NO
ship_rule_desc STD
shipping STD
sku 78259-PK
sku_pix NO
supplier_id 1
ta_dealer_a_price 0
ta_dealer_c_price 0
ta_price 0
text
array
1 78259-PK
2 dark green, 908
timestamp 2015-03-31T17:54:31.108Z
vip_member_price 11.79

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 65465
CACHED false
EXECUTIONTIME 17
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] = '10927' 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.159.161.138

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=fb~prismacolor~&gr=prismacolor-premier-colored-pencils.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:16:50'}
sessionid e03045fbd689a71c9130a5ca5f11213e6171
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=accessories&CatC=sort~1~fp~3-9~&gr=derwent-artbar-scraper.html
urltoken CFID=30711386&CFTOKEN=70774374&jsessionid=e03045fbd689a71c9130a5ca5f11213e6171
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:16:50'}
sessionid e030f9774879bb8799de1b40b691027e4b12
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=fb~prismacolor~&gr=prismacolor-premier-colored-pencils.html
urltoken CFID=30711387&CFTOKEN=86935984&jsessionid=e030f9774879bb8799de1b40b691027e4b12
validationerror [empty string]


Problem with item sku 19763-PK. Item is found in Solr index but not found in vAvailQtyTbl.

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

ItemIDList: 65465
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 43
col1 dark purple
col1_sortorder 1746
col2 931
col2_sortorder 1090
col3 [empty string]