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

Lettering Enamel

by 1-Shot


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

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

ItemIDList: 39567
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 27
barcode 705002014931
barcode_type UPC
col1 aqua
col1_sortorder 182
col2 pint
col2_sortorder 2563
col3 can
col3_sortorder 310
color_swatch 77-199-210.jpg
cost 12.75
deal_of_the_week NO
description aqua, pint, can
group_id 107
group_uname 1-shot-lettering-enamel
id 45764
list_price 20.9
map NO
mfr_num 149-L-PT
net_weight 1.58
non_member_discount 19
non_member_price 16.92
prop65 NO
ship_rule_desc ORMD
shipping ORMD
sku 45764
sku_pix YES
supplier_id 1
ta_dealer_a_price 14
ta_dealer_c_price 14
ta_price 19.86
text
array
1 45764
2 149-L-PT
3 aqua, pint, can
timestamp 2015-03-27T14:47:19.129Z
vip_member_price 15.26

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 39567
CACHED false
EXECUTIONTIME 2
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] = '1533' 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.140.37

URL: www.misterart.com:/index.cfm:module=painting&catB=enamels&CatC=sort~1~&gr=1-shot-lettering-enamel.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:09:19'}
sessionid e0303fb3914d6e09e39953a4f25281422251
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=printmaking&catB=linoleum-wood-block-printing&gr=speedball-inking-plate.html
urltoken CFID=29773454&CFTOKEN=23490685&jsessionid=e0303fb3914d6e09e39953a4f25281422251
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:09:18'}
sessionid e030e601ddd3f2d4e0b67523e4b4d81d3e68
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=enamels&CatC=sort~1~&gr=1-shot-lettering-enamel.html
urltoken CFID=29773453&CFTOKEN=73597212&jsessionid=e030e601ddd3f2d4e0b67523e4b4d81d3e68
validationerror [empty string]


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

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

ItemIDList: 39567
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 27
barcode 705002014948
barcode_type UPC
col1 aqua
col1_sortorder 182
col2 half pint
col2_sortorder 2491
col3 can
col3_sortorder 310
color_swatch 77-199-210.jpg
cost 9.04
deal_of_the_week NO
description aqua, half pint, can
group_id 107
group_uname 1-shot-lettering-enamel
id 54611
list_price 14.81
map NO
mfr_num 149-L 1/2 PT
net_weight 0.84
non_member_discount 19
non_member_price 11.99
prop65 NO
ship_rule_desc ORMD
shipping ORMD
sku 54611
sku_pix YES
supplier_id 1
ta_dealer_a_price 9.92
ta_dealer_c_price 9.92
ta_price 14.07
text
array
1 54611
2 149-L 1/2 PT
3 aqua, half pint, can
timestamp 2015-03-27T14:47:29.205Z
vip_member_price 10.81

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 39567
CACHED false
EXECUTIONTIME 2
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] = '1533' 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.140.37

URL: www.misterart.com:/index.cfm:module=painting&catB=enamels&CatC=sort~1~&gr=1-shot-lettering-enamel.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:09:19'}
sessionid e0303fb3914d6e09e39953a4f25281422251
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=printmaking&catB=linoleum-wood-block-printing&gr=speedball-inking-plate.html
urltoken CFID=29773454&CFTOKEN=23490685&jsessionid=e0303fb3914d6e09e39953a4f25281422251
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:09:18'}
sessionid e030e601ddd3f2d4e0b67523e4b4d81d3e68
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=enamels&CatC=sort~1~&gr=1-shot-lettering-enamel.html
urltoken CFID=29773453&CFTOKEN=73597212&jsessionid=e030e601ddd3f2d4e0b67523e4b4d81d3e68
validationerror [empty string]


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

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

ItemIDList: 39567
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 27
barcode 705002015044
barcode_type UPC
col1 blue green
col1_sortorder 573
col2 half pint
col2_sortorder 2491
col3 can
col3_sortorder 310
color_swatch 0-119-119.jpg
cost 9.04
deal_of_the_week NO
description blue green, half pint, can
group_id 107
group_uname 1-shot-lettering-enamel
id 16587
list_price 14.81
map NO
mfr_num 150-L 1/2 PT
net_weight 0.84
non_member_discount 19
non_member_price 11.99
prop65 NO
ship_rule_desc ORMD
shipping ORMD
sku 16587
sku_pix YES
supplier_id 1
ta_dealer_a_price 9.92
ta_dealer_c_price 9.92
ta_price 14.07
text
array
1 16587
2 150-L 1/2 PT
3 blue green, half pint, can
timestamp 2015-03-27T14:46:35.978Z
vip_member_price 10.81

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 39567
CACHED false
EXECUTIONTIME 2
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] = '1533' 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.140.37

URL: www.misterart.com:/index.cfm:module=painting&catB=enamels&CatC=sort~1~&gr=1-shot-lettering-enamel.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:09:19'}
sessionid e0303fb3914d6e09e39953a4f25281422251
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=printmaking&catB=linoleum-wood-block-printing&gr=speedball-inking-plate.html
urltoken CFID=29773454&CFTOKEN=23490685&jsessionid=e0303fb3914d6e09e39953a4f25281422251
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:09:18'}
sessionid e030e601ddd3f2d4e0b67523e4b4d81d3e68
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=enamels&CatC=sort~1~&gr=1-shot-lettering-enamel.html
urltoken CFID=29773453&CFTOKEN=73597212&jsessionid=e030e601ddd3f2d4e0b67523e4b4d81d3e68
validationerror [empty string]


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

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

ItemIDList: 39567
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 27
barcode 705002015037
barcode_type UPC
col1 blue green
col1_sortorder 573
col2 pint
col2_sortorder 2563
col3 can
col3_sortorder 310
color_swatch 0-119-119.jpg
cost 12.75
deal_of_the_week NO
description blue green, pint, can
group_id 107
group_uname 1-shot-lettering-enamel
id 49760
list_price 20.9
map NO
mfr_num 150-L PT
net_weight 1.58
non_member_discount 19
non_member_price 16.92
prop65 NO
ship_rule_desc ORMD
shipping ORMD
sku 49760
sku_pix YES
supplier_id 1
ta_dealer_a_price 14
ta_dealer_c_price 14
ta_price 19.86
text
array
1 49760
2 150-L PT
3 blue green, pint, can
timestamp 2015-03-27T14:47:24.217Z
vip_member_price 15.26

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 39567
CACHED false
EXECUTIONTIME 2
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] = '1533' 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.140.37

URL: www.misterart.com:/index.cfm:module=painting&catB=enamels&CatC=sort~1~&gr=1-shot-lettering-enamel.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:09:19'}
sessionid e0303fb3914d6e09e39953a4f25281422251
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=printmaking&catB=linoleum-wood-block-printing&gr=speedball-inking-plate.html
urltoken CFID=29773454&CFTOKEN=23490685&jsessionid=e0303fb3914d6e09e39953a4f25281422251
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:09:18'}
sessionid e030e601ddd3f2d4e0b67523e4b4d81d3e68
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=enamels&CatC=sort~1~&gr=1-shot-lettering-enamel.html
urltoken CFID=29773453&CFTOKEN=73597212&jsessionid=e030e601ddd3f2d4e0b67523e4b4d81d3e68
validationerror [empty string]


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

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

