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

Matte Fluid Acrylics

by Golden


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

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

ItemIDList: 29663
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 738797250543
barcode_type UPC
col1 anthraquinone blue
col1_sortorder 137
col2 4 oz.
col2_sortorder 1804
col3 [empty string]
color_swatch 0-5-36.jpg
cost 11.6
deal_of_the_week NO
description anthraquinone blue, 4 oz.
group_id 10908
group_uname golden-matte-fluid-acrylics
id 59546
list_price 24.39
map YES
mfr_num 2505-4
net_weight 0.35
non_member_discount 25
non_member_price 18.29
prop65 YES
ship_rule_desc STD
shipping STD
sku 59546
sku_pix YES
supplier_id 1
ta_dealer_a_price 12.2
ta_dealer_c_price 12.2
ta_price 19.02
text
array
1 59546
2 2505-4
3 anthraquinone blue, 4 oz.
timestamp 2015-03-27T14:47:36.146Z
vip_member_price 14.63

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 29663
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] = '2964' 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.146.134.152

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&gr=golden-matte-fluid-acrylics.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 11:59:56'}
sessionid e030b2e84d1efd6c972244a1f11782765b35
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=coloring-books&CatC=people-places&CatD=sort~1~fb~dover~fp~0-7~&gr=dover-antique-locomotives-coloring-book.html
urltoken CFID=29676445&CFTOKEN=36220934&jsessionid=e030b2e84d1efd6c972244a1f11782765b35
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 11:59:56'}
sessionid e030aad7575f0a667f3d2b26231f10323715
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&gr=golden-matte-fluid-acrylics.html
urltoken CFID=29676446&CFTOKEN=59775343&jsessionid=e030aad7575f0a667f3d2b26231f10323715
validationerror [empty string]


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

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

ItemIDList: 29663
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 738797252042
barcode_type UPC
col1 burnt sienna
col1_sortorder 875
col2 4 oz.
col2_sortorder 1804
col3 [empty string]
color_swatch 111-49-34.jpg
cost 8.56
deal_of_the_week NO
description burnt sienna, 4 oz.
group_id 10908
group_uname golden-matte-fluid-acrylics
id 59548
list_price 17.99
map YES
mfr_num 2520-4
net_weight 0.38
non_member_discount 25
non_member_price 13.49
prop65 YES
ship_rule_desc STD
shipping STD
sku 59548
sku_pix YES
supplier_id 1
ta_dealer_a_price 9
ta_dealer_c_price 9
ta_price 14.03
text
array
1 59548
2 2520-4
3 burnt sienna, 4 oz.
timestamp 2015-03-27T14:47:36.155Z
vip_member_price 10.79

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 29663
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] = '2964' 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.146.134.152

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&gr=golden-matte-fluid-acrylics.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 11:59:56'}
sessionid e030b2e84d1efd6c972244a1f11782765b35
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=coloring-books&CatC=people-places&CatD=sort~1~fb~dover~fp~0-7~&gr=dover-antique-locomotives-coloring-book.html
urltoken CFID=29676445&CFTOKEN=36220934&jsessionid=e030b2e84d1efd6c972244a1f11782765b35
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 11:59:56'}
sessionid e030aad7575f0a667f3d2b26231f10323715
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&gr=golden-matte-fluid-acrylics.html
urltoken CFID=29676446&CFTOKEN=59775343&jsessionid=e030aad7575f0a667f3d2b26231f10323715
validationerror [empty string]


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

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

ItemIDList: 29663
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 738797253049
barcode_type UPC
col1 burnt umber
col1_sortorder 886
col2 4 oz.
col2_sortorder 1804
col3 [empty string]
color_swatch 53-42-38.jpg
cost 8.56
deal_of_the_week NO
description burnt umber, 4 oz.
group_id 10908
group_uname golden-matte-fluid-acrylics
id 59559
list_price 17.99
map YES
mfr_num 2530-4
net_weight 0.38
non_member_discount 25
non_member_price 13.49
prop65 YES
ship_rule_desc STD
shipping STD
sku 59559
sku_pix YES
supplier_id 1
ta_dealer_a_price 9
ta_dealer_c_price 9
ta_price 14.03
text
array
1 59559
2 2530-4
3 burnt umber, 4 oz.
timestamp 2015-03-27T14:47:36.182Z
vip_member_price 10.79

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 29663
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] = '2964' 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.146.134.152

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&gr=golden-matte-fluid-acrylics.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 11:59:56'}
sessionid e030b2e84d1efd6c972244a1f11782765b35
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=coloring-books&CatC=people-places&CatD=sort~1~fb~dover~fp~0-7~&gr=dover-antique-locomotives-coloring-book.html
urltoken CFID=29676445&CFTOKEN=36220934&jsessionid=e030b2e84d1efd6c972244a1f11782765b35
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 11:59:56'}
sessionid e030aad7575f0a667f3d2b26231f10323715
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&gr=golden-matte-fluid-acrylics.html
urltoken CFID=29676446&CFTOKEN=59775343&jsessionid=e030aad7575f0a667f3d2b26231f10323715
validationerror [empty string]


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

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

ItemIDList: 29663
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 738797254046
barcode_type UPC
col1 carbon black
col1_sortorder 1098
col2 4 oz.
col2_sortorder 1804
col3 [empty string]
color_swatch 30-32-27.jpg
cost 8.56
deal_of_the_week NO
description carbon black, 4 oz.
group_id 10908
group_uname golden-matte-fluid-acrylics
id 59560
list_price 17.99
map YES
mfr_num 2540-4
net_weight 0.35
non_member_discount 25
non_member_price 13.49
prop65 YES
ship_rule_desc STD
shipping STD
sku 59560
sku_pix YES
supplier_id 1
ta_dealer_a_price 9
ta_dealer_c_price 9
ta_price 14.03
text
array
1 59560
2 2540-4
3 carbon black, 4 oz.
timestamp 2015-03-27T14:47:36.183Z
vip_member_price 10.79

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 29663
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] = '2964' 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.146.134.152

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&gr=golden-matte-fluid-acrylics.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 11:59:56'}
sessionid e030b2e84d1efd6c972244a1f11782765b35
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=coloring-books&CatC=people-places&CatD=sort~1~fb~dover~fp~0-7~&gr=dover-antique-locomotives-coloring-book.html
urltoken CFID=29676445&CFTOKEN=36220934&jsessionid=e030b2e84d1efd6c972244a1f11782765b35
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 11:59:56'}
sessionid e030aad7575f0a667f3d2b26231f10323715
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&gr=golden-matte-fluid-acrylics.html
urltoken CFID=29676446&CFTOKEN=59775343&jsessionid=e030aad7575f0a667f3d2b26231f10323715
validationerror [empty string]


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

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