ItemIDList: 39567
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 27
barcode 705002010445
barcode_type UPC
col1 bright red
col1_sortorder 728
col2 half pint
col2_sortorder 2491
col3 can
col3_sortorder 310
color_swatch 164-0-62.jpg
cost 12.69
deal_of_the_week NO
description bright red, half pint, can
group_id 107
group_uname 1-shot-lettering-enamel
id 14184
list_price 20.79
map NO
mfr_num 104-L 1/2 PT
net_weight 0.84
non_member_discount 19
non_member_price 16.83
prop65 NO
ship_rule_desc ORMD
shipping ORMD
sku 14184
sku_pix YES
supplier_id 1
ta_dealer_a_price 13.93
ta_dealer_c_price 13.93
ta_price 19.75
text
array
1 14184
2 104-L 1/2 PT
3 bright red, half pint, can
timestamp 2015-03-27T14:46:30.123Z
vip_member_price 15.18

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 39567
CACHED false
EXECUTIONTIME 2
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] = '1533' 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.140.37

URL: www.misterart.com:/index.cfm:module=painting&catB=enamels&CatC=sort~1~&gr=1-shot-lettering-enamel.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:09:19'}
sessionid e0303fb3914d6e09e39953a4f25281422251
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=printmaking&catB=linoleum-wood-block-printing&gr=speedball-inking-plate.html
urltoken CFID=29773454&CFTOKEN=23490685&jsessionid=e0303fb3914d6e09e39953a4f25281422251
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:09:18'}
sessionid e030e601ddd3f2d4e0b67523e4b4d81d3e68
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=enamels&CatC=sort~1~&gr=1-shot-lettering-enamel.html
urltoken CFID=29773453&CFTOKEN=73597212&jsessionid=e030e601ddd3f2d4e0b67523e4b4d81d3e68
validationerror [empty string]


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

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

ItemIDList: 39567
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 27
barcode 705002010438
barcode_type UPC
col1 bright red
col1_sortorder 728
col2 pint
col2_sortorder 2563
col3 can
col3_sortorder 310
color_swatch 164-0-62.jpg
cost 18.45
deal_of_the_week NO
description bright red, pint, can
group_id 107
group_uname 1-shot-lettering-enamel
id 50076
list_price 30.24
map NO
mfr_num 104-L PT
net_weight 1.58
non_member_discount 19
non_member_price 24.48
prop65 NO
ship_rule_desc ORMD
shipping ORMD
sku 50076
sku_pix YES
supplier_id 1
ta_dealer_a_price 20.26
ta_dealer_c_price 20.26
ta_price 28.73
text
array
1 50076
2 104-L PT
3 bright red, pint, can
timestamp 2015-03-27T14:47:24.43Z
vip_member_price 22.08

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 39567
CACHED false
EXECUTIONTIME 2
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] = '1533' 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.140.37

URL: www.misterart.com:/index.cfm:module=painting&catB=enamels&CatC=sort~1~&gr=1-shot-lettering-enamel.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:09:19'}
sessionid e0303fb3914d6e09e39953a4f25281422251
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=printmaking&catB=linoleum-wood-block-printing&gr=speedball-inking-plate.html
urltoken CFID=29773454&CFTOKEN=23490685&jsessionid=e0303fb3914d6e09e39953a4f25281422251
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:09:18'}
sessionid e030e601ddd3f2d4e0b67523e4b4d81d3e68
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=enamels&CatC=sort~1~&gr=1-shot-lettering-enamel.html
urltoken CFID=29773453&CFTOKEN=73597212&jsessionid=e030e601ddd3f2d4e0b67523e4b4d81d3e68
validationerror [empty string]


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

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

ItemIDList: 39567
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 27
barcode 705002015631
barcode_type UPC
col1 brilliant blue
col1_sortorder 752
col2 pint
col2_sortorder 2563
col3 can
col3_sortorder 310
color_swatch 47-47-104.jpg
cost 14.13
deal_of_the_week NO
description brilliant blue, pint, can
group_id 107
group_uname 1-shot-lettering-enamel
id 80735
list_price 23.15
map NO
mfr_num 156-L PT
net_weight 1.58
non_member_discount 19
non_member_price 18.74
prop65 NO
ship_rule_desc ORMD
shipping ORMD
sku 80735
sku_pix YES
supplier_id 1
ta_dealer_a_price 15.51
ta_dealer_c_price 15.51
ta_price 21.99
text
array
1 80735
2 156-L PT
3 brilliant blue, pint, can
timestamp 2015-03-27T14:48:11.534Z
vip_member_price 16.9

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 39567
CACHED false
EXECUTIONTIME 2
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] = '1533' 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.140.37

URL: www.misterart.com:/index.cfm:module=painting&catB=enamels&CatC=sort~1~&gr=1-shot-lettering-enamel.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:09:19'}
sessionid e0303fb3914d6e09e39953a4f25281422251
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=printmaking&catB=linoleum-wood-block-printing&gr=speedball-inking-plate.html
urltoken CFID=29773454&CFTOKEN=23490685&jsessionid=e0303fb3914d6e09e39953a4f25281422251
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:09:18'}
sessionid e030e601ddd3f2d4e0b67523e4b4d81d3e68
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=enamels&CatC=sort~1~&gr=1-shot-lettering-enamel.html
urltoken CFID=29773453&CFTOKEN=73597212&jsessionid=e030e601ddd3f2d4e0b67523e4b4d81d3e68
validationerror [empty string]


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

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

ItemIDList: 39567
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 27
barcode 705002015648
barcode_type UPC
col1 brilliant blue
col1_sortorder 752
col2 half pint
col2_sortorder 2491
col3 can
col3_sortorder 310
color_swatch 47-47-104.jpg
cost 9.99
deal_of_the_week NO
description brilliant blue, half pint, can
group_id 107
group_uname 1-shot-lettering-enamel
id 87203
list_price 16.38
map NO
mfr_num 156-L 1/2 PT
net_weight 0.84
non_member_discount 19
non_member_price 13.26
prop65 NO
ship_rule_desc ORMD
shipping ORMD
sku 87203
sku_pix YES
supplier_id 1
ta_dealer_a_price 10.97
ta_dealer_c_price 10.97
ta_price 15.56
text
array
1 87203
2 156-L 1/2 PT
3 brilliant blue, half pint, can
timestamp 2015-03-27T14:48:19.202Z
vip_member_price 11.96

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 39567
CACHED false
EXECUTIONTIME 2
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] = '1533' 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.140.37

URL: www.misterart.com:/index.cfm:module=painting&catB=enamels&CatC=sort~1~&gr=1-shot-lettering-enamel.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:09:19'}
sessionid e0303fb3914d6e09e39953a4f25281422251
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=printmaking&catB=linoleum-wood-block-printing&gr=speedball-inking-plate.html
urltoken CFID=29773454&CFTOKEN=23490685&jsessionid=e0303fb3914d6e09e39953a4f25281422251
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:09:18'}
sessionid e030e601ddd3f2d4e0b67523e4b4d81d3e68
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=enamels&CatC=sort~1~&gr=1-shot-lettering-enamel.html
urltoken CFID=29773453&CFTOKEN=73597212&jsessionid=e030e601ddd3f2d4e0b67523e4b4d81d3e68
validationerror [empty string]


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

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

ItemIDList: 39567
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 27
barcode 705002013446
barcode_type UPC
col1 chrome yellow
col1_sortorder 1254
col2 half pint
col2_sortorder 2491
col3 can
col3_sortorder 310
color_swatch 240-199-47.jpg
cost 11.21
deal_of_the_week NO
description chrome yellow, half pint, can
group_id 107
group_uname 1-shot-lettering-enamel
id 54765
list_price 18.38
map NO
mfr_num 134-L 1/2 PT
net_weight 0.84
non_member_discount 19
non_member_price 14.88
prop65 NO
ship_rule_desc ORMD
shipping ORMD
sku 54765
sku_pix YES
supplier_id 1
ta_dealer_a_price 12.31
ta_dealer_c_price 12.31
ta_price 17.46
text
array
1 54765
2 134-L 1/2 PT
3 chrome yellow, half pint, can
timestamp 2015-03-27T14:47:29.297Z
vip_member_price 13.42

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 39567
CACHED false
EXECUTIONTIME 2
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] = '1533' 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.140.37

URL: www.misterart.com:/index.cfm:module=painting&catB=enamels&CatC=sort~1~&gr=1-shot-lettering-enamel.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:09:19'}
sessionid e0303fb3914d6e09e39953a4f25281422251
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=printmaking&catB=linoleum-wood-block-printing&gr=speedball-inking-plate.html
urltoken CFID=29773454&CFTOKEN=23490685&jsessionid=e0303fb3914d6e09e39953a4f25281422251
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:09:18'}
sessionid e030e601ddd3f2d4e0b67523e4b4d81d3e68
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=enamels&CatC=sort~1~&gr=1-shot-lettering-enamel.html
urltoken CFID=29773453&CFTOKEN=73597212&jsessionid=e030e601ddd3f2d4e0b67523e4b4d81d3e68
validationerror [empty string]


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

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

ItemIDList: 39567
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 27
barcode 705002013439
barcode_type UPC
col1 chrome yellow
col1_sortorder 1254
col2 pint
col2_sortorder 2563
col3 can
col3_sortorder 310
color_swatch 240-199-47.jpg
cost 15.76
deal_of_the_week NO
description chrome yellow, pint, can
group_id 107
group_uname 1-shot-lettering-enamel
id 63554
list_price 25.83
map NO
mfr_num 134-L PT
net_weight 1.58
non_member_discount 19
non_member_price 20.91
prop65 NO
ship_rule_desc ORMD
shipping ORMD
sku 63554
sku_pix YES
supplier_id 1
ta_dealer_a_price 17.31
ta_dealer_c_price 17.31
ta_price 24.54
text
array
1 63554
2 134-L PT
3 chrome yellow, pint, can
timestamp 2015-03-27T14:47:43.824Z
vip_member_price 18.86

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 39567
CACHED false
EXECUTIONTIME 2
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] = '1533' 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.140.37

URL: www.misterart.com:/index.cfm:module=painting&catB=enamels&CatC=sort~1~&gr=1-shot-lettering-enamel.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:09:19'}
sessionid e0303fb3914d6e09e39953a4f25281422251
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=printmaking&catB=linoleum-wood-block-printing&gr=speedball-inking-plate.html
urltoken CFID=29773454&CFTOKEN=23490685&jsessionid=e0303fb3914d6e09e39953a4f25281422251
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:09:18'}
sessionid e030e601ddd3f2d4e0b67523e4b4d81d3e68
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=enamels&CatC=sort~1~&gr=1-shot-lettering-enamel.html
urltoken CFID=29773453&CFTOKEN=73597212&jsessionid=e030e601ddd3f2d4e0b67523e4b4d81d3e68
validationerror [empty string]


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

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

ItemIDList: 39567
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 27
barcode 705002012043
barcode_type UPC
col1 coral
col1_sortorder 1543
col2 half pint
col2_sortorder 2491
col3 can
col3_sortorder 310
color_swatch 240-171-138.jpg
cost 11.21
deal_of_the_week NO
description coral, half pint, can
group_id 107
group_uname 1-shot-lettering-enamel
id 74844
list_price 18.38
map NO
mfr_num 120-L 1/2 PT
net_weight 0.72
non_member_discount 19
non_member_price 14.88
prop65 NO
ship_rule_desc ORMD
shipping ORMD
sku 74844
sku_pix YES
supplier_id 1
ta_dealer_a_price 12.31
ta_dealer_c_price 12.31
ta_price 17.46
text
array
1 74844
2 120-L 1/2 PT
3 coral, half pint, can
timestamp 2015-03-27T14:48:05.023Z
vip_member_price 13.42

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 39567
CACHED false
EXECUTIONTIME 2
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] = '1533' 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.140.37

URL: www.misterart.com:/index.cfm:module=painting&catB=enamels&CatC=sort~1~&gr=1-shot-lettering-enamel.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:09:19'}
sessionid e0303fb3914d6e09e39953a4f25281422251
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=printmaking&catB=linoleum-wood-block-printing&gr=speedball-inking-plate.html
urltoken CFID=29773454&CFTOKEN=23490685&jsessionid=e0303fb3914d6e09e39953a4f25281422251
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:09:18'}
sessionid e030e601ddd3f2d4e0b67523e4b4d81d3e68
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=enamels&CatC=sort~1~&gr=1-shot-lettering-enamel.html
urltoken CFID=29773453&CFTOKEN=73597212&jsessionid=e030e601ddd3f2d4e0b67523e4b4d81d3e68
validationerror [empty string]


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

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

ItemIDList: 39567
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 27
barcode 705002015846
barcode_type UPC
col1 dark blue
col1_sortorder 1674
col2 half pint
col2_sortorder 2491
col3 can
col3_sortorder 310
color_swatch 0-0-164.jpg
cost 9.04
deal_of_the_week NO
description dark blue, half pint, can
group_id 107
group_uname 1-shot-lettering-enamel
id 53199
list_price 14.81
map NO
mfr_num 158-L 1/2 PT
net_weight 0.84
non_member_discount 19
non_member_price 11.99
prop65 NO
ship_rule_desc ORMD
shipping ORMD
sku 53199
sku_pix YES
supplier_id 1
ta_dealer_a_price 9.92
ta_dealer_c_price 9.92
ta_price 14.07
text
array
1 53199
2 158-L 1/2 PT
3 dark blue, half pint, can
timestamp 2015-03-27T14:47:28.343Z
vip_member_price 10.81

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 39567
CACHED false
EXECUTIONTIME 2
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] = '1533' 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.140.37

URL: www.misterart.com:/index.cfm:module=painting&catB=enamels&CatC=sort~1~&gr=1-shot-lettering-enamel.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:09:19'}
sessionid e0303fb3914d6e09e39953a4f25281422251
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=printmaking&catB=linoleum-wood-block-printing&gr=speedball-inking-plate.html
urltoken CFID=29773454&CFTOKEN=23490685&jsessionid=e0303fb3914d6e09e39953a4f25281422251
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:09:18'}
sessionid e030e601ddd3f2d4e0b67523e4b4d81d3e68
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=enamels&CatC=sort~1~&gr=1-shot-lettering-enamel.html
urltoken CFID=29773453&CFTOKEN=73597212&jsessionid=e030e601ddd3f2d4e0b67523e4b4d81d3e68
validationerror [empty string]


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

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