ItemIDList: 29663
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 738797255043
barcode_type UPC
col1 cerulean blue
col1_sortorder 1154
col2 4 oz.
col2_sortorder 1804
col3 [empty string]
color_swatch 0-87-158.jpg
cost 11.6
deal_of_the_week NO
description cerulean blue, 4 oz.
group_id 10908
group_uname golden-matte-fluid-acrylics
id 59561
list_price 24.39
map YES
mfr_num 2550-4
net_weight 0.4
non_member_discount 25
non_member_price 18.29
prop65 YES
ship_rule_desc STD
shipping STD
sku 59561
sku_pix YES
supplier_id 1
ta_dealer_a_price 12.2
ta_dealer_c_price 12.2
ta_price 19.02
text
array
1 59561
2 2550-4
3 cerulean blue, 4 oz.
timestamp 2015-03-27T14:47:36.185Z
vip_member_price 14.63

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 29663
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] = '2964' 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.146.134.152

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&gr=golden-matte-fluid-acrylics.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 11:59:56'}
sessionid e030b2e84d1efd6c972244a1f11782765b35
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=coloring-books&CatC=people-places&CatD=sort~1~fb~dover~fp~0-7~&gr=dover-antique-locomotives-coloring-book.html
urltoken CFID=29676445&CFTOKEN=36220934&jsessionid=e030b2e84d1efd6c972244a1f11782765b35
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 11:59:56'}
sessionid e030aad7575f0a667f3d2b26231f10323715
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&gr=golden-matte-fluid-acrylics.html
urltoken CFID=29676446&CFTOKEN=59775343&jsessionid=e030aad7575f0a667f3d2b26231f10323715
validationerror [empty string]


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

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

ItemIDList: 29663
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 738797256040
barcode_type UPC
col1 chromium oxide green
col1_sortorder 1263
col2 4 oz.
col2_sortorder 1804
col3 [empty string]
color_swatch 49-111-34.jpg
cost 9.52
deal_of_the_week NO
description chromium oxide green, 4 oz.
group_id 10908
group_uname golden-matte-fluid-acrylics
id 59563
list_price 19.99
map YES
mfr_num 2560-4
net_weight 0.42
non_member_discount 25
non_member_price 14.99
prop65 YES
ship_rule_desc STD
shipping STD
sku 59563
sku_pix YES
supplier_id 1
ta_dealer_a_price 10
ta_dealer_c_price 10
ta_price 15.59
text
array
1 59563
2 2560-4
3 chromium oxide green, 4 oz.
timestamp 2015-03-27T14:47:36.187Z
vip_member_price 11.99

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 29663
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] = '2964' 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.146.134.152

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&gr=golden-matte-fluid-acrylics.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 11:59:56'}
sessionid e030b2e84d1efd6c972244a1f11782765b35
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=coloring-books&CatC=people-places&CatD=sort~1~fb~dover~fp~0-7~&gr=dover-antique-locomotives-coloring-book.html
urltoken CFID=29676445&CFTOKEN=36220934&jsessionid=e030b2e84d1efd6c972244a1f11782765b35
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 11:59:56'}
sessionid e030aad7575f0a667f3d2b26231f10323715
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&gr=golden-matte-fluid-acrylics.html
urltoken CFID=29676446&CFTOKEN=59775343&jsessionid=e030aad7575f0a667f3d2b26231f10323715
validationerror [empty string]


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

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

ItemIDList: 29663
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 738797264045
barcode_type UPC
col1 cobalt blue
col1_sortorder 1352
col2 4 oz.
col2_sortorder 1804
col3 [empty string]
color_swatch 1-31-157.jpg
cost 12.7
deal_of_the_week NO
description cobalt blue, 4 oz.
group_id 10908
group_uname golden-matte-fluid-acrylics
id 59564
list_price 26.69
map YES
mfr_num 2640-4
net_weight 0.38
non_member_discount 25
non_member_price 20.02
prop65 YES
ship_rule_desc STD
shipping STD
sku 59564
sku_pix YES
supplier_id 1
ta_dealer_a_price 13.35
ta_dealer_c_price 13.35
ta_price 20.82
text
array
1 59564
2 2640-4
3 cobalt blue, 4 oz.
timestamp 2015-03-27T14:47:36.19Z
vip_member_price 16.01

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 29663
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] = '2964' 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.146.134.152

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&gr=golden-matte-fluid-acrylics.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 11:59:56'}
sessionid e030b2e84d1efd6c972244a1f11782765b35
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=coloring-books&CatC=people-places&CatD=sort~1~fb~dover~fp~0-7~&gr=dover-antique-locomotives-coloring-book.html
urltoken CFID=29676445&CFTOKEN=36220934&jsessionid=e030b2e84d1efd6c972244a1f11782765b35
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 11:59:56'}
sessionid e030aad7575f0a667f3d2b26231f10323715
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&gr=golden-matte-fluid-acrylics.html
urltoken CFID=29676446&CFTOKEN=59775343&jsessionid=e030aad7575f0a667f3d2b26231f10323715
validationerror [empty string]


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

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

ItemIDList: 29663
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 738797264748
barcode_type UPC
col1 diarylide yellow
col1_sortorder 1898
col2 4 oz.
col2_sortorder 1804
col3 [empty string]
color_swatch 255-163-1.jpg
cost 10.85
deal_of_the_week NO
description diarylide yellow, 4 oz.
group_id 10908
group_uname golden-matte-fluid-acrylics
id 59567
list_price 22.79
map YES
mfr_num 2647-4
net_weight 0.36
non_member_discount 25
non_member_price 17.09
prop65 YES
ship_rule_desc STD
shipping STD
sku 59567
sku_pix YES
supplier_id 1
ta_dealer_a_price 11.4
ta_dealer_c_price 11.4
ta_price 17.78
text
array
1 59567
2 2647-4
3 diarylide yellow, 4 oz.
timestamp 2015-03-27T14:47:36.201Z
vip_member_price 13.67

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 29663
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] = '2964' 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.146.134.152

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&gr=golden-matte-fluid-acrylics.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 11:59:56'}
sessionid e030b2e84d1efd6c972244a1f11782765b35
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=coloring-books&CatC=people-places&CatD=sort~1~fb~dover~fp~0-7~&gr=dover-antique-locomotives-coloring-book.html
urltoken CFID=29676445&CFTOKEN=36220934&jsessionid=e030b2e84d1efd6c972244a1f11782765b35
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 11:59:56'}
sessionid e030aad7575f0a667f3d2b26231f10323715
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&gr=golden-matte-fluid-acrylics.html
urltoken CFID=29676446&CFTOKEN=59775343&jsessionid=e030aad7575f0a667f3d2b26231f10323715
validationerror [empty string]


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

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