ItemIDList: 39567
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 27
barcode 705002015839
barcode_type UPC
col1 dark blue
col1_sortorder 1674
col2 pint
col2_sortorder 2563
col3 can
col3_sortorder 310
color_swatch 0-0-164.jpg
cost 12.75
deal_of_the_week NO
description dark blue, pint, can
group_id 107
group_uname 1-shot-lettering-enamel
id 57207
list_price 20.9
map NO
mfr_num 158-L PT
net_weight 1.58
non_member_discount 19
non_member_price 16.92
prop65 NO
ship_rule_desc ORMD
shipping ORMD
sku 57207
sku_pix YES
supplier_id 1
ta_dealer_a_price 14
ta_dealer_c_price 14
ta_price 19.86
text
array
1 57207
2 158-L PT
3 dark blue, pint, can
timestamp 2015-03-27T14:47:32.291Z
vip_member_price 15.26

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 39567
CACHED false
EXECUTIONTIME 2
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] = '1533' 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.140.37

URL: www.misterart.com:/index.cfm:module=painting&catB=enamels&CatC=sort~1~&gr=1-shot-lettering-enamel.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:09:19'}
sessionid e0303fb3914d6e09e39953a4f25281422251
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=printmaking&catB=linoleum-wood-block-printing&gr=speedball-inking-plate.html
urltoken CFID=29773454&CFTOKEN=23490685&jsessionid=e0303fb3914d6e09e39953a4f25281422251
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:09:18'}
sessionid e030e601ddd3f2d4e0b67523e4b4d81d3e68
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=enamels&CatC=sort~1~&gr=1-shot-lettering-enamel.html
urltoken CFID=29773453&CFTOKEN=73597212&jsessionid=e030e601ddd3f2d4e0b67523e4b4d81d3e68
validationerror [empty string]


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

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

ItemIDList: 39567
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 27
barcode 705002011541
barcode_type UPC
col1 dark brown
col1_sortorder 1680
col2 half pint
col2_sortorder 2491
col3 can
col3_sortorder 310
color_swatch 119-0-51.jpg
cost 9.04
deal_of_the_week NO
description dark brown, half pint, can
group_id 107
group_uname 1-shot-lettering-enamel
id 66611
list_price 14.81
map NO
mfr_num 115-L 1/2 PT
net_weight 0.84
non_member_discount 19
non_member_price 11.99
prop65 NO
ship_rule_desc ORMD
shipping ORMD
sku 66611
sku_pix YES
supplier_id 1
ta_dealer_a_price 9.92
ta_dealer_c_price 9.92
ta_price 14.07
text
array
1 66611
2 115-L 1/2 PT
3 dark brown, half pint, can
timestamp 2015-03-27T14:47:49.146Z
vip_member_price 10.81

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 39567
CACHED false
EXECUTIONTIME 2
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] = '1533' 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.140.37

URL: www.misterart.com:/index.cfm:module=painting&catB=enamels&CatC=sort~1~&gr=1-shot-lettering-enamel.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:09:19'}
sessionid e0303fb3914d6e09e39953a4f25281422251
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=printmaking&catB=linoleum-wood-block-printing&gr=speedball-inking-plate.html
urltoken CFID=29773454&CFTOKEN=23490685&jsessionid=e0303fb3914d6e09e39953a4f25281422251
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:09:18'}
sessionid e030e601ddd3f2d4e0b67523e4b4d81d3e68
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=enamels&CatC=sort~1~&gr=1-shot-lettering-enamel.html
urltoken CFID=29773453&CFTOKEN=73597212&jsessionid=e030e601ddd3f2d4e0b67523e4b4d81d3e68
validationerror [empty string]


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

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

ItemIDList: 39567
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 27
barcode 705002014849
barcode_type UPC
col1 dark green
col1_sortorder 1708
col2 half pint
col2_sortorder 2491
col3 can
col3_sortorder 310
color_swatch 0-119-106.jpg
cost 9.77
deal_of_the_week NO
description dark green, half pint, can
group_id 107
group_uname 1-shot-lettering-enamel
id 40212
list_price 16.01
map NO
mfr_num 148-L 1/2 PT
net_weight 0.84
non_member_discount 19
non_member_price 12.96
prop65 NO
ship_rule_desc ORMD
shipping ORMD
sku 40212
sku_pix YES
supplier_id 1
ta_dealer_a_price 10.73
ta_dealer_c_price 10.73
ta_price 15.21
text
array
1 40212
2 148-L 1/2 PT
3 dark green, half pint, can
timestamp 2015-03-27T14:47:12.469Z
vip_member_price 11.69

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 39567
CACHED false
EXECUTIONTIME 2
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] = '1533' 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.140.37

URL: www.misterart.com:/index.cfm:module=painting&catB=enamels&CatC=sort~1~&gr=1-shot-lettering-enamel.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:09:19'}
sessionid e0303fb3914d6e09e39953a4f25281422251
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=printmaking&catB=linoleum-wood-block-printing&gr=speedball-inking-plate.html
urltoken CFID=29773454&CFTOKEN=23490685&jsessionid=e0303fb3914d6e09e39953a4f25281422251
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:09:18'}
sessionid e030e601ddd3f2d4e0b67523e4b4d81d3e68
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=enamels&CatC=sort~1~&gr=1-shot-lettering-enamel.html
urltoken CFID=29773453&CFTOKEN=73597212&jsessionid=e030e601ddd3f2d4e0b67523e4b4d81d3e68
validationerror [empty string]


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

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

ItemIDList: 39567
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 27
barcode 705002014832
barcode_type UPC
col1 dark green
col1_sortorder 1708
col2 pint
col2_sortorder 2563
col3 can
col3_sortorder 310
color_swatch 0-119-106.jpg
cost 13.91
deal_of_the_week NO
description dark green, pint, can
group_id 107
group_uname 1-shot-lettering-enamel
id 88306
list_price 22.79
map NO
mfr_num 148-L PT
net_weight 1.58
non_member_discount 19
non_member_price 18.45
prop65 NO
ship_rule_desc ORMD
shipping ORMD
sku 88306
sku_pix YES
supplier_id 1
ta_dealer_a_price 15.27
ta_dealer_c_price 15.27
ta_price 21.65
text
array
1 88306
2 148-L PT
3 dark green, pint, can
timestamp 2015-03-27T14:48:21.709Z
vip_member_price 16.64

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 39567
CACHED false
EXECUTIONTIME 2
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] = '1533' 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.140.37

URL: www.misterart.com:/index.cfm:module=painting&catB=enamels&CatC=sort~1~&gr=1-shot-lettering-enamel.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:09:19'}
sessionid e0303fb3914d6e09e39953a4f25281422251
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=printmaking&catB=linoleum-wood-block-printing&gr=speedball-inking-plate.html
urltoken CFID=29773454&CFTOKEN=23490685&jsessionid=e0303fb3914d6e09e39953a4f25281422251
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:09:18'}
sessionid e030e601ddd3f2d4e0b67523e4b4d81d3e68
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=enamels&CatC=sort~1~&gr=1-shot-lettering-enamel.html
urltoken CFID=29773453&CFTOKEN=73597212&jsessionid=e030e601ddd3f2d4e0b67523e4b4d81d3e68
validationerror [empty string]


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

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

ItemIDList: 39567
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 27
barcode 705002014245
barcode_type UPC
col1 emerald
col1_sortorder 2027
col2 half pint
col2_sortorder 2491
col3 can
col3_sortorder 310
color_swatch 0-164-123.jpg
cost 9.77
deal_of_the_week NO
description emerald, half pint, can
group_id 107
group_uname 1-shot-lettering-enamel
id 32636
list_price 16.01
map NO
mfr_num 142-L 1/2 PT
net_weight 0.84
non_member_discount 19
non_member_price 12.96
prop65 NO
ship_rule_desc ORMD
shipping ORMD
sku 32636
sku_pix YES
supplier_id 1
ta_dealer_a_price 10.73
ta_dealer_c_price 10.73
ta_price 15.21
text
array
1 32636
2 142-L 1/2 PT
3 emerald, half pint, can
timestamp 2015-03-27T14:46:58.638Z
vip_member_price 11.69

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 39567
CACHED false
EXECUTIONTIME 2
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] = '1533' 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.140.37

URL: www.misterart.com:/index.cfm:module=painting&catB=enamels&CatC=sort~1~&gr=1-shot-lettering-enamel.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:09:19'}
sessionid e0303fb3914d6e09e39953a4f25281422251
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=printmaking&catB=linoleum-wood-block-printing&gr=speedball-inking-plate.html
urltoken CFID=29773454&CFTOKEN=23490685&jsessionid=e0303fb3914d6e09e39953a4f25281422251
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:09:18'}
sessionid e030e601ddd3f2d4e0b67523e4b4d81d3e68
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=enamels&CatC=sort~1~&gr=1-shot-lettering-enamel.html
urltoken CFID=29773453&CFTOKEN=73597212&jsessionid=e030e601ddd3f2d4e0b67523e4b4d81d3e68
validationerror [empty string]


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

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

ItemIDList: 39567
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 27
barcode 705002014238
barcode_type UPC
col1 emerald green
col1_sortorder 2033
col2 pint
col2_sortorder 2563
col3 can
col3_sortorder 310
color_swatch 0-164-123.jpg
cost 13.91
deal_of_the_week NO
description emerald green, pint, can
group_id 107
group_uname 1-shot-lettering-enamel
id 44315
list_price 22.79
map NO
mfr_num 142-L PT
net_weight 1.58
non_member_discount 19
non_member_price 18.45
prop65 NO
ship_rule_desc ORMD
shipping ORMD
sku 44315
sku_pix YES
supplier_id 1
ta_dealer_a_price 15.27
ta_dealer_c_price 15.27
ta_price 21.65
text
array
1 44315
2 142-L PT
3 emerald green, pint, can
timestamp 2015-03-27T14:47:17.041Z
vip_member_price 16.64

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 39567
CACHED false
EXECUTIONTIME 2
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] = '1533' 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.140.37

URL: www.misterart.com:/index.cfm:module=painting&catB=enamels&CatC=sort~1~&gr=1-shot-lettering-enamel.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:09:19'}
sessionid e0303fb3914d6e09e39953a4f25281422251
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=printmaking&catB=linoleum-wood-block-printing&gr=speedball-inking-plate.html
urltoken CFID=29773454&CFTOKEN=23490685&jsessionid=e0303fb3914d6e09e39953a4f25281422251
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:09:18'}
sessionid e030e601ddd3f2d4e0b67523e4b4d81d3e68
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=enamels&CatC=sort~1~&gr=1-shot-lettering-enamel.html
urltoken CFID=29773453&CFTOKEN=73597212&jsessionid=e030e601ddd3f2d4e0b67523e4b4d81d3e68
validationerror [empty string]


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

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

ItemIDList: 39567
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 27
barcode 705002010230
barcode_type UPC
col1 fire red
col1_sortorder 2140
col2 pint
col2_sortorder 2563
col3 can
col3_sortorder 310
color_swatch 195-47-47.jpg
cost 19.12
deal_of_the_week NO
description fire red, pint, can
group_id 107
group_uname 1-shot-lettering-enamel
id 15299
list_price 31.34
map NO
mfr_num 102-L PT
net_weight 1.58
non_member_discount 19
non_member_price 25.37
prop65 NO
ship_rule_desc ORMD
shipping ORMD
sku 15299
sku_pix YES
supplier_id 1
ta_dealer_a_price 21
ta_dealer_c_price 21
ta_price 29.77
text
array
1 15299
2 102-L PT
3 fire red, pint, can
timestamp 2015-03-27T14:46:34.16Z
vip_member_price 22.88

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 39567
CACHED false
EXECUTIONTIME 2
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] = '1533' 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.140.37

URL: www.misterart.com:/index.cfm:module=painting&catB=enamels&CatC=sort~1~&gr=1-shot-lettering-enamel.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:09:19'}
sessionid e0303fb3914d6e09e39953a4f25281422251
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=printmaking&catB=linoleum-wood-block-printing&gr=speedball-inking-plate.html
urltoken CFID=29773454&CFTOKEN=23490685&jsessionid=e0303fb3914d6e09e39953a4f25281422251
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:09:18'}
sessionid e030e601ddd3f2d4e0b67523e4b4d81d3e68
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=enamels&CatC=sort~1~&gr=1-shot-lettering-enamel.html
urltoken CFID=29773453&CFTOKEN=73597212&jsessionid=e030e601ddd3f2d4e0b67523e4b4d81d3e68
validationerror [empty string]


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

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

ItemIDList: 39567
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 27
barcode 705002010247
barcode_type UPC
col1 fire red
col1_sortorder 2140
col2 half pint
col2_sortorder 2491
col3 can
col3_sortorder 310
color_swatch 195-47-47.jpg
cost 13.01
deal_of_the_week NO
description fire red, half pint, can
group_id 107
group_uname 1-shot-lettering-enamel
id 69944
list_price 21.32
map NO
mfr_num 102-L 1/2 PT
net_weight 0.84
non_member_discount 19
non_member_price 17.26
prop65 NO
ship_rule_desc ORMD
shipping ORMD
sku 69944
sku_pix YES
supplier_id 1
ta_dealer_a_price 14.28
ta_dealer_c_price 14.28
ta_price 20.25
text
array
1 69944
2 102-L 1/2 PT
3 fire red, half pint, can
timestamp 2015-03-27T14:47:55.434Z
vip_member_price 15.56

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 39567
CACHED false
EXECUTIONTIME 2
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] = '1533' 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.140.37

URL: www.misterart.com:/index.cfm:module=painting&catB=enamels&CatC=sort~1~&gr=1-shot-lettering-enamel.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:09:19'}
sessionid e0303fb3914d6e09e39953a4f25281422251
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=printmaking&catB=linoleum-wood-block-printing&gr=speedball-inking-plate.html
urltoken CFID=29773454&CFTOKEN=23490685&jsessionid=e0303fb3914d6e09e39953a4f25281422251
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:09:18'}
sessionid e030e601ddd3f2d4e0b67523e4b4d81d3e68
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=enamels&CatC=sort~1~&gr=1-shot-lettering-enamel.html
urltoken CFID=29773453&CFTOKEN=73597212&jsessionid=e030e601ddd3f2d4e0b67523e4b4d81d3e68
validationerror [empty string]


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

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