ItemIDList: 29663
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 738797265042
barcode_type UPC
col1 dioxazine purple
col1_sortorder 1907
col2 4 oz.
col2_sortorder 1804
col3 [empty string]
color_swatch 48-31-76.jpg
cost 10.85
deal_of_the_week NO
description dioxazine purple, 4 oz.
group_id 10908
group_uname golden-matte-fluid-acrylics
id 59568
list_price 22.79
map YES
mfr_num 2650-4
net_weight 0.37
non_member_discount 25
non_member_price 17.09
prop65 YES
ship_rule_desc STD
shipping STD
sku 59568
sku_pix YES
supplier_id 1
ta_dealer_a_price 11.4
ta_dealer_c_price 11.4
ta_price 17.78
text
array
1 59568
2 2650-4
3 dioxazine purple, 4 oz.
timestamp 2015-03-27T14:47:36.203Z
vip_member_price 13.67

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 29663
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] = '2964' 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.146.134.152

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&gr=golden-matte-fluid-acrylics.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 11:59:56'}
sessionid e030b2e84d1efd6c972244a1f11782765b35
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=coloring-books&CatC=people-places&CatD=sort~1~fb~dover~fp~0-7~&gr=dover-antique-locomotives-coloring-book.html
urltoken CFID=29676445&CFTOKEN=36220934&jsessionid=e030b2e84d1efd6c972244a1f11782765b35
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 11:59:56'}
sessionid e030aad7575f0a667f3d2b26231f10323715
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&gr=golden-matte-fluid-acrylics.html
urltoken CFID=29676446&CFTOKEN=59775343&jsessionid=e030aad7575f0a667f3d2b26231f10323715
validationerror [empty string]


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

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

ItemIDList: 29663
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 738797267046
barcode_type UPC
col1 green gold
col1_sortorder 2645
col2 4 oz.
col2_sortorder 1804
col3 [empty string]
color_swatch 85-115-45.jpg
cost 11.6
deal_of_the_week NO
description green gold, 4 oz.
group_id 10908
group_uname golden-matte-fluid-acrylics
id 59570
list_price 24.39
map YES
mfr_num 2670-4
net_weight 0.36
non_member_discount 25
non_member_price 18.29
prop65 YES
ship_rule_desc STD
shipping STD
sku 59570
sku_pix YES
supplier_id 1
ta_dealer_a_price 12.2
ta_dealer_c_price 12.2
ta_price 19.02
text
array
1 59570
2 2670-4
3 green gold, 4 oz.
timestamp 2015-03-27T14:47:36.205Z
vip_member_price 14.63

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 29663
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] = '2964' 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.146.134.152

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&gr=golden-matte-fluid-acrylics.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 11:59:56'}
sessionid e030b2e84d1efd6c972244a1f11782765b35
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=coloring-books&CatC=people-places&CatD=sort~1~fb~dover~fp~0-7~&gr=dover-antique-locomotives-coloring-book.html
urltoken CFID=29676445&CFTOKEN=36220934&jsessionid=e030b2e84d1efd6c972244a1f11782765b35
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 11:59:56'}
sessionid e030aad7575f0a667f3d2b26231f10323715
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&gr=golden-matte-fluid-acrylics.html
urltoken CFID=29676446&CFTOKEN=59775343&jsessionid=e030aad7575f0a667f3d2b26231f10323715
validationerror [empty string]


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

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

ItemIDList: 29663
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 738797269040
barcode_type UPC
col1 hansa yellow medium
col1_sortorder 2745
col2 4 oz.
col2_sortorder 1804
col3 [empty string]
color_swatch 255-205-0.jpg
cost 9.52
deal_of_the_week NO
description hansa yellow medium, 4 oz.
group_id 10908
group_uname golden-matte-fluid-acrylics
id 59571
list_price 19.99
map YES
mfr_num 2690-4
net_weight 0.36
non_member_discount 25
non_member_price 14.99
prop65 YES
ship_rule_desc STD
shipping STD
sku 59571
sku_pix YES
supplier_id 1
ta_dealer_a_price 10
ta_dealer_c_price 10
ta_price 15.59
text
array
1 59571
2 2690-4
3 hansa yellow medium, 4 oz.
timestamp 2015-03-27T14:47:36.207Z
vip_member_price 11.99

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 29663
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] = '2964' 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.146.134.152

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&gr=golden-matte-fluid-acrylics.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 11:59:56'}
sessionid e030b2e84d1efd6c972244a1f11782765b35
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=coloring-books&CatC=people-places&CatD=sort~1~fb~dover~fp~0-7~&gr=dover-antique-locomotives-coloring-book.html
urltoken CFID=29676445&CFTOKEN=36220934&jsessionid=e030b2e84d1efd6c972244a1f11782765b35
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 11:59:56'}
sessionid e030aad7575f0a667f3d2b26231f10323715
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&gr=golden-matte-fluid-acrylics.html
urltoken CFID=29676446&CFTOKEN=59775343&jsessionid=e030aad7575f0a667f3d2b26231f10323715
validationerror [empty string]


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

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

ItemIDList: 29663
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 738797269149
barcode_type UPC
col1 hansa yellow opaque
col1_sortorder 2746
col2 4 oz.
col2_sortorder 1804
col3 [empty string]
color_swatch 228-218-0.jpg
cost 9.89
deal_of_the_week NO
description hansa yellow opaque, 4 oz.
group_id 10908
group_uname golden-matte-fluid-acrylics
id 59572
list_price 20.79
map YES
mfr_num 2691-4
net_weight 0.36
non_member_discount 25
non_member_price 15.59
prop65 YES
ship_rule_desc STD
shipping STD
sku 59572
sku_pix YES
supplier_id 1
ta_dealer_a_price 10.4
ta_dealer_c_price 10.4
ta_price 16.22
text
array
1 59572
2 2691-4
3 hansa yellow opaque, 4 oz.
timestamp 2015-03-27T14:47:36.209Z
vip_member_price 12.47

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 29663
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] = '2964' 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.146.134.152

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&gr=golden-matte-fluid-acrylics.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 11:59:56'}
sessionid e030b2e84d1efd6c972244a1f11782765b35
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=coloring-books&CatC=people-places&CatD=sort~1~fb~dover~fp~0-7~&gr=dover-antique-locomotives-coloring-book.html
urltoken CFID=29676445&CFTOKEN=36220934&jsessionid=e030b2e84d1efd6c972244a1f11782765b35
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 11:59:56'}
sessionid e030aad7575f0a667f3d2b26231f10323715
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&gr=golden-matte-fluid-acrylics.html
urltoken CFID=29676446&CFTOKEN=59775343&jsessionid=e030aad7575f0a667f3d2b26231f10323715
validationerror [empty string]


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

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