ItemIDList: 39567
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 27
barcode 705002019134
barcode_type UPC
col1 imitation gold
col1_sortorder 2916
col2 pint
col2_sortorder 2563
col3 can
col3_sortorder 310
color_swatch 240-183-196.jpg
cost 13.91
deal_of_the_week NO
description imitation gold, pint, can
group_id 107
group_uname 1-shot-lettering-enamel
id 11255
list_price 22.79
map NO
mfr_num 191-L PT
net_weight 1.58
non_member_discount 19
non_member_price 18.45
prop65 NO
ship_rule_desc ORMD
shipping ORMD
sku 11255
sku_pix YES
supplier_id 1
ta_dealer_a_price 15.27
ta_dealer_c_price 15.27
ta_price 21.65
text
array
1 11255
2 191-L PT
3 imitation gold, pint, can
timestamp 2015-03-27T14:46:25.364Z
vip_member_price 16.64

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 39567
CACHED false
EXECUTIONTIME 2
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] = '1533' 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.140.37

URL: www.misterart.com:/index.cfm:module=painting&catB=enamels&CatC=sort~1~&gr=1-shot-lettering-enamel.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:09:19'}
sessionid e0303fb3914d6e09e39953a4f25281422251
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=printmaking&catB=linoleum-wood-block-printing&gr=speedball-inking-plate.html
urltoken CFID=29773454&CFTOKEN=23490685&jsessionid=e0303fb3914d6e09e39953a4f25281422251
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:09:18'}
sessionid e030e601ddd3f2d4e0b67523e4b4d81d3e68
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=enamels&CatC=sort~1~&gr=1-shot-lettering-enamel.html
urltoken CFID=29773453&CFTOKEN=73597212&jsessionid=e030e601ddd3f2d4e0b67523e4b4d81d3e68
validationerror [empty string]


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

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

ItemIDList: 39567
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 27
barcode 705002019141
barcode_type UPC
col1 imitation gold
col1_sortorder 2916
col2 half pint
col2_sortorder 2491
col3 can
col3_sortorder 310
color_swatch 240-172-92.jpg
cost 9.77
deal_of_the_week NO
description imitation gold, half pint, can
group_id 107
group_uname 1-shot-lettering-enamel
id 85326
list_price 16.01
map NO
mfr_num 191-L 1/2 PT
net_weight 0.84
non_member_discount 19
non_member_price 12.96
prop65 NO
ship_rule_desc ORMD
shipping ORMD
sku 85326
sku_pix YES
supplier_id 1
ta_dealer_a_price 10.73
ta_dealer_c_price 10.73
ta_price 15.21
text
array
1 85326
2 191-L 1/2 PT
3 imitation gold, half pint, can
timestamp 2015-03-27T14:48:16.181Z
vip_member_price 11.69

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 39567
CACHED false
EXECUTIONTIME 2
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] = '1533' 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.140.37

URL: www.misterart.com:/index.cfm:module=painting&catB=enamels&CatC=sort~1~&gr=1-shot-lettering-enamel.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:09:19'}
sessionid e0303fb3914d6e09e39953a4f25281422251
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=printmaking&catB=linoleum-wood-block-printing&gr=speedball-inking-plate.html
urltoken CFID=29773454&CFTOKEN=23490685&jsessionid=e0303fb3914d6e09e39953a4f25281422251
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:09:18'}
sessionid e030e601ddd3f2d4e0b67523e4b4d81d3e68
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=enamels&CatC=sort~1~&gr=1-shot-lettering-enamel.html
urltoken CFID=29773453&CFTOKEN=73597212&jsessionid=e030e601ddd3f2d4e0b67523e4b4d81d3e68
validationerror [empty string]


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

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

ItemIDList: 39567
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 27
barcode 705002011640
barcode_type UPC
col1 ivory
col1_sortorder 3118
col2 half pint
col2_sortorder 2491
col3 can
col3_sortorder 310
color_swatch 240-219-183.jpg
cost 9.04
deal_of_the_week NO
description ivory, half pint, can
group_id 107
group_uname 1-shot-lettering-enamel
id 18988
list_price 14.81
map NO
mfr_num 116-L 1/2 PT
net_weight 0.84
non_member_discount 19
non_member_price 11.99
prop65 NO
ship_rule_desc ORMD
shipping ORMD
sku 18988
sku_pix YES
supplier_id 1
ta_dealer_a_price 9.92
ta_dealer_c_price 9.92
ta_price 14.07
text
array
1 18988
2 116-L 1/2 PT
3 ivory, half pint, can
timestamp 2015-03-27T14:46:39.226Z
vip_member_price 10.81

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 39567
CACHED false
EXECUTIONTIME 2
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] = '1533' 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.140.37

URL: www.misterart.com:/index.cfm:module=painting&catB=enamels&CatC=sort~1~&gr=1-shot-lettering-enamel.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:09:19'}
sessionid e0303fb3914d6e09e39953a4f25281422251
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=printmaking&catB=linoleum-wood-block-printing&gr=speedball-inking-plate.html
urltoken CFID=29773454&CFTOKEN=23490685&jsessionid=e0303fb3914d6e09e39953a4f25281422251
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:09:18'}
sessionid e030e601ddd3f2d4e0b67523e4b4d81d3e68
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=enamels&CatC=sort~1~&gr=1-shot-lettering-enamel.html
urltoken CFID=29773453&CFTOKEN=73597212&jsessionid=e030e601ddd3f2d4e0b67523e4b4d81d3e68
validationerror [empty string]


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

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

ItemIDList: 39567
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 27
barcode 705002011633
barcode_type UPC
col1 ivory
col1_sortorder 3118
col2 pint
col2_sortorder 2563
col3 can
col3_sortorder 310
color_swatch 119-0-51.jpg
cost 12.75
deal_of_the_week NO
description ivory, pint, can
group_id 107
group_uname 1-shot-lettering-enamel
id 65916
list_price 20.9
map NO
mfr_num 116-L-PT
net_weight 1.58
non_member_discount 19
non_member_price 16.92
prop65 NO
ship_rule_desc ORMD
shipping ORMD
sku 65916
sku_pix YES
supplier_id 1
ta_dealer_a_price 14
ta_dealer_c_price 14
ta_price 19.86
text
array
1 65916
2 116-L-PT
3 ivory, pint, can
timestamp 2015-03-27T14:47:47.965Z
vip_member_price 15.26

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 39567
CACHED false
EXECUTIONTIME 2
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] = '1533' 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.140.37

URL: www.misterart.com:/index.cfm:module=painting&catB=enamels&CatC=sort~1~&gr=1-shot-lettering-enamel.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:09:19'}
sessionid e0303fb3914d6e09e39953a4f25281422251
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=printmaking&catB=linoleum-wood-block-printing&gr=speedball-inking-plate.html
urltoken CFID=29773454&CFTOKEN=23490685&jsessionid=e0303fb3914d6e09e39953a4f25281422251
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:09:18'}
sessionid e030e601ddd3f2d4e0b67523e4b4d81d3e68
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=enamels&CatC=sort~1~&gr=1-shot-lettering-enamel.html
urltoken CFID=29773453&CFTOKEN=73597212&jsessionid=e030e601ddd3f2d4e0b67523e4b4d81d3e68
validationerror [empty string]


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

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

ItemIDList: 39567
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 27
barcode 705002015747
barcode_type UPC
col1 Kansas City teal
col1_sortorder 3181
col2 half pint
col2_sortorder 2491
col3 can
col3_sortorder 310
color_swatch 0-119-119.jpg
cost 9.04
deal_of_the_week NO
description Kansas City teal, half pint, can
group_id 107
group_uname 1-shot-lettering-enamel
id 63740
list_price 14.81
map NO
mfr_num 157-L 1/2 PT
net_weight 0.84
non_member_discount 19
non_member_price 11.99
prop65 NO
ship_rule_desc ORMD
shipping ORMD
sku 63740
sku_pix YES
supplier_id 1
ta_dealer_a_price 9.92
ta_dealer_c_price 9.92
ta_price 14.07
text
array
1 63740
2 157-L 1/2 PT
3 Kansas City teal, half pint, can
timestamp 2015-03-27T14:47:43.954Z
vip_member_price 10.81

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 39567
CACHED false
EXECUTIONTIME 2
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] = '1533' 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.140.37

URL: www.misterart.com:/index.cfm:module=painting&catB=enamels&CatC=sort~1~&gr=1-shot-lettering-enamel.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:09:19'}
sessionid e0303fb3914d6e09e39953a4f25281422251
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=printmaking&catB=linoleum-wood-block-printing&gr=speedball-inking-plate.html
urltoken CFID=29773454&CFTOKEN=23490685&jsessionid=e0303fb3914d6e09e39953a4f25281422251
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:09:18'}
sessionid e030e601ddd3f2d4e0b67523e4b4d81d3e68
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=enamels&CatC=sort~1~&gr=1-shot-lettering-enamel.html
urltoken CFID=29773453&CFTOKEN=73597212&jsessionid=e030e601ddd3f2d4e0b67523e4b4d81d3e68
validationerror [empty string]


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

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

ItemIDList: 39567
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 27
barcode 705002010643
barcode_type UPC
col1 kool crimson
col1_sortorder 3212
col2 half pint
col2_sortorder 2491
col3 can
col3_sortorder 310
color_swatch 119-0-0.jpg
cost 12.37
deal_of_the_week NO
description kool crimson, half pint, can
group_id 107
group_uname 1-shot-lettering-enamel
id 61254
list_price 20.27
map NO
mfr_num 106-L 1/2 PT
net_weight 0.84
non_member_discount 19
non_member_price 16.41
prop65 NO
ship_rule_desc ORMD
shipping ORMD
sku 61254
sku_pix YES
supplier_id 1
ta_dealer_a_price 13.58
ta_dealer_c_price 13.58
ta_price 19.26
text
array
1 61254
2 106-L 1/2 PT
3 kool crimson, half pint, can
timestamp 2015-03-27T14:47:40.538Z
vip_member_price 14.8

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 39567
CACHED false
EXECUTIONTIME 2
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] = '1533' 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.140.37

URL: www.misterart.com:/index.cfm:module=painting&catB=enamels&CatC=sort~1~&gr=1-shot-lettering-enamel.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:09:19'}
sessionid e0303fb3914d6e09e39953a4f25281422251
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=printmaking&catB=linoleum-wood-block-printing&gr=speedball-inking-plate.html
urltoken CFID=29773454&CFTOKEN=23490685&jsessionid=e0303fb3914d6e09e39953a4f25281422251
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:09:18'}
sessionid e030e601ddd3f2d4e0b67523e4b4d81d3e68
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=enamels&CatC=sort~1~&gr=1-shot-lettering-enamel.html
urltoken CFID=29773453&CFTOKEN=73597212&jsessionid=e030e601ddd3f2d4e0b67523e4b4d81d3e68
validationerror [empty string]


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

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

ItemIDList: 39567
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 27
barcode 705002013231
barcode_type UPC
col1 lemon yellow
col1_sortorder 3277
col2 pint
col2_sortorder 2563
col3 can
col3_sortorder 310
color_swatch 240-213-47.jpg
cost 15.76
deal_of_the_week NO
description lemon yellow, pint, can
group_id 107
group_uname 1-shot-lettering-enamel
id 77155
list_price 25.83
map NO
mfr_num 132-L PT
net_weight 1.58
non_member_discount 19
non_member_price 20.91
prop65 NO
ship_rule_desc ORMD
shipping ORMD
sku 77155
sku_pix YES
supplier_id 1
ta_dealer_a_price 17.31
ta_dealer_c_price 17.31
ta_price 24.54
text
array
1 77155
2 132-L PT
3 lemon yellow, pint, can
timestamp 2015-03-27T14:48:07.022Z
vip_member_price 18.86

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 39567
CACHED false
EXECUTIONTIME 2
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] = '1533' 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.140.37

URL: www.misterart.com:/index.cfm:module=painting&catB=enamels&CatC=sort~1~&gr=1-shot-lettering-enamel.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:09:19'}
sessionid e0303fb3914d6e09e39953a4f25281422251
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=printmaking&catB=linoleum-wood-block-printing&gr=speedball-inking-plate.html
urltoken CFID=29773454&CFTOKEN=23490685&jsessionid=e0303fb3914d6e09e39953a4f25281422251
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:09:18'}
sessionid e030e601ddd3f2d4e0b67523e4b4d81d3e68
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=enamels&CatC=sort~1~&gr=1-shot-lettering-enamel.html
urltoken CFID=29773453&CFTOKEN=73597212&jsessionid=e030e601ddd3f2d4e0b67523e4b4d81d3e68
validationerror [empty string]


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

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

ItemIDList: 39567
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 27
barcode 705002013248
barcode_type UPC
col1 lemon yellow
col1_sortorder 3277
col2 half pint
col2_sortorder 2491
col3 can
col3_sortorder 310
color_swatch 240-213-47.jpg
cost 11.21
deal_of_the_week NO
description lemon yellow, half pint, can
group_id 107
group_uname 1-shot-lettering-enamel
id 79230
list_price 18.38
map NO
mfr_num 132-L 1/2 PT
net_weight 0.84
non_member_discount 19
non_member_price 14.88
prop65 NO
ship_rule_desc ORMD
shipping ORMD
sku 79230
sku_pix YES
supplier_id 1
ta_dealer_a_price 12.31
ta_dealer_c_price 12.31
ta_price 17.46
text
array
1 79230
2 132-L 1/2 PT
3 lemon yellow, half pint, can
timestamp 2015-03-27T14:48:09.008Z
vip_member_price 13.42

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 39567
CACHED false
EXECUTIONTIME 2
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] = '1533' 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.140.37

URL: www.misterart.com:/index.cfm:module=painting&catB=enamels&CatC=sort~1~&gr=1-shot-lettering-enamel.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:09:19'}
sessionid e0303fb3914d6e09e39953a4f25281422251
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=printmaking&catB=linoleum-wood-block-printing&gr=speedball-inking-plate.html
urltoken CFID=29773454&CFTOKEN=23490685&jsessionid=e0303fb3914d6e09e39953a4f25281422251
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:09:18'}
sessionid e030e601ddd3f2d4e0b67523e4b4d81d3e68
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=enamels&CatC=sort~1~&gr=1-shot-lettering-enamel.html
urltoken CFID=29773453&CFTOKEN=73597212&jsessionid=e030e601ddd3f2d4e0b67523e4b4d81d3e68
validationerror [empty string]


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

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