ItemIDList: 29663
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 738797269545
barcode_type UPC
col1 Jenkins green
col1_sortorder 3154
col2 4 oz.
col2_sortorder 1804
col3 [empty string]
color_swatch 26-56-48.jpg
cost 11.6
deal_of_the_week NO
description Jenkins green, 4 oz.
group_id 10908
group_uname golden-matte-fluid-acrylics
id 59573
list_price 24.39
map YES
mfr_num 2695-4
net_weight 0.36
non_member_discount 25
non_member_price 18.29
prop65 YES
ship_rule_desc STD
shipping STD
sku 59573
sku_pix YES
supplier_id 1
ta_dealer_a_price 12.2
ta_dealer_c_price 12.2
ta_price 19.02
text
array
1 59573
2 2695-4
3 Jenkins green, 4 oz.
timestamp 2015-03-27T14:47:36.212Z
vip_member_price 14.63

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 29663
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] = '2964' 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.146.134.152

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&gr=golden-matte-fluid-acrylics.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 11:59:56'}
sessionid e030b2e84d1efd6c972244a1f11782765b35
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=coloring-books&CatC=people-places&CatD=sort~1~fb~dover~fp~0-7~&gr=dover-antique-locomotives-coloring-book.html
urltoken CFID=29676445&CFTOKEN=36220934&jsessionid=e030b2e84d1efd6c972244a1f11782765b35
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 11:59:56'}
sessionid e030aad7575f0a667f3d2b26231f10323715
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&gr=golden-matte-fluid-acrylics.html
urltoken CFID=29676446&CFTOKEN=59775343&jsessionid=e030aad7575f0a667f3d2b26231f10323715
validationerror [empty string]


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

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

ItemIDList: 29663
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 738797272040
barcode_type UPC
col1 naphthol red medium
col1_sortorder 3898
col2 4 oz.
col2_sortorder 1804
col3 [empty string]
color_swatch 157-46-53.jpg
cost 10.32
deal_of_the_week NO
description naphthol red medium, 4 oz.
group_id 10908
group_uname golden-matte-fluid-acrylics
id 59574
list_price 21.69
map YES
mfr_num 2720-4
net_weight 0.37
non_member_discount 25
non_member_price 16.27
prop65 YES
ship_rule_desc STD
shipping STD
sku 59574
sku_pix YES
supplier_id 1
ta_dealer_a_price 10.85
ta_dealer_c_price 10.85
ta_price 16.92
text
array
1 59574
2 2720-4
3 naphthol red medium, 4 oz.
timestamp 2015-03-27T14:47:36.217Z
vip_member_price 13.01

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 29663
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] = '2964' 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.146.134.152

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&gr=golden-matte-fluid-acrylics.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 11:59:56'}
sessionid e030b2e84d1efd6c972244a1f11782765b35
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=coloring-books&CatC=people-places&CatD=sort~1~fb~dover~fp~0-7~&gr=dover-antique-locomotives-coloring-book.html
urltoken CFID=29676445&CFTOKEN=36220934&jsessionid=e030b2e84d1efd6c972244a1f11782765b35
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 11:59:56'}
sessionid e030aad7575f0a667f3d2b26231f10323715
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&gr=golden-matte-fluid-acrylics.html
urltoken CFID=29676446&CFTOKEN=59775343&jsessionid=e030aad7575f0a667f3d2b26231f10323715
validationerror [empty string]


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

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

ItemIDList: 29663
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 738797274044
barcode_type UPC
col1 payne's gray
col1_sortorder 4418
col2 4 oz.
col2_sortorder 1804
col3 [empty string]
color_swatch 2-36-58.jpg
cost 9.04
deal_of_the_week NO
description payne's gray, 4 oz.
group_id 10908
group_uname golden-matte-fluid-acrylics
id 59577
list_price 18.99
map YES
mfr_num 2740-4
net_weight 0.38
non_member_discount 25
non_member_price 14.24
prop65 YES
ship_rule_desc STD
shipping STD
sku 59577
sku_pix YES
supplier_id 1
ta_dealer_a_price 9.5
ta_dealer_c_price 9.5
ta_price 14.81
text
array
1 59577
2 2740-4
3 payne's gray, 4 oz.
timestamp 2015-03-27T14:47:36.225Z
vip_member_price 11.39

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 29663
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] = '2964' 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.146.134.152

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&gr=golden-matte-fluid-acrylics.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 11:59:56'}
sessionid e030b2e84d1efd6c972244a1f11782765b35
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=coloring-books&CatC=people-places&CatD=sort~1~fb~dover~fp~0-7~&gr=dover-antique-locomotives-coloring-book.html
urltoken CFID=29676445&CFTOKEN=36220934&jsessionid=e030b2e84d1efd6c972244a1f11782765b35
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 11:59:56'}
sessionid e030aad7575f0a667f3d2b26231f10323715
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&gr=golden-matte-fluid-acrylics.html
urltoken CFID=29676446&CFTOKEN=59775343&jsessionid=e030aad7575f0a667f3d2b26231f10323715
validationerror [empty string]


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

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

ItemIDList: 29663
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 738797275041
barcode_type UPC
col1 permanent green light
col1_sortorder 4562
col2 4 oz.
col2_sortorder 1804
col3 [empty string]
color_swatch 0-126-57.jpg
cost 9.89
deal_of_the_week NO
description permanent green light, 4 oz.
group_id 10908
group_uname golden-matte-fluid-acrylics
id 59579
list_price 20.79
map YES
mfr_num 2750-4
net_weight 0.36
non_member_discount 25
non_member_price 15.59
prop65 YES
ship_rule_desc STD
shipping STD
sku 59579
sku_pix YES
supplier_id 1
ta_dealer_a_price 10.4
ta_dealer_c_price 10.4
ta_price 16.22
text
array
1 59579
2 2750-4
3 permanent green light, 4 oz.
timestamp 2015-03-27T14:47:36.227Z
vip_member_price 12.47

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 29663
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] = '2964' 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.146.134.152

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&gr=golden-matte-fluid-acrylics.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 11:59:56'}
sessionid e030b2e84d1efd6c972244a1f11782765b35
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=coloring-books&CatC=people-places&CatD=sort~1~fb~dover~fp~0-7~&gr=dover-antique-locomotives-coloring-book.html
urltoken CFID=29676445&CFTOKEN=36220934&jsessionid=e030b2e84d1efd6c972244a1f11782765b35
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 11:59:56'}
sessionid e030aad7575f0a667f3d2b26231f10323715
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&gr=golden-matte-fluid-acrylics.html
urltoken CFID=29676446&CFTOKEN=59775343&jsessionid=e030aad7575f0a667f3d2b26231f10323715
validationerror [empty string]


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

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

ItemIDList: 29663
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 738797275546
barcode_type UPC
col1 phthalo blue/green shade
col1_sortorder 4668
col2 4 oz.
col2_sortorder 1804
col3 [empty string]
color_swatch 44-41-98.jpg
cost 9.89
deal_of_the_week NO
description phthalo blue/green shade, 4 oz.
group_id 10908
group_uname golden-matte-fluid-acrylics
id 59582
list_price 20.79
map YES
mfr_num 2755-4
net_weight 0.35
non_member_discount 25
non_member_price 15.59
prop65 YES
ship_rule_desc STD
shipping STD
sku 59582
sku_pix YES
supplier_id 1
ta_dealer_a_price 10.4
ta_dealer_c_price 10.4
ta_price 16.22
text
array
1 59582
2 2755-4
3 phthalo blue/green shade, 4 oz.
timestamp 2015-03-27T14:47:36.234Z
vip_member_price 12.47

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 29663
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] = '2964' 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.146.134.152

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&gr=golden-matte-fluid-acrylics.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 11:59:56'}
sessionid e030b2e84d1efd6c972244a1f11782765b35
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=coloring-books&CatC=people-places&CatD=sort~1~fb~dover~fp~0-7~&gr=dover-antique-locomotives-coloring-book.html
urltoken CFID=29676445&CFTOKEN=36220934&jsessionid=e030b2e84d1efd6c972244a1f11782765b35
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 11:59:56'}
sessionid e030aad7575f0a667f3d2b26231f10323715
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&gr=golden-matte-fluid-acrylics.html
urltoken CFID=29676446&CFTOKEN=59775343&jsessionid=e030aad7575f0a667f3d2b26231f10323715
validationerror [empty string]


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

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

ItemIDList: 29663
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 738797277045
barcode_type UPC
col1 phthalo green/blue shade
col1_sortorder 4689
col2 4 oz.
col2_sortorder 1804
col3 [empty string]
color_swatch 5-71-61.jpg
cost 9.89
deal_of_the_week NO
description phthalo green/blue shade, 4 oz.
group_id 10908
group_uname golden-matte-fluid-acrylics
id 59583
list_price 20.79
map YES
mfr_num 2770-4
net_weight 0.35
non_member_discount 25
non_member_price 15.59
prop65 YES
ship_rule_desc STD
shipping STD
sku 59583
sku_pix YES
supplier_id 1
ta_dealer_a_price 10.4
ta_dealer_c_price 10.4
ta_price 16.22
text
array
1 59583
2 2770-4
3 phthalo green/blue shade, 4 oz.
timestamp 2015-03-27T14:47:36.238Z
vip_member_price 12.47

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 29663
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] = '2964' 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.146.134.152

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&gr=golden-matte-fluid-acrylics.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 11:59:56'}
sessionid e030b2e84d1efd6c972244a1f11782765b35
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=coloring-books&CatC=people-places&CatD=sort~1~fb~dover~fp~0-7~&gr=dover-antique-locomotives-coloring-book.html
urltoken CFID=29676445&CFTOKEN=36220934&jsessionid=e030b2e84d1efd6c972244a1f11782765b35
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 11:59:56'}
sessionid e030aad7575f0a667f3d2b26231f10323715
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&gr=golden-matte-fluid-acrylics.html
urltoken CFID=29676446&CFTOKEN=59775343&jsessionid=e030aad7575f0a667f3d2b26231f10323715
validationerror [empty string]


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

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

ItemIDList: 29663
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 738797277748
barcode_type UPC
col1 pyrrole red
col1_sortorder 4970
col2 4 oz.
col2_sortorder 1804
col3 [empty string]
color_swatch 213-2-56.jpg
cost 12.7
deal_of_the_week NO
description pyrrole red, 4 oz.
group_id 10908
group_uname golden-matte-fluid-acrylics
id 59584
list_price 26.69
map YES
mfr_num 2777-4
net_weight 0.36
non_member_discount 25
non_member_price 20.02
prop65 YES
ship_rule_desc STD
shipping STD
sku 59584
sku_pix YES
supplier_id 1
ta_dealer_a_price 13.35
ta_dealer_c_price 13.35
ta_price 20.82
text
array
1 59584
2 2777-4
3 pyrrole red, 4 oz.
timestamp 2015-03-27T14:47:36.244Z
vip_member_price 16.01

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 29663
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] = '2964' 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.146.134.152

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&gr=golden-matte-fluid-acrylics.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 11:59:56'}
sessionid e030b2e84d1efd6c972244a1f11782765b35
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=coloring-books&CatC=people-places&CatD=sort~1~fb~dover~fp~0-7~&gr=dover-antique-locomotives-coloring-book.html
urltoken CFID=29676445&CFTOKEN=36220934&jsessionid=e030b2e84d1efd6c972244a1f11782765b35
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 11:59:56'}
sessionid e030aad7575f0a667f3d2b26231f10323715
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&gr=golden-matte-fluid-acrylics.html
urltoken CFID=29676446&CFTOKEN=59775343&jsessionid=e030aad7575f0a667f3d2b26231f10323715
validationerror [empty string]


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

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

ItemIDList: 29663
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 738797279049
barcode_type UPC
col1 quinacridone crimson
col1_sortorder 4990
col2 4 oz.
col2_sortorder 1804
col3 [empty string]
color_swatch 122-49-68.jpg
cost 11.6
deal_of_the_week NO
description quinacridone crimson, 4 oz.
group_id 10908
group_uname golden-matte-fluid-acrylics
id 59586
list_price 24.39
map YES
mfr_num 2790-4
net_weight 0.36
non_member_discount 25
non_member_price 18.29
prop65 YES
ship_rule_desc STD
shipping STD
sku 59586
sku_pix YES
supplier_id 1
ta_dealer_a_price 12.2
ta_dealer_c_price 12.2
ta_price 19.02
text
array
1 59586
2 2790-4
3 quinacridone crimson, 4 oz.
timestamp 2015-03-27T14:47:36.251Z
vip_member_price 14.63

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 29663
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] = '2964' 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.146.134.152

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&gr=golden-matte-fluid-acrylics.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 11:59:56'}
sessionid e030b2e84d1efd6c972244a1f11782765b35
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=coloring-books&CatC=people-places&CatD=sort~1~fb~dover~fp~0-7~&gr=dover-antique-locomotives-coloring-book.html
urltoken CFID=29676445&CFTOKEN=36220934&jsessionid=e030b2e84d1efd6c972244a1f11782765b35
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 11:59:56'}
sessionid e030aad7575f0a667f3d2b26231f10323715
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&gr=golden-matte-fluid-acrylics.html
urltoken CFID=29676446&CFTOKEN=59775343&jsessionid=e030aad7575f0a667f3d2b26231f10323715
validationerror [empty string]


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

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

ItemIDList: 29663
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 738797280540
barcode_type UPC
col1 quinacridone magenta
col1_sortorder 4996
col2 4 oz.
col2_sortorder 1804
col3 [empty string]
color_swatch 131-39-78.jpg
cost 11.6
deal_of_the_week NO
description quinacridone magenta, 4 oz.
group_id 10908
group_uname golden-matte-fluid-acrylics
id 59587
list_price 24.39
map YES
mfr_num 2805-4
net_weight 0.34
non_member_discount 25
non_member_price 18.29
prop65 YES
ship_rule_desc STD
shipping STD
sku 59587
sku_pix YES
supplier_id 1
ta_dealer_a_price 12.2
ta_dealer_c_price 12.2
ta_price 19.03
text
array
1 59587
2 2805-4
3 quinacridone magenta, 4 oz.
timestamp 2015-03-27T14:47:36.253Z
vip_member_price 14.63

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 29663
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] = '2964' 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.146.134.152

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&gr=golden-matte-fluid-acrylics.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 11:59:56'}
sessionid e030b2e84d1efd6c972244a1f11782765b35
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=coloring-books&CatC=people-places&CatD=sort~1~fb~dover~fp~0-7~&gr=dover-antique-locomotives-coloring-book.html
urltoken CFID=29676445&CFTOKEN=36220934&jsessionid=e030b2e84d1efd6c972244a1f11782765b35
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 11:59:56'}
sessionid e030aad7575f0a667f3d2b26231f10323715
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&gr=golden-matte-fluid-acrylics.html
urltoken CFID=29676446&CFTOKEN=59775343&jsessionid=e030aad7575f0a667f3d2b26231f10323715
validationerror [empty string]


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

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

ItemIDList: 29663
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 738797284043
barcode_type UPC
col1 raw sienna
col1_sortorder 5052
col2 4 oz.
col2_sortorder 1804
col3 [empty string]
color_swatch 158-96-10.jpg
cost 8.56
deal_of_the_week NO
description raw sienna, 4 oz.
group_id 10908
group_uname golden-matte-fluid-acrylics
id 59589
list_price 17.99
map YES
mfr_num 2840-4
net_weight 0.37
non_member_discount 25
non_member_price 13.49
prop65 YES
ship_rule_desc STD
shipping STD
sku 59589
sku_pix YES
supplier_id 1
ta_dealer_a_price 9
ta_dealer_c_price 9
ta_price 14.03
text
array
1 59589
2 2840-4
3 raw sienna, 4 oz.
timestamp 2015-03-27T14:47:36.256Z
vip_member_price 10.79

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 29663
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] = '2964' 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.146.134.152

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&gr=golden-matte-fluid-acrylics.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 11:59:56'}
sessionid e030b2e84d1efd6c972244a1f11782765b35
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=coloring-books&CatC=people-places&CatD=sort~1~fb~dover~fp~0-7~&gr=dover-antique-locomotives-coloring-book.html
urltoken CFID=29676445&CFTOKEN=36220934&jsessionid=e030b2e84d1efd6c972244a1f11782765b35
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 11:59:56'}
sessionid e030aad7575f0a667f3d2b26231f10323715
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&gr=golden-matte-fluid-acrylics.html
urltoken CFID=29676446&CFTOKEN=59775343&jsessionid=e030aad7575f0a667f3d2b26231f10323715
validationerror [empty string]


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

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

ItemIDList: 29663
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 738797285040
barcode_type UPC
col1 raw umber
col1_sortorder 5060
col2 4 oz.
col2_sortorder 1804
col3 [empty string]
color_swatch 60-48-32.jpg
cost 8.56
deal_of_the_week NO
description raw umber, 4 oz.
group_id 10908
group_uname golden-matte-fluid-acrylics
id 59591
list_price 17.99
map YES
mfr_num 2850-4
net_weight 0.38
non_member_discount 25
non_member_price 13.49
prop65 YES
ship_rule_desc STD
shipping STD
sku 59591
sku_pix YES
supplier_id 1
ta_dealer_a_price 9
ta_dealer_c_price 9
ta_price 14.03
text
array
1 59591
2 2850-4
3 raw umber, 4 oz.
timestamp 2015-03-27T14:47:36.261Z
vip_member_price 10.79

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 29663
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] = '2964' 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.146.134.152

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&gr=golden-matte-fluid-acrylics.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 11:59:56'}
sessionid e030b2e84d1efd6c972244a1f11782765b35
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=coloring-books&CatC=people-places&CatD=sort~1~fb~dover~fp~0-7~&gr=dover-antique-locomotives-coloring-book.html
urltoken CFID=29676445&CFTOKEN=36220934&jsessionid=e030b2e84d1efd6c972244a1f11782765b35
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 11:59:56'}
sessionid e030aad7575f0a667f3d2b26231f10323715
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&gr=golden-matte-fluid-acrylics.html
urltoken CFID=29676446&CFTOKEN=59775343&jsessionid=e030aad7575f0a667f3d2b26231f10323715
validationerror [empty string]


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

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

ItemIDList: 29663
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 738797286047
barcode_type UPC
col1 red oxide
col1_sortorder 5127
col2 4 oz.
col2_sortorder 1804
col3 [empty string]
color_swatch 152-51-21.jpg
cost 8.56
deal_of_the_week NO
description red oxide, 4 oz.
group_id 10908
group_uname golden-matte-fluid-acrylics
id 59593
list_price 17.99
map YES
mfr_num 2860-4
net_weight 0.36
non_member_discount 25
non_member_price 13.49
prop65 YES
ship_rule_desc STD
shipping STD
sku 59593
sku_pix YES
supplier_id 1
ta_dealer_a_price 9
ta_dealer_c_price 9
ta_price 14.03
text
array
1 59593
2 2860-4
3 red oxide, 4 oz.
timestamp 2015-03-27T14:47:36.284Z
vip_member_price 10.79

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 29663
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] = '2964' 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.146.134.152

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&gr=golden-matte-fluid-acrylics.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 11:59:56'}
sessionid e030b2e84d1efd6c972244a1f11782765b35
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=coloring-books&CatC=people-places&CatD=sort~1~fb~dover~fp~0-7~&gr=dover-antique-locomotives-coloring-book.html
urltoken CFID=29676445&CFTOKEN=36220934&jsessionid=e030b2e84d1efd6c972244a1f11782765b35
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 11:59:56'}
sessionid e030aad7575f0a667f3d2b26231f10323715
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&gr=golden-matte-fluid-acrylics.html
urltoken CFID=29676446&CFTOKEN=59775343&jsessionid=e030aad7575f0a667f3d2b26231f10323715
validationerror [empty string]


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

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

ItemIDList: 29663
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 738797287044
barcode_type UPC
col1 titanium buff
col1_sortorder 6020
col2 4 oz.
col2_sortorder 1804
col3 [empty string]
color_swatch 224-212-185.jpg
cost 8.56
deal_of_the_week NO
description titanium buff, 4 oz.
group_id 10908
group_uname golden-matte-fluid-acrylics
id 59594
list_price 17.99
map YES
mfr_num 2870-4
net_weight 0.4
non_member_discount 25
non_member_price 13.49
prop65 YES
ship_rule_desc STD
shipping STD
sku 59594
sku_pix YES
supplier_id 1
ta_dealer_a_price 9
ta_dealer_c_price 9
ta_price 14.03
text
array
1 59594
2 2870-4
3 titanium buff, 4 oz.
timestamp 2015-03-27T14:47:36.287Z
vip_member_price 10.79

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 29663
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] = '2964' 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.146.134.152

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&gr=golden-matte-fluid-acrylics.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 11:59:56'}
sessionid e030b2e84d1efd6c972244a1f11782765b35
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=coloring-books&CatC=people-places&CatD=sort~1~fb~dover~fp~0-7~&gr=dover-antique-locomotives-coloring-book.html
urltoken CFID=29676445&CFTOKEN=36220934&jsessionid=e030b2e84d1efd6c972244a1f11782765b35
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 11:59:56'}
sessionid e030aad7575f0a667f3d2b26231f10323715
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&gr=golden-matte-fluid-acrylics.html
urltoken CFID=29676446&CFTOKEN=59775343&jsessionid=e030aad7575f0a667f3d2b26231f10323715
validationerror [empty string]


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

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

ItemIDList: 29663
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 738797288041
barcode_type UPC
col1 titanium white
col1_sortorder 6023
col2 4 oz.
col2_sortorder 1804
col3 [empty string]
color_swatch 254-254-254.jpg
cost 8.56
deal_of_the_week NO
description titanium white, 4 oz.
group_id 10908
group_uname golden-matte-fluid-acrylics
id 59595
list_price 17.99
map YES
mfr_num 2880-4
net_weight 0.43
non_member_discount 25
non_member_price 13.49
prop65 YES
ship_rule_desc STD
shipping STD
sku 59595
sku_pix YES
supplier_id 1
ta_dealer_a_price 9
ta_dealer_c_price 9
ta_price 14.03
text
array
1 59595
2 2880-4
3 titanium white, 4 oz.
timestamp 2015-03-27T14:47:36.289Z
vip_member_price 10.79

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 29663
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] = '2964' 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.146.134.152

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&gr=golden-matte-fluid-acrylics.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 11:59:56'}
sessionid e030b2e84d1efd6c972244a1f11782765b35
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=coloring-books&CatC=people-places&CatD=sort~1~fb~dover~fp~0-7~&gr=dover-antique-locomotives-coloring-book.html
urltoken CFID=29676445&CFTOKEN=36220934&jsessionid=e030b2e84d1efd6c972244a1f11782765b35
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 11:59:56'}
sessionid e030aad7575f0a667f3d2b26231f10323715
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&gr=golden-matte-fluid-acrylics.html
urltoken CFID=29676446&CFTOKEN=59775343&jsessionid=e030aad7575f0a667f3d2b26231f10323715
validationerror [empty string]


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

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

ItemIDList: 29663
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 738797289048
barcode_type UPC
col1 turquoise phthalo
col1_sortorder 6217
col2 4 oz.
col2_sortorder 1804
col3 [empty string]
color_swatch 3-60-81.jpg
cost 9.89
deal_of_the_week NO
description turquoise phthalo, 4 oz.
group_id 10908
group_uname golden-matte-fluid-acrylics
id 59597
list_price 20.79
map YES
mfr_num 2890-4
net_weight 0.34
non_member_discount 25
non_member_price 15.59
prop65 YES
ship_rule_desc STD
shipping STD
sku 59597
sku_pix YES
supplier_id 1
ta_dealer_a_price 10.4
ta_dealer_c_price 10.4
ta_price 16.22
text
array
1 59597
2 2890-4
3 turquoise phthalo, 4 oz.
timestamp 2015-03-27T14:47:36.294Z
vip_member_price 12.47

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 29663
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] = '2964' 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.146.134.152

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&gr=golden-matte-fluid-acrylics.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 11:59:56'}
sessionid e030b2e84d1efd6c972244a1f11782765b35
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=coloring-books&CatC=people-places&CatD=sort~1~fb~dover~fp~0-7~&gr=dover-antique-locomotives-coloring-book.html
urltoken CFID=29676445&CFTOKEN=36220934&jsessionid=e030b2e84d1efd6c972244a1f11782765b35
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 11:59:56'}
sessionid e030aad7575f0a667f3d2b26231f10323715
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&gr=golden-matte-fluid-acrylics.html
urltoken CFID=29676446&CFTOKEN=59775343&jsessionid=e030aad7575f0a667f3d2b26231f10323715
validationerror [empty string]


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

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

ItemIDList: 29663
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 738797290044
barcode_type UPC
col1 ultramarine blue
col1_sortorder 6249
col2 4 oz.
col2_sortorder 1804
col3 [empty string]
color_swatch 52-40-124.jpg
cost 9.04
deal_of_the_week NO
description ultramarine blue, 4 oz.
group_id 10908
group_uname golden-matte-fluid-acrylics
id 59598
list_price 18.99
map YES
mfr_num 2900-4
net_weight 0.4
non_member_discount 25
non_member_price 14.24
prop65 YES
ship_rule_desc STD
shipping STD
sku 59598
sku_pix YES
supplier_id 1
ta_dealer_a_price 9.5
ta_dealer_c_price 9.5
ta_price 14.81
text
array
1 59598
2 2900-4
3 ultramarine blue, 4 oz.
timestamp 2015-03-27T14:47:36.297Z
vip_member_price 11.39

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 29663
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] = '2964' 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.146.134.152

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&gr=golden-matte-fluid-acrylics.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 11:59:56'}
sessionid e030b2e84d1efd6c972244a1f11782765b35
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=coloring-books&CatC=people-places&CatD=sort~1~fb~dover~fp~0-7~&gr=dover-antique-locomotives-coloring-book.html
urltoken CFID=29676445&CFTOKEN=36220934&jsessionid=e030b2e84d1efd6c972244a1f11782765b35
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 11:59:56'}
sessionid e030aad7575f0a667f3d2b26231f10323715
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&gr=golden-matte-fluid-acrylics.html
urltoken CFID=29676446&CFTOKEN=59775343&jsessionid=e030aad7575f0a667f3d2b26231f10323715
validationerror [empty string]


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

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

ItemIDList: 29663
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 738797290747
barcode_type UPC
col1 yellow ochre
col1_sortorder 6691
col2 4 oz.
col2_sortorder 1804
col3 [empty string]
color_swatch 202-142-64.jpg
cost 8.56
deal_of_the_week NO
description yellow ochre, 4 oz.
group_id 10908
group_uname golden-matte-fluid-acrylics
id 59599
list_price 17.99
map YES
mfr_num 2907-4
net_weight 0.39
non_member_discount 25
non_member_price 13.49
prop65 YES
ship_rule_desc STD
shipping STD
sku 59599
sku_pix YES
supplier_id 1
ta_dealer_a_price 9
ta_dealer_c_price 9
ta_price 14.03
text
array
1 59599
2 2907-4
3 yellow ochre, 4 oz.
timestamp 2015-03-27T14:47:36.302Z
vip_member_price 10.79

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 29663
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] = '2964' 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.146.134.152

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&gr=golden-matte-fluid-acrylics.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 11:59:56'}
sessionid e030b2e84d1efd6c972244a1f11782765b35
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=coloring-books&CatC=people-places&CatD=sort~1~fb~dover~fp~0-7~&gr=dover-antique-locomotives-coloring-book.html
urltoken CFID=29676445&CFTOKEN=36220934&jsessionid=e030b2e84d1efd6c972244a1f11782765b35
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 11:59:56'}
sessionid e030aad7575f0a667f3d2b26231f10323715
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&gr=golden-matte-fluid-acrylics.html
urltoken CFID=29676446&CFTOKEN=59775343&jsessionid=e030aad7575f0a667f3d2b26231f10323715
validationerror [empty string]


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

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

ItemIDList: 29663
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 738797291546
barcode_type UPC
col1 zinc white
col1_sortorder 6729
col2 4 oz.
col2_sortorder 1804
col3 [empty string]
color_swatch 254-254-254.jpg
cost 8.56
deal_of_the_week NO
description zinc white, 4 oz.
group_id 10908
group_uname golden-matte-fluid-acrylics
id 59600
list_price 17.99
map YES
mfr_num 2915-4
net_weight 0.42
non_member_discount 25
non_member_price 13.49
prop65 YES
ship_rule_desc STD
shipping STD
sku 59600
sku_pix YES
supplier_id 1
ta_dealer_a_price 9
ta_dealer_c_price 9
ta_price 14.03
text
array
1 59600
2 2915-4
3 zinc white, 4 oz.
timestamp 2015-03-27T14:47:36.308Z
vip_member_price 10.79

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 29663
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] = '2964' 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.146.134.152

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&gr=golden-matte-fluid-acrylics.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 11:59:56'}
sessionid e030b2e84d1efd6c972244a1f11782765b35
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=coloring-books&CatC=people-places&CatD=sort~1~fb~dover~fp~0-7~&gr=dover-antique-locomotives-coloring-book.html
urltoken CFID=29676445&CFTOKEN=36220934&jsessionid=e030b2e84d1efd6c972244a1f11782765b35
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 11:59:56'}
sessionid e030aad7575f0a667f3d2b26231f10323715
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&gr=golden-matte-fluid-acrylics.html
urltoken CFID=29676446&CFTOKEN=59775343&jsessionid=e030aad7575f0a667f3d2b26231f10323715
validationerror [empty string]


Matte Fluid Acrylics are highly intense, permanent acrylic colors with a consistency similar to heavy cream. Produced from lightfast pigments, not dyes, they offer very strong colors with very thin consistencies. No fillers or extenders are added and the pigment load is comparable to Golden Heavy Body Acrylics. Unlike mixtures of heavy-bodied paints and water which produce weak color and films by dilution, Matte Fluid Acrylics contain high pigment levels suspended in an acrylic polymer vehicle. The result offers fine dispersion, high tinting strength, durability, flexibility and good adhesion.
Fluid Acrylics are ideal for spraying, brushing, staining, and can be mixed with other Golden Products.


Share on Facebook Twitter Pinterest

Ask a question about Matte Fluid Acrylics Ask a question about this product

Matte Fluid Acrylics

by Golden









  Item# Swatch Image color
Ascending
size Manufacturer Number List Price
Non-Member
VIP Member
Quantity
Add to Favorites
Matte Fluid Acrylics anthraquinone blue 4 oz.
Zoom Image
anthraquinone blue 4 oz. 2505-4 $24.39 $18.29 25% Off Click to See VIP Price Email When In Stock
Add to Favorites
Matte Fluid Acrylics burnt sienna 4 oz.
Zoom Image
burnt sienna 4 oz. 2520-4 $17.99 $13.49 25% Off Click to See VIP Price Email When In Stock
Add to Favorites
Matte Fluid Acrylics burnt umber 4 oz.
Zoom Image
burnt umber 4 oz. 2530-4 $17.99 $13.49 25% Off Click to See VIP Price Email When In Stock
Add to Favorites
Matte Fluid Acrylics carbon black 4 oz.
Zoom Image
carbon black 4 oz. 2540-4 $17.99 $13.49 25% Off Click to See VIP Price Email When In Stock
Add to Favorites
Matte Fluid Acrylics cerulean blue 4 oz.
Zoom Image
cerulean blue 4 oz. 2550-4 $24.39 $18.29 25% Off Click to See VIP Price Email When In Stock
Add to Favorites
Matte Fluid Acrylics chromium oxide green 4 oz.
Zoom Image
chromium oxide green 4 oz. 2560-4 $19.99 $14.99 25% Off Click to See VIP Price Email When In Stock
Add to Favorites
Matte Fluid Acrylics cobalt blue 4 oz.
Zoom Image
cobalt blue 4 oz. 2640-4 $26.69 $20.02 25% Off Click to See VIP Price Email When In Stock
Add to Favorites
Matte Fluid Acrylics diarylide yellow 4 oz.
Zoom Image
diarylide yellow 4 oz. 2647-4 $22.79 $17.09 25% Off Click to See VIP Price Email When In Stock
Add to Favorites
Matte Fluid Acrylics dioxazine purple 4 oz.
Zoom Image
dioxazine purple 4 oz. 2650-4 $22.79 $17.09 25% Off Click to See VIP Price Email When In Stock
Add to Favorites
Matte Fluid Acrylics green gold 4 oz.
Zoom Image
green gold 4 oz. 2670-4 $24.39 $18.29 25% Off Click to See VIP Price Email When In Stock
Add to Favorites
Matte Fluid Acrylics hansa yellow medium 4 oz.
Zoom Image
hansa yellow medium 4 oz. 2690-4 $19.99 $14.99 25% Off Click to See VIP Price Email When In Stock
Add to Favorites
Matte Fluid Acrylics hansa yellow opaque 4 oz.
Zoom Image
hansa yellow opaque 4 oz. 2691-4 $20.79 $15.59 25% Off Click to See VIP Price Email When In Stock
Add to Favorites
Matte Fluid Acrylics Jenkins green 4 oz.
Zoom Image
Jenkins green 4 oz. 2695-4 $24.39 $18.29 25% Off Click to See VIP Price Email When In Stock
Add to Favorites
Matte Fluid Acrylics naphthol red medium 4 oz.
Zoom Image
naphthol red medium 4 oz. 2720-4 $21.69 $16.27 25% Off Click to See VIP Price Email When In Stock
Add to Favorites
Matte Fluid Acrylics payne's gray 4 oz.
Zoom Image
payne's gray 4 oz. 2740-4 $18.99 $14.24 25% Off Click to See VIP Price Email When In Stock
Add to Favorites
Matte Fluid Acrylics permanent green light 4 oz.
Zoom Image
permanent green light 4 oz. 2750-4 $20.79 $15.59 25% Off Click to See VIP Price Email When In Stock
Add to Favorites
Matte Fluid Acrylics phthalo blue/green shade 4 oz.
Zoom Image
phthalo blue/green shade 4 oz. 2755-4 $20.79 $15.59 25% Off Click to See VIP Price Email When In Stock
Add to Favorites
Matte Fluid Acrylics phthalo green/blue shade 4 oz.
Zoom Image
phthalo green/blue shade 4 oz. 2770-4 $20.79 $15.59 25% Off Click to See VIP Price Email When In Stock
Add to Favorites