ItemIDList: 39567
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 27
barcode 705002019936
barcode_type UPC
col1 lettering black
col1_sortorder 3287
col2 pint
col2_sortorder 2563
col3 can
col3_sortorder 310
color_swatch 0-0-0.jpg
cost 13.26
deal_of_the_week NO
description lettering black, pint, can
group_id 107
group_uname 1-shot-lettering-enamel
id 19617
list_price 21.74
map NO
mfr_num 199-L PT
net_weight 1.58
non_member_discount 19
non_member_price 17.6
prop65 NO
ship_rule_desc ORMD
shipping ORMD
sku 19617
sku_pix YES
supplier_id 1
ta_dealer_a_price 14.57
ta_dealer_c_price 14.57
ta_price 20.65
text
array
1 19617
2 199-L PT
3 lettering black, pint, can
timestamp 2015-03-27T14:46:39.738Z
vip_member_price 15.87

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 39567
CACHED false
EXECUTIONTIME 2
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] = '1533' 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.140.37

URL: www.misterart.com:/index.cfm:module=painting&catB=enamels&CatC=sort~1~&gr=1-shot-lettering-enamel.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:09:19'}
sessionid e0303fb3914d6e09e39953a4f25281422251
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=printmaking&catB=linoleum-wood-block-printing&gr=speedball-inking-plate.html
urltoken CFID=29773454&CFTOKEN=23490685&jsessionid=e0303fb3914d6e09e39953a4f25281422251
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:09:18'}
sessionid e030e601ddd3f2d4e0b67523e4b4d81d3e68
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=enamels&CatC=sort~1~&gr=1-shot-lettering-enamel.html
urltoken CFID=29773453&CFTOKEN=73597212&jsessionid=e030e601ddd3f2d4e0b67523e4b4d81d3e68
validationerror [empty string]


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

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

ItemIDList: 39567
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 27
barcode 705002019943
barcode_type UPC
col1 lettering black
col1_sortorder 3287
col2 half pint
col2_sortorder 2491
col3 can
col3_sortorder 310
color_swatch 0-0-0.jpg
cost 9.38
deal_of_the_week NO
description lettering black, half pint, can
group_id 107
group_uname 1-shot-lettering-enamel
id 25932
list_price 15.38
map NO
mfr_num 199-L 1/2 PT
net_weight 0.84
non_member_discount 19
non_member_price 12.45
prop65 NO
ship_rule_desc ORMD
shipping ORMD
sku 25932
sku_pix YES
supplier_id 1
ta_dealer_a_price 10.3
ta_dealer_c_price 10.3
ta_price 14.61
text
array
1 25932
2 199-L 1/2 PT
3 lettering black, half pint, can
timestamp 2015-03-27T14:46:47.827Z
vip_member_price 11.23

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 39567
CACHED false
EXECUTIONTIME 2
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] = '1533' 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.140.37

URL: www.misterart.com:/index.cfm:module=painting&catB=enamels&CatC=sort~1~&gr=1-shot-lettering-enamel.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:09:19'}
sessionid e0303fb3914d6e09e39953a4f25281422251
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=printmaking&catB=linoleum-wood-block-printing&gr=speedball-inking-plate.html
urltoken CFID=29773454&CFTOKEN=23490685&jsessionid=e0303fb3914d6e09e39953a4f25281422251
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:09:18'}
sessionid e030e601ddd3f2d4e0b67523e4b4d81d3e68
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=enamels&CatC=sort~1~&gr=1-shot-lettering-enamel.html
urltoken CFID=29773453&CFTOKEN=73597212&jsessionid=e030e601ddd3f2d4e0b67523e4b4d81d3e68
validationerror [empty string]


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

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

ItemIDList: 39567
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 27
barcode 705002019929
barcode_type UPC
col1 lettering black
col1_sortorder 3287
col2 quart
col2_sortorder 2565
col3 can
col3_sortorder 310
color_swatch 0-0-0.jpg
cost 23.67
deal_of_the_week NO
description lettering black, quart, can
group_id 107
group_uname 1-shot-lettering-enamel
id 62100
list_price 38.8
map NO
mfr_num 199-L QT
net_weight 3.12
non_member_discount 19
non_member_price 31.41
prop65 NO
ship_rule_desc ORMD
shipping ORMD
sku 62100
sku_pix YES
supplier_id 1
ta_dealer_a_price 26
ta_dealer_c_price 26
ta_price 36.86
text
array
1 62100
2 199-L QT
3 lettering black, quart, can
timestamp 2015-03-27T14:47:41.538Z
vip_member_price 28.32

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 39567
CACHED false
EXECUTIONTIME 2
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] = '1533' 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.140.37

URL: www.misterart.com:/index.cfm:module=painting&catB=enamels&CatC=sort~1~&gr=1-shot-lettering-enamel.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:09:19'}
sessionid e0303fb3914d6e09e39953a4f25281422251
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=printmaking&catB=linoleum-wood-block-printing&gr=speedball-inking-plate.html
urltoken CFID=29773454&CFTOKEN=23490685&jsessionid=e0303fb3914d6e09e39953a4f25281422251
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:09:18'}
sessionid e030e601ddd3f2d4e0b67523e4b4d81d3e68
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=enamels&CatC=sort~1~&gr=1-shot-lettering-enamel.html
urltoken CFID=29773453&CFTOKEN=73597212&jsessionid=e030e601ddd3f2d4e0b67523e4b4d81d3e68
validationerror [empty string]


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

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

ItemIDList: 39567
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 27
barcode 705002010148
barcode_type UPC
col1 lettering white
col1_sortorder 3288
col2 half pint
col2_sortorder 2491
col3 can
col3_sortorder 310
color_swatch 255-255-255.jpg
cost 9.04
deal_of_the_week NO
description lettering white, half pint, can
group_id 107
group_uname 1-shot-lettering-enamel
id 48270
list_price 14.81
map NO
mfr_num 101-L 1/2 PT
net_weight 0.84
non_member_discount 19
non_member_price 11.99
prop65 NO
ship_rule_desc ORMD
shipping ORMD
sku 48270
sku_pix YES
supplier_id 1
ta_dealer_a_price 9.92
ta_dealer_c_price 9.92
ta_price 14.07
text
array
1 48270
2 101-L 1/2 PT
3 lettering white, half pint, can
timestamp 2015-03-27T14:47:22.803Z
vip_member_price 10.81

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 39567
CACHED false
EXECUTIONTIME 2
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] = '1533' 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.140.37

URL: www.misterart.com:/index.cfm:module=painting&catB=enamels&CatC=sort~1~&gr=1-shot-lettering-enamel.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:09:19'}
sessionid e0303fb3914d6e09e39953a4f25281422251
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=printmaking&catB=linoleum-wood-block-printing&gr=speedball-inking-plate.html
urltoken CFID=29773454&CFTOKEN=23490685&jsessionid=e0303fb3914d6e09e39953a4f25281422251
validationerror [empty string]


EndSessionVariables: