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

Artista II Liquid Tempera Paint

by Crayola


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

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

ItemIDList: 59165
AvailQtyList: 28.000000000000

struct
FLAGS 0
VIP_member_discount 34
barcode 071662003517
barcode_type UPC
col1 black
col1_sortorder 402
col2 32 oz.
col2_sortorder 1660
col3 [empty string]
color_swatch 0-0-0.jpg
cost 4.18
deal_of_the_week NO
description black, 32 oz.
group_id 1164
group_uname crayola-artista-ii-liquid-tempera-paint
id 71617
list_price 8.01
map NO
mfr_num 54-3132-051
net_weight 2.76
non_member_discount 24
non_member_price 6.09
prop65 NO
ship_rule_desc STD
shipping STD
sku 71617
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.81
ta_dealer_c_price 4.57
ta_price 6.41
text
array
1 71617
2 54-3132-051
3 black, 32 oz.
timestamp 2015-03-27T14:48:00.228Z
vip_member_price 5.29

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 28.000000000000 59165
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] = '5356' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=painting&catB=kids-paints&CatC=fb~crayola~fp~4-7~&gr=crayola-artista-ii-liquid-tempera-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:10:26'}
sessionid e030adbbf787da3b75685d6058552771771b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=polymer-hobby-clay&CatC=sort~1~fp~5-9999.99~c2~for-the-professional-artist~c3~tools~&gr=sculpey-super-firm-gray-sculpting-compound.html
urltoken CFID=29821352&CFTOKEN=77998916&jsessionid=e030adbbf787da3b75685d6058552771771b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:10:26'}
sessionid e030aa3505092dad46cb717c52a662526d71
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=kids-paints&CatC=fb~crayola~fp~4-7~&gr=crayola-artista-ii-liquid-tempera-paint.html
urltoken CFID=29821351&CFTOKEN=94221808&jsessionid=e030aa3505092dad46cb717c52a662526d71
validationerror [empty string]


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

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

ItemIDList: 59165
AvailQtyList: 28.000000000000

struct
FLAGS 0
VIP_member_discount 34
barcode 071662650513
barcode_type UPC
col1 black
col1_sortorder 402
col2 16 oz.
col2_sortorder 1008
col3 [empty string]
color_swatch 0-0-0.jpg
cost 2.34
deal_of_the_week NO
description black, 16 oz.
group_id 1164
group_uname crayola-artista-ii-liquid-tempera-paint
id 87305
list_price 4.49
map NO
mfr_num 54-3115-051
net_weight 1.4
non_member_discount 24
non_member_price 3.41
prop65 NO
ship_rule_desc STD
shipping STD
sku 87305
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.69
ta_dealer_c_price 2.56
ta_price 3.59
text
array
1 87305
2 54-3115-051
3 black, 16 oz.
timestamp 2015-03-27T14:48:19.282Z
vip_member_price 2.96

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 28.000000000000 59165
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] = '5356' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=painting&catB=kids-paints&CatC=fb~crayola~fp~4-7~&gr=crayola-artista-ii-liquid-tempera-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:10:26'}
sessionid e030adbbf787da3b75685d6058552771771b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=polymer-hobby-clay&CatC=sort~1~fp~5-9999.99~c2~for-the-professional-artist~c3~tools~&gr=sculpey-super-firm-gray-sculpting-compound.html
urltoken CFID=29821352&CFTOKEN=77998916&jsessionid=e030adbbf787da3b75685d6058552771771b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:10:26'}
sessionid e030aa3505092dad46cb717c52a662526d71
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=kids-paints&CatC=fb~crayola~fp~4-7~&gr=crayola-artista-ii-liquid-tempera-paint.html
urltoken CFID=29821351&CFTOKEN=94221808&jsessionid=e030aa3505092dad46cb717c52a662526d71
validationerror [empty string]


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

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

ItemIDList: 59165
AvailQtyList: 28.000000000000

struct
FLAGS 0
VIP_member_discount 34
barcode 071662003425
barcode_type UPC
col1 blue
col1_sortorder 542
col2 32 oz.
col2_sortorder 1660
col3 [empty string]
color_swatch 47-47-240.jpg
cost 4.18
deal_of_the_week NO
description blue, 32 oz.
group_id 1164
group_uname crayola-artista-ii-liquid-tempera-paint
id 50413
list_price 8.01
map NO
mfr_num 54-3132-042
net_weight 2.76
non_member_discount 24
non_member_price 6.09
prop65 NO
ship_rule_desc STD
shipping STD
sku 50413
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.81
ta_dealer_c_price 4.57
ta_price 6.41
text
array
1 50413
2 54-3132-042
3 blue, 32 oz.
timestamp 2015-03-27T14:47:24.883Z
vip_member_price 5.29

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 28.000000000000 59165
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] = '5356' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=painting&catB=kids-paints&CatC=fb~crayola~fp~4-7~&gr=crayola-artista-ii-liquid-tempera-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:10:26'}
sessionid e030adbbf787da3b75685d6058552771771b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=polymer-hobby-clay&CatC=sort~1~fp~5-9999.99~c2~for-the-professional-artist~c3~tools~&gr=sculpey-super-firm-gray-sculpting-compound.html
urltoken CFID=29821352&CFTOKEN=77998916&jsessionid=e030adbbf787da3b75685d6058552771771b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:10:26'}
sessionid e030aa3505092dad46cb717c52a662526d71
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=kids-paints&CatC=fb~crayola~fp~4-7~&gr=crayola-artista-ii-liquid-tempera-paint.html
urltoken CFID=29821351&CFTOKEN=94221808&jsessionid=e030aa3505092dad46cb717c52a662526d71
validationerror [empty string]


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

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

ItemIDList: 59165
AvailQtyList: 28.000000000000

struct
FLAGS 0
VIP_member_discount 34
barcode 071662650421
barcode_type UPC
col1 blue
col1_sortorder 542
col2 16 oz.
col2_sortorder 1008
col3 [empty string]
color_swatch 47-47-240.jpg
cost 2.34
deal_of_the_week NO
description blue, 16 oz.
group_id 1164
group_uname crayola-artista-ii-liquid-tempera-paint
id 83892
list_price 4.49
map NO
mfr_num 54-3115-042
net_weight 1.4
non_member_discount 24
non_member_price 3.41
prop65 NO
ship_rule_desc STD
shipping STD
sku 83892
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.69
ta_dealer_c_price 2.56
ta_price 3.59
text
array
1 83892
2 54-3115-042
3 blue, 16 oz.
timestamp 2015-03-27T14:48:14.28Z
vip_member_price 2.96

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 28.000000000000 59165
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] = '5356' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=painting&catB=kids-paints&CatC=fb~crayola~fp~4-7~&gr=crayola-artista-ii-liquid-tempera-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:10:26'}
sessionid e030adbbf787da3b75685d6058552771771b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=polymer-hobby-clay&CatC=sort~1~fp~5-9999.99~c2~for-the-professional-artist~c3~tools~&gr=sculpey-super-firm-gray-sculpting-compound.html
urltoken CFID=29821352&CFTOKEN=77998916&jsessionid=e030adbbf787da3b75685d6058552771771b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:10:26'}
sessionid e030aa3505092dad46cb717c52a662526d71
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=kids-paints&CatC=fb~crayola~fp~4-7~&gr=crayola-artista-ii-liquid-tempera-paint.html
urltoken CFID=29821351&CFTOKEN=94221808&jsessionid=e030aa3505092dad46cb717c52a662526d71
validationerror [empty string]


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

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

ItemIDList: 59165
AvailQtyList: 28.000000000000

struct
FLAGS 0
VIP_member_discount 34
barcode 071662003074
barcode_type UPC
col1 brown
col1_sortorder 798
col2 32 oz.
col2_sortorder 1660
col3 [empty string]
color_swatch 119-79-0.jpg
cost 4.18
deal_of_the_week NO
description brown, 32 oz.
group_id 1164
group_uname crayola-artista-ii-liquid-tempera-paint
id 56953
list_price 8.01
map NO
mfr_num 54-3132-007
net_weight 2.76
non_member_discount 24
non_member_price 6.09
prop65 NO
ship_rule_desc STD
shipping STD
sku 56953
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.81
ta_dealer_c_price 4.57
ta_price 6.41
text
array
1 56953
2 54-3132-007
3 brown, 32 oz.
timestamp 2015-03-27T14:47:32.021Z
vip_member_price 5.29

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 28.000000000000 59165
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] = '5356' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=painting&catB=kids-paints&CatC=fb~crayola~fp~4-7~&gr=crayola-artista-ii-liquid-tempera-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:10:26'}
sessionid e030adbbf787da3b75685d6058552771771b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=polymer-hobby-clay&CatC=sort~1~fp~5-9999.99~c2~for-the-professional-artist~c3~tools~&gr=sculpey-super-firm-gray-sculpting-compound.html
urltoken CFID=29821352&CFTOKEN=77998916&jsessionid=e030adbbf787da3b75685d6058552771771b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:10:26'}
sessionid e030aa3505092dad46cb717c52a662526d71
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=kids-paints&CatC=fb~crayola~fp~4-7~&gr=crayola-artista-ii-liquid-tempera-paint.html
urltoken CFID=29821351&CFTOKEN=94221808&jsessionid=e030aa3505092dad46cb717c52a662526d71
validationerror [empty string]


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

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

ItemIDList: 59165
AvailQtyList: 28.000000000000

struct
FLAGS 0
VIP_member_discount 34
barcode 071662650070
barcode_type UPC
col1 brown
col1_sortorder 798
col2 16 oz.
col2_sortorder 1008
col3 [empty string]
color_swatch 119-79-0.jpg
cost 2.34
deal_of_the_week NO
description brown, 16 oz.
group_id 1164
group_uname crayola-artista-ii-liquid-tempera-paint
id 80975
list_price 4.49
map NO
mfr_num 54-3115-007
net_weight 1.4
non_member_discount 24
non_member_price 3.41
prop65 NO
ship_rule_desc STD
shipping STD
sku 80975
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.69
ta_dealer_c_price 2.56
ta_price 3.59
text
array
1 80975
2 54-3115-007
3 brown, 16 oz.
timestamp 2015-03-27T14:48:11.664Z
vip_member_price 2.96

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 28.000000000000 59165
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] = '5356' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=painting&catB=kids-paints&CatC=fb~crayola~fp~4-7~&gr=crayola-artista-ii-liquid-tempera-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:10:26'}
sessionid e030adbbf787da3b75685d6058552771771b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=polymer-hobby-clay&CatC=sort~1~fp~5-9999.99~c2~for-the-professional-artist~c3~tools~&gr=sculpey-super-firm-gray-sculpting-compound.html
urltoken CFID=29821352&CFTOKEN=77998916&jsessionid=e030adbbf787da3b75685d6058552771771b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:10:26'}
sessionid e030aa3505092dad46cb717c52a662526d71
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=kids-paints&CatC=fb~crayola~fp~4-7~&gr=crayola-artista-ii-liquid-tempera-paint.html
urltoken CFID=29821351&CFTOKEN=94221808&jsessionid=e030aa3505092dad46cb717c52a662526d71
validationerror [empty string]


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

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

ItemIDList: 59165
AvailQtyList: 28.000000000000

struct
FLAGS 0
VIP_member_discount 34
barcode 071662003449
barcode_type UPC
col1 green
col1_sortorder 2621
col2 32 oz.
col2_sortorder 1660
col3 [empty string]
color_swatch 0-164-123.jpg
cost 4.18
deal_of_the_week NO
description green, 32 oz.
group_id 1164
group_uname crayola-artista-ii-liquid-tempera-paint
id 12579
list_price 8.01
map NO
mfr_num 54-3132-044
net_weight 2.76
non_member_discount 24
non_member_price 6.09
prop65 NO
ship_rule_desc STD
shipping STD
sku 12579
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.81
ta_dealer_c_price 4.57
ta_price 6.41
text
array
1 12579
2 54-3132-044
3 green, 32 oz.
timestamp 2015-03-27T14:46:27.684Z
vip_member_price 5.29

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 28.000000000000 59165
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] = '5356' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=painting&catB=kids-paints&CatC=fb~crayola~fp~4-7~&gr=crayola-artista-ii-liquid-tempera-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:10:26'}
sessionid e030adbbf787da3b75685d6058552771771b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=polymer-hobby-clay&CatC=sort~1~fp~5-9999.99~c2~for-the-professional-artist~c3~tools~&gr=sculpey-super-firm-gray-sculpting-compound.html
urltoken CFID=29821352&CFTOKEN=77998916&jsessionid=e030adbbf787da3b75685d6058552771771b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:10:26'}
sessionid e030aa3505092dad46cb717c52a662526d71
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=kids-paints&CatC=fb~crayola~fp~4-7~&gr=crayola-artista-ii-liquid-tempera-paint.html
urltoken CFID=29821351&CFTOKEN=94221808&jsessionid=e030aa3505092dad46cb717c52a662526d71
validationerror [empty string]


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

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

ItemIDList: 59165
AvailQtyList: 28.000000000000

struct
FLAGS 0
VIP_member_discount 34
barcode 071662650445
barcode_type UPC
col1 green
col1_sortorder 2621
col2 16 oz.
col2_sortorder 1008
col3 [empty string]
color_swatch 0-164-123.jpg
cost 2.34
deal_of_the_week NO
description green, 16 oz.
group_id 1164
group_uname crayola-artista-ii-liquid-tempera-paint
id 54805
list_price 4.49
map NO
mfr_num 54-3115-044
net_weight 1.4
non_member_discount 24
non_member_price 3.41
prop65 NO
ship_rule_desc STD
shipping STD
sku 54805
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.69
ta_dealer_c_price 2.56
ta_price 3.59
text
array
1 54805
2 54-3115-044
3 green, 16 oz.
timestamp 2015-03-27T14:47:29.315Z
vip_member_price 2.96

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 28.000000000000 59165
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] = '5356' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=painting&catB=kids-paints&CatC=fb~crayola~fp~4-7~&gr=crayola-artista-ii-liquid-tempera-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:10:26'}
sessionid e030adbbf787da3b75685d6058552771771b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=polymer-hobby-clay&CatC=sort~1~fp~5-9999.99~c2~for-the-professional-artist~c3~tools~&gr=sculpey-super-firm-gray-sculpting-compound.html
urltoken CFID=29821352&CFTOKEN=77998916&jsessionid=e030adbbf787da3b75685d6058552771771b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:10:26'}
sessionid e030aa3505092dad46cb717c52a662526d71
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=kids-paints&CatC=fb~crayola~fp~4-7~&gr=crayola-artista-ii-liquid-tempera-paint.html
urltoken CFID=29821351&CFTOKEN=94221808&jsessionid=e030aa3505092dad46cb717c52a662526d71
validationerror [empty string]


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

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

ItemIDList: 59165
AvailQtyList: 28.000000000000

struct
FLAGS 0
VIP_member_discount 34
barcode 071662003692
barcode_type UPC
col1 magenta
col1_sortorder 3529
col2 32 oz.
col2_sortorder 1660
col3 [empty string]
color_swatch 240-47-163.jpg
cost 4.18
deal_of_the_week NO
description magenta, 32 oz.
group_id 1164
group_uname crayola-artista-ii-liquid-tempera-paint
id 27510
list_price 8.01
map NO
mfr_num 54-3132-069
net_weight 2.76
non_member_discount 24
non_member_price 6.09
prop65 NO
ship_rule_desc STD
shipping STD
sku 27510
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.81
ta_dealer_c_price 4.57
ta_price 6.41
text
array
1 27510
2 54-3132-069
3 magenta, 32 oz.
timestamp 2015-03-27T14:46:50.738Z
vip_member_price 5.29

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 28.000000000000 59165
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] = '5356' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=painting&catB=kids-paints&CatC=fb~crayola~fp~4-7~&gr=crayola-artista-ii-liquid-tempera-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:10:26'}
sessionid e030adbbf787da3b75685d6058552771771b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=polymer-hobby-clay&CatC=sort~1~fp~5-9999.99~c2~for-the-professional-artist~c3~tools~&gr=sculpey-super-firm-gray-sculpting-compound.html
urltoken CFID=29821352&CFTOKEN=77998916&jsessionid=e030adbbf787da3b75685d6058552771771b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:10:26'}
sessionid e030aa3505092dad46cb717c52a662526d71
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=kids-paints&CatC=fb~crayola~fp~4-7~&gr=crayola-artista-ii-liquid-tempera-paint.html
urltoken CFID=29821351&CFTOKEN=94221808&jsessionid=e030aa3505092dad46cb717c52a662526d71
validationerror [empty string]


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

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

ItemIDList: 59165
AvailQtyList: 28.000000000000

struct
FLAGS 0
VIP_member_discount 34
barcode 071662650698
barcode_type UPC
col1 magenta
col1_sortorder 3529
col2 16 oz.
col2_sortorder 1008
col3 [empty string]
color_swatch 240-47-163.jpg
cost 2.34
deal_of_the_week NO
description magenta, 16 oz.
group_id 1164
group_uname crayola-artista-ii-liquid-tempera-paint
id 37819
list_price 4.49
map NO
mfr_num 54-3115-069
net_weight 1.36
non_member_discount 24
non_member_price 3.41
prop65 NO
ship_rule_desc STD
shipping STD
sku 37819
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.69
ta_dealer_c_price 2.56
ta_price 3.59
text
array
1 37819
2 54-3115-069
3 magenta, 16 oz.
timestamp 2015-03-27T14:47:09.811Z
vip_member_price 2.96

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 28.000000000000 59165
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] = '5356' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=painting&catB=kids-paints&CatC=fb~crayola~fp~4-7~&gr=crayola-artista-ii-liquid-tempera-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:10:26'}
sessionid e030adbbf787da3b75685d6058552771771b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=polymer-hobby-clay&CatC=sort~1~fp~5-9999.99~c2~for-the-professional-artist~c3~tools~&gr=sculpey-super-firm-gray-sculpting-compound.html
urltoken CFID=29821352&CFTOKEN=77998916&jsessionid=e030adbbf787da3b75685d6058552771771b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:10:26'}
sessionid e030aa3505092dad46cb717c52a662526d71
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=kids-paints&CatC=fb~crayola~fp~4-7~&gr=crayola-artista-ii-liquid-tempera-paint.html
urltoken CFID=29821351&CFTOKEN=94221808&jsessionid=e030aa3505092dad46cb717c52a662526d71
validationerror [empty string]


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

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

ItemIDList: 59165
AvailQtyList: 28.000000000000

struct
FLAGS 0
VIP_member_discount 34
barcode 071662650360
barcode_type UPC
col1 orange
col1_sortorder 4215
col2 16 oz.
col2_sortorder 1008
col3 [empty string]
color_swatch 210-121-77.jpg
cost 2.34
deal_of_the_week NO
description orange, 16 oz.
group_id 1164
group_uname crayola-artista-ii-liquid-tempera-paint
id 49195
list_price 4.49
map NO
mfr_num 54-3115-036
net_weight 1.4
non_member_discount 24
non_member_price 3.41
prop65 NO
ship_rule_desc STD
shipping STD
sku 49195
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.69
ta_dealer_c_price 2.56
ta_price 3.59
text
array
1 49195
2 54-3115-036
3 orange, 16 oz.
timestamp 2015-03-27T14:47:23.633Z
vip_member_price 2.96

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 28.000000000000 59165
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] = '5356' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=painting&catB=kids-paints&CatC=fb~crayola~fp~4-7~&gr=crayola-artista-ii-liquid-tempera-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:10:26'}
sessionid e030adbbf787da3b75685d6058552771771b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=polymer-hobby-clay&CatC=sort~1~fp~5-9999.99~c2~for-the-professional-artist~c3~tools~&gr=sculpey-super-firm-gray-sculpting-compound.html
urltoken CFID=29821352&CFTOKEN=77998916&jsessionid=e030adbbf787da3b75685d6058552771771b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:10:26'}
sessionid e030aa3505092dad46cb717c52a662526d71
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=kids-paints&CatC=fb~crayola~fp~4-7~&gr=crayola-artista-ii-liquid-tempera-paint.html
urltoken CFID=29821351&CFTOKEN=94221808&jsessionid=e030aa3505092dad46cb717c52a662526d71
validationerror [empty string]


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

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

ItemIDList: 59165
AvailQtyList: 28.000000000000

struct
FLAGS 0
VIP_member_discount 34
barcode 071662023362
barcode_type UPC
col1 orange
col1_sortorder 4215
col2 32 oz.
col2_sortorder 1660
col3 [empty string]
color_swatch 210-121-77.jpg
cost 4.18
deal_of_the_week NO
description orange, 32 oz.
group_id 1164
group_uname crayola-artista-ii-liquid-tempera-paint
id 49833
list_price 8.01
map NO
mfr_num 54-3132-036
net_weight 2.76
non_member_discount 24
non_member_price 6.09
prop65 NO
ship_rule_desc STD
shipping STD
sku 49833
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.81
ta_dealer_c_price 4.57
ta_price 6.41
text
array
1 49833
2 54-3132-036
3 orange, 32 oz.
timestamp 2015-03-27T14:47:24.277Z
vip_member_price 5.29

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 28.000000000000 59165
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] = '5356' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=painting&catB=kids-paints&CatC=fb~crayola~fp~4-7~&gr=crayola-artista-ii-liquid-tempera-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:10:26'}
sessionid e030adbbf787da3b75685d6058552771771b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=polymer-hobby-clay&CatC=sort~1~fp~5-9999.99~c2~for-the-professional-artist~c3~tools~&gr=sculpey-super-firm-gray-sculpting-compound.html
urltoken CFID=29821352&CFTOKEN=77998916&jsessionid=e030adbbf787da3b75685d6058552771771b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:10:26'}
sessionid e030aa3505092dad46cb717c52a662526d71
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=kids-paints&CatC=fb~crayola~fp~4-7~&gr=crayola-artista-ii-liquid-tempera-paint.html
urltoken CFID=29821351&CFTOKEN=94221808&jsessionid=e030aa3505092dad46cb717c52a662526d71
validationerror [empty string]


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

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

ItemIDList: 59165
AvailQtyList: 28.000000000000

struct
FLAGS 0
VIP_member_discount 34
barcode 071662650384
barcode_type UPC
col1 red
col1_sortorder 5079
col2 16 oz.
col2_sortorder 1008
col3 [empty string]
color_swatch 240-47-91.jpg
cost 2.34
deal_of_the_week NO
description red, 16 oz.
group_id 1164
group_uname crayola-artista-ii-liquid-tempera-paint
id 46516
list_price 4.49
map NO
mfr_num 54-3115-038
net_weight 1.4
non_member_discount 24
non_member_price 3.41
prop65 NO
ship_rule_desc STD
shipping STD
sku 46516
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.69
ta_dealer_c_price 2.56
ta_price 3.59
text
array
1 46516
2 54-3115-038
3 red, 16 oz.
timestamp 2015-03-27T14:47:20.659Z
vip_member_price 2.96

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 28.000000000000 59165
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] = '5356' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=painting&catB=kids-paints&CatC=fb~crayola~fp~4-7~&gr=crayola-artista-ii-liquid-tempera-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:10:26'}
sessionid e030adbbf787da3b75685d6058552771771b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=polymer-hobby-clay&CatC=sort~1~fp~5-9999.99~c2~for-the-professional-artist~c3~tools~&gr=sculpey-super-firm-gray-sculpting-compound.html
urltoken CFID=29821352&CFTOKEN=77998916&jsessionid=e030adbbf787da3b75685d6058552771771b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:10:26'}
sessionid e030aa3505092dad46cb717c52a662526d71
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=kids-paints&CatC=fb~crayola~fp~4-7~&gr=crayola-artista-ii-liquid-tempera-paint.html
urltoken CFID=29821351&CFTOKEN=94221808&jsessionid=e030aa3505092dad46cb717c52a662526d71
validationerror [empty string]


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

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

ItemIDList: 59165
AvailQtyList: 28.000000000000

struct
FLAGS 0
VIP_member_discount 34
barcode 071662003388
barcode_type UPC
col1 red
col1_sortorder 5079
col2 32 oz.
col2_sortorder 1660
col3 [empty string]
color_swatch 240-47-91.jpg
cost 4.18
deal_of_the_week NO
description red, 32 oz.
group_id 1164
group_uname crayola-artista-ii-liquid-tempera-paint
id 61574
list_price 8.01
map NO
mfr_num 54-3132-038
net_weight 2.76
non_member_discount 24
non_member_price 6.09
prop65 NO
ship_rule_desc STD
shipping STD
sku 61574
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.81
ta_dealer_c_price 4.57
ta_price 6.41
text
array
1 61574
2 54-3132-038
3 red, 32 oz.
timestamp 2015-03-27T14:47:41.05Z
vip_member_price 5.29

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 28.000000000000 59165
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] = '5356' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=painting&catB=kids-paints&CatC=fb~crayola~fp~4-7~&gr=crayola-artista-ii-liquid-tempera-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:10:26'}
sessionid e030adbbf787da3b75685d6058552771771b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=polymer-hobby-clay&CatC=sort~1~fp~5-9999.99~c2~for-the-professional-artist~c3~tools~&gr=sculpey-super-firm-gray-sculpting-compound.html
urltoken CFID=29821352&CFTOKEN=77998916&jsessionid=e030adbbf787da3b75685d6058552771771b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:10:26'}
sessionid e030aa3505092dad46cb717c52a662526d71
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=kids-paints&CatC=fb~crayola~fp~4-7~&gr=crayola-artista-ii-liquid-tempera-paint.html
urltoken CFID=29821351&CFTOKEN=94221808&jsessionid=e030aa3505092dad46cb717c52a662526d71
validationerror [empty string]


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

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

ItemIDList: 59165
AvailQtyList: 28.000000000000

struct
FLAGS 0
VIP_member_discount 34
barcode 071662650483
barcode_type UPC
col1 turquoise
col1_sortorder 6204
col2 16 oz.
col2_sortorder 1008
col3 [empty string]
color_swatch 0-141-164.jpg
cost 2.34
deal_of_the_week NO
description turquoise, 16 oz.
group_id 1164
group_uname crayola-artista-ii-liquid-tempera-paint
id 57860
list_price 4.49
map NO
mfr_num 54-3115-048
net_weight 1.4
non_member_discount 24
non_member_price 3.41
prop65 NO
ship_rule_desc STD
shipping STD
sku 57860
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.69
ta_dealer_c_price 2.56
ta_price 3.59
text
array
1 57860
2 54-3115-048
3 turquoise, 16 oz.
timestamp 2015-03-27T14:47:32.966Z
vip_member_price 2.96

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 28.000000000000 59165
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] = '5356' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=painting&catB=kids-paints&CatC=fb~crayola~fp~4-7~&gr=crayola-artista-ii-liquid-tempera-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:10:26'}
sessionid e030adbbf787da3b75685d6058552771771b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=polymer-hobby-clay&CatC=sort~1~fp~5-9999.99~c2~for-the-professional-artist~c3~tools~&gr=sculpey-super-firm-gray-sculpting-compound.html
urltoken CFID=29821352&CFTOKEN=77998916&jsessionid=e030adbbf787da3b75685d6058552771771b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:10:26'}
sessionid e030aa3505092dad46cb717c52a662526d71
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=kids-paints&CatC=fb~crayola~fp~4-7~&gr=crayola-artista-ii-liquid-tempera-paint.html
urltoken CFID=29821351&CFTOKEN=94221808&jsessionid=e030aa3505092dad46cb717c52a662526d71
validationerror [empty string]


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

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

ItemIDList: 59165
AvailQtyList: 28.000000000000

struct
FLAGS 0
VIP_member_discount 34
barcode 071662003487
barcode_type UPC
col1 turquoise
col1_sortorder 6204
col2 32 oz.
col2_sortorder 1660
col3 [empty string]
color_swatch 0-141-164.jpg
cost 4.18
deal_of_the_week NO
description turquoise, 32 oz.
group_id 1164
group_uname crayola-artista-ii-liquid-tempera-paint
id 61757
list_price 8.01
map NO
mfr_num 54-3132-048
net_weight 2.76
non_member_discount 24
non_member_price 6.09
prop65 NO
ship_rule_desc STD
shipping STD
sku 61757
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.81
ta_dealer_c_price 4.57
ta_price 6.41
text
array
1 61757
2 54-3132-048
3 turquoise, 32 oz.
timestamp 2015-03-27T14:47:41.185Z
vip_member_price 5.29

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 28.000000000000 59165
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] = '5356' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=painting&catB=kids-paints&CatC=fb~crayola~fp~4-7~&gr=crayola-artista-ii-liquid-tempera-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:10:26'}
sessionid e030adbbf787da3b75685d6058552771771b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=polymer-hobby-clay&CatC=sort~1~fp~5-9999.99~c2~for-the-professional-artist~c3~tools~&gr=sculpey-super-firm-gray-sculpting-compound.html
urltoken CFID=29821352&CFTOKEN=77998916&jsessionid=e030adbbf787da3b75685d6058552771771b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:10:26'}
sessionid e030aa3505092dad46cb717c52a662526d71
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=kids-paints&CatC=fb~crayola~fp~4-7~&gr=crayola-artista-ii-liquid-tempera-paint.html
urltoken CFID=29821351&CFTOKEN=94221808&jsessionid=e030aa3505092dad46cb717c52a662526d71
validationerror [empty string]


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

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

ItemIDList: 59165
AvailQtyList: 28.000000000000

struct
FLAGS 0
VIP_member_discount 34
barcode 071662650407
barcode_type UPC
col1 violet
col1_sortorder 6398
col2 16 oz.
col2_sortorder 1008
col3 [empty string]
color_swatch 185-77-210.jpg
cost 2.34
deal_of_the_week NO
description violet, 16 oz.
group_id 1164
group_uname crayola-artista-ii-liquid-tempera-paint
id 37459
list_price 4.49
map NO
mfr_num 54-3115-040
net_weight 1.4
non_member_discount 24
non_member_price 3.41
prop65 NO
ship_rule_desc STD
shipping STD
sku 37459
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.69
ta_dealer_c_price 2.56
ta_price 3.59
text
array
1 37459
2 54-3115-040
3 violet, 16 oz.
timestamp 2015-03-27T14:47:09.273Z
vip_member_price 2.96

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 28.000000000000 59165
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] = '5356' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=painting&catB=kids-paints&CatC=fb~crayola~fp~4-7~&gr=crayola-artista-ii-liquid-tempera-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:10:26'}
sessionid e030adbbf787da3b75685d6058552771771b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=polymer-hobby-clay&CatC=sort~1~fp~5-9999.99~c2~for-the-professional-artist~c3~tools~&gr=sculpey-super-firm-gray-sculpting-compound.html
urltoken CFID=29821352&CFTOKEN=77998916&jsessionid=e030adbbf787da3b75685d6058552771771b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:10:26'}
sessionid e030aa3505092dad46cb717c52a662526d71
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=kids-paints&CatC=fb~crayola~fp~4-7~&gr=crayola-artista-ii-liquid-tempera-paint.html
urltoken CFID=29821351&CFTOKEN=94221808&jsessionid=e030aa3505092dad46cb717c52a662526d71
validationerror [empty string]


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

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

ItemIDList: 59165
AvailQtyList: 28.000000000000

struct
FLAGS 0
VIP_member_discount 34
barcode 071662003401
barcode_type UPC
col1 violet
col1_sortorder 6398
col2 32 oz.
col2_sortorder 1660
col3 [empty string]
color_swatch 185-77-210.jpg
cost 4.18
deal_of_the_week NO
description violet, 32 oz.
group_id 1164
group_uname crayola-artista-ii-liquid-tempera-paint
id 47240
list_price 8.01
map NO
mfr_num 54-3132-040
net_weight 2.76
non_member_discount 24
non_member_price 6.09
prop65 NO
ship_rule_desc STD
shipping STD
sku 47240
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.81
ta_dealer_c_price 4.57
ta_price 6.41
text
array
1 47240
2 54-3132-040
3 violet, 32 oz.
timestamp 2015-03-27T14:47:21.507Z
vip_member_price 5.29

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 28.000000000000 59165
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] = '5356' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=painting&catB=kids-paints&CatC=fb~crayola~fp~4-7~&gr=crayola-artista-ii-liquid-tempera-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:10:26'}
sessionid e030adbbf787da3b75685d6058552771771b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=polymer-hobby-clay&CatC=sort~1~fp~5-9999.99~c2~for-the-professional-artist~c3~tools~&gr=sculpey-super-firm-gray-sculpting-compound.html
urltoken CFID=29821352&CFTOKEN=77998916&jsessionid=e030adbbf787da3b75685d6058552771771b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:10:26'}
sessionid e030aa3505092dad46cb717c52a662526d71
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=kids-paints&CatC=fb~crayola~fp~4-7~&gr=crayola-artista-ii-liquid-tempera-paint.html
urltoken CFID=29821351&CFTOKEN=94221808&jsessionid=e030aa3505092dad46cb717c52a662526d71
validationerror [empty string]


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

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

ItemIDList: 59165
AvailQtyList: 28.000000000000

struct
FLAGS 0
VIP_member_discount 34
barcode 071662650537
barcode_type UPC
col1 white
col1_sortorder 6534
col2 16 oz.
col2_sortorder 1008
col3 [empty string]
color_swatch 255-255-255.jpg
cost 2.34
deal_of_the_week NO
description white, 16 oz.
group_id 1164
group_uname crayola-artista-ii-liquid-tempera-paint
id 21803
list_price 4.49
map NO
mfr_num 54-3115-053
net_weight 1.4
non_member_discount 24
non_member_price 3.41
prop65 NO
ship_rule_desc STD
shipping STD
sku 21803
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.69
ta_dealer_c_price 2.56
ta_price 3.59
text
array
1 21803
2 54-3115-053
3 white, 16 oz.
timestamp 2015-03-27T14:46:42.613Z
vip_member_price 2.96

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 28.000000000000 59165
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] = '5356' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=painting&catB=kids-paints&CatC=fb~crayola~fp~4-7~&gr=crayola-artista-ii-liquid-tempera-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:10:26'}
sessionid e030adbbf787da3b75685d6058552771771b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=polymer-hobby-clay&CatC=sort~1~fp~5-9999.99~c2~for-the-professional-artist~c3~tools~&gr=sculpey-super-firm-gray-sculpting-compound.html
urltoken CFID=29821352&CFTOKEN=77998916&jsessionid=e030adbbf787da3b75685d6058552771771b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:10:26'}
sessionid e030aa3505092dad46cb717c52a662526d71
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=kids-paints&CatC=fb~crayola~fp~4-7~&gr=crayola-artista-ii-liquid-tempera-paint.html
urltoken CFID=29821351&CFTOKEN=94221808&jsessionid=e030aa3505092dad46cb717c52a662526d71
validationerror [empty string]


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

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

ItemIDList: 59165
AvailQtyList: 28.000000000000

struct
FLAGS 0
VIP_member_discount 34
barcode 071662003531
barcode_type UPC
col1 white
col1_sortorder 6534
col2 32 oz.
col2_sortorder 1660
col3 [empty string]
color_swatch 255-255-255.jpg
cost 4.18
deal_of_the_week NO
description white, 32 oz.
group_id 1164
group_uname crayola-artista-ii-liquid-tempera-paint
id 24195
list_price 8.01
map NO
mfr_num 54-3132-053
net_weight 2.76
non_member_discount 24
non_member_price 6.09
prop65 NO
ship_rule_desc STD
shipping STD
sku 24195
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.81
ta_dealer_c_price 4.57
ta_price 6.41
text
array
1 24195
2 54-3132-053
3 white, 32 oz.
timestamp 2015-03-27T14:46:45.475Z
vip_member_price 5.29

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 28.000000000000 59165
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] = '5356' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=painting&catB=kids-paints&CatC=fb~crayola~fp~4-7~&gr=crayola-artista-ii-liquid-tempera-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:10:26'}
sessionid e030adbbf787da3b75685d6058552771771b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=polymer-hobby-clay&CatC=sort~1~fp~5-9999.99~c2~for-the-professional-artist~c3~tools~&gr=sculpey-super-firm-gray-sculpting-compound.html
urltoken CFID=29821352&CFTOKEN=77998916&jsessionid=e030adbbf787da3b75685d6058552771771b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:10:26'}
sessionid e030aa3505092dad46cb717c52a662526d71
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=kids-paints&CatC=fb~crayola~fp~4-7~&gr=crayola-artista-ii-liquid-tempera-paint.html
urltoken CFID=29821351&CFTOKEN=94221808&jsessionid=e030aa3505092dad46cb717c52a662526d71
validationerror [empty string]


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

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

ItemIDList: 59165
AvailQtyList: 28.000000000000

struct
FLAGS 0
VIP_member_discount 34
barcode 071662003340
barcode_type UPC
col1 yellow
col1_sortorder 6670
col2 32 oz.
col2_sortorder 1660
col3 [empty string]
color_swatch 240-229-92.jpg
cost 4.18
deal_of_the_week NO
description yellow, 32 oz.
group_id 1164
group_uname crayola-artista-ii-liquid-tempera-paint
id 45910
list_price 8.01
map NO
mfr_num 54-3132-034
net_weight 2.76
non_member_discount 24
non_member_price 6.09
prop65 NO
ship_rule_desc STD
shipping STD
sku 45910
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.81
ta_dealer_c_price 4.57
ta_price 6.41
text
array
1 45910
2 54-3132-034
3 yellow, 32 oz.
timestamp 2015-03-27T14:47:19.223Z
vip_member_price 5.29

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 28.000000000000 59165
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] = '5356' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=painting&catB=kids-paints&CatC=fb~crayola~fp~4-7~&gr=crayola-artista-ii-liquid-tempera-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:10:26'}
sessionid e030adbbf787da3b75685d6058552771771b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=polymer-hobby-clay&CatC=sort~1~fp~5-9999.99~c2~for-the-professional-artist~c3~tools~&gr=sculpey-super-firm-gray-sculpting-compound.html
urltoken CFID=29821352&CFTOKEN=77998916&jsessionid=e030adbbf787da3b75685d6058552771771b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:10:26'}
sessionid e030aa3505092dad46cb717c52a662526d71
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=kids-paints&CatC=fb~crayola~fp~4-7~&gr=crayola-artista-ii-liquid-tempera-paint.html
urltoken CFID=29821351&CFTOKEN=94221808&jsessionid=e030aa3505092dad46cb717c52a662526d71
validationerror [empty string]


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

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

ItemIDList: 59165
AvailQtyList: 28.000000000000

struct
FLAGS 0
VIP_member_discount 34
barcode 071662650346
barcode_type UPC
col1 yellow
col1_sortorder 6670
col2 16 oz.
col2_sortorder 1008
col3 [empty string]
color_swatch 240-229-92.jpg
cost 2.34
deal_of_the_week NO
description yellow, 16 oz.
group_id 1164
group_uname crayola-artista-ii-liquid-tempera-paint
id 70380
list_price 4.49
map NO
mfr_num 54-3115-034
net_weight 1.4
non_member_discount 24
non_member_price 3.41
prop65 NO
ship_rule_desc STD
shipping STD
sku 70380
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.69
ta_dealer_c_price 2.56
ta_price 3.59
text
array
1 70380
2 54-3115-034
3 yellow, 16 oz.
timestamp 2015-03-27T14:47:56.426Z
vip_member_price 2.96

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 28.000000000000 59165
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] = '5356' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=painting&catB=kids-paints&CatC=fb~crayola~fp~4-7~&gr=crayola-artista-ii-liquid-tempera-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:10:26'}
sessionid e030adbbf787da3b75685d6058552771771b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=polymer-hobby-clay&CatC=sort~1~fp~5-9999.99~c2~for-the-professional-artist~c3~tools~&gr=sculpey-super-firm-gray-sculpting-compound.html
urltoken CFID=29821352&CFTOKEN=77998916&jsessionid=e030adbbf787da3b75685d6058552771771b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:10:26'}
sessionid e030aa3505092dad46cb717c52a662526d71
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=kids-paints&CatC=fb~crayola~fp~4-7~&gr=crayola-artista-ii-liquid-tempera-paint.html
urltoken CFID=29821351&CFTOKEN=94221808&jsessionid=e030aa3505092dad46cb717c52a662526d71
validationerror [empty string]


An ideal choice of paints when economy is important. Improved mixing properties allow for more vibrant secondary colors. Smoother flow allows for better laydown. These tempera paints provide great coverage and colors that stay true when they dry. They are also freeze-thaw stable, and the non-separating formula gives them excellent shelf life. Wide range of uses including maps, murals, and posters. Dries quickly to a smooth, opaque matte finish. Non-toxic and washable.



Share on Facebook Twitter Pinterest

Ask a question about Artista II Liquid Tempera Paint Ask a question about this product  |  See all questions & answers (1)

Artista II Liquid Tempera Paint

by Crayola

Average User Rating: Based on (4 Reviews)

5 4

Denise F. from Charlotte, NC says:

The paint was just what we needed. We had plenty and even had about half left over after 3 weeks of summer camp.

[Read All Reviews] [Write a Review]









  Item# Swatch Image color
Ascending
size Manufacturer Number List Price
Non-Member
Price
VIP Member
Club Price
Quantity
Add to Favorites
71617
Artista II Liquid Tempera Paint black 32 oz.
Zoom Image
black 32 oz. 54-3132-051 $8.01 $6.09 24% Off $5.29 34% Off Email When In Stock
Add to Favorites
87305
Artista II Liquid Tempera Paint black 16 oz.
Zoom Image
black 16 oz. 54-3115-051 $4.49 $3.41 24% Off $2.96 34% Off Email When In Stock
Add to Favorites
50413
Artista II Liquid Tempera Paint blue 32 oz.
Zoom Image
blue 32 oz. 54-3132-042 $8.01 $6.09 24% Off $5.29 34% Off Email When In Stock
Add to Favorites
83892
Artista II Liquid Tempera Paint blue 16 oz.
Zoom Image
blue 16 oz. 54-3115-042 $4.49 $3.41 24% Off $2.96 34% Off Email When In Stock
Add to Favorites
56953
Artista II Liquid Tempera Paint brown 32 oz.
Zoom Image
brown 32 oz. 54-3132-007 $8.01 $6.09 24% Off $5.29 34% Off Email When In Stock
Add to Favorites
80975
Artista II Liquid Tempera Paint brown 16 oz.
Zoom Image
brown 16 oz. 54-3115-007 $4.49 $3.41 24% Off $2.96 34% Off Email When In Stock
Add to Favorites
12579
Artista II Liquid Tempera Paint green 32 oz.
Zoom Image
green 32 oz. 54-3132-044 $8.01 $6.09 24% Off $5.29 34% Off Email When In Stock
Add to Favorites
54805
Artista II Liquid Tempera Paint green 16 oz.
Zoom Image
green 16 oz. 54-3115-044 $4.49 $3.41 24% Off $2.96 34% Off Email When In Stock
Add to Favorites
27510
Artista II Liquid Tempera Paint magenta 32 oz.
Zoom Image
magenta 32 oz. 54-3132-069 $8.01 $6.09 24% Off $5.29 34% Off Email When In Stock
Add to Favorites
37819
Artista II Liquid Tempera Paint magenta 16 oz.
Zoom Image
magenta 16 oz. 54-3115-069 $4.49 $3.41 24% Off $2.96 34% Off Email When In Stock
Add to Favorites
49195
Artista II Liquid Tempera Paint orange 16 oz.
Zoom Image
orange 16 oz. 54-3115-036 $4.49 $3.41 24% Off $2.96 34% Off Email When In Stock
Add to Favorites
49833
Artista II Liquid Tempera Paint orange 32 oz.
Zoom Image
orange 32 oz. 54-3132-036 $8.01 $6.09 24% Off $5.29 34% Off Email When In Stock
Add to Favorites
46516
Artista II Liquid Tempera Paint red 16 oz.
Zoom Image
red 16 oz. 54-3115-038 $4.49 $3.41 24% Off $2.96 34% Off Email When In Stock
Add to Favorites
61574
Artista II Liquid Tempera Paint red 32 oz.
Zoom Image
red 32 oz. 54-3132-038 $8.01 $6.09 24% Off $5.29 34% Off Email When In Stock
Add to Favorites
57860
Artista II Liquid Tempera Paint turquoise 16 oz.
Zoom Image
turquoise 16 oz. 54-3115-048 $4.49 $3.41 24% Off $2.96 34% Off Email When In Stock
Add to Favorites
61757
Artista II Liquid Tempera Paint turquoise 32 oz.
Zoom Image
turquoise 32 oz. 54-3132-048 $8.01 $6.09 24% Off $5.29 34% Off Email When In Stock
Add to Favorites
37459
Artista II Liquid Tempera Paint violet 16 oz.
Zoom Image
violet 16 oz. 54-3115-040 $4.49 $3.41 24% Off $2.96 34% Off Email When In Stock
Add to Favorites
47240
Artista II Liquid Tempera Paint violet 32 oz.
Zoom Image
violet 32 oz. 54-3132-040 $8.01 $6.09 24% Off $5.29 34% Off Email When In Stock
Add to Favorites
21803
Artista II Liquid Tempera Paint white 16 oz.
Zoom Image
white 16 oz. 54-3115-053 $4.49 $3.41 24% Off $2.96 34% Off Email When In Stock
Add to Favorites
24195
Artista II Liquid Tempera Paint white 32 oz.
Zoom Image
white 32 oz. 54-3132-053 $8.01 $6.09 24% Off $5.29 34% Off Email When In Stock
Add to Favorites
45910
Artista II Liquid Tempera Paint yellow 32 oz.
Zoom Image
yellow 32 oz. 54-3132-034 $8.01 $6.09 24% Off $5.29 34% Off Email When In Stock
Add to Favorites
70380
Artista II Liquid Tempera Paint yellow 16 oz.
Zoom Image
yellow 16 oz. 54-3115-034 $4.49 $3.41 24% Off $2.96 34% Off Email When In Stock

Use color swatches as a general guide. Actual colors may vary.

Click the to add item to your Favorites.



Please wait...
You May Also Like...

Washable Paint

by Crayola

Make clean-up a breeze

From $3.58

Series 1121 Short Handled Round Camel...

by Crayola

Priced economically for student use

From $0.93

Canvas Boards

by Fredrix

Primed and ready

Up to 65% Off

How to get VIP Club Prices
Anyone can be a VIP Member with:
  • Additional savings on all products
  • Express order handling
  • Exclusive promotions
  • Priority customer service
Only $25/year

Learn More »

Product Questions and Answers

Ask a Question
Ask a Question

Would these be permanent on clothes? I'm Looking for a paint that washes off skin but stays on clothes.

- Asked by Danielle on 01-Jul-13
Answer

For your needs, you want to look at non-toxic acrylic paint, which can both touch skin and not wash off. We would recommend the Liquitex Basics acrylic colors for this purpose.

- Answered by MisterArt on 02-Jul-13

Ask a Question About Artista II Liquid Tempera Paint


Your email will not be shared. We will only use your email address to respond to your question. When asking your question, please be as descriptive as possible, it will allow us to give you the most accurate answer possible.

Customer Product Reviews
Write a Review
Write a Review
Rated by: Denise F. in Charlotte, NC
The paint was just what we needed. We had plenty and even had about half left over after 3 weeks of summer camp.
Rated by: P. T. in Louisville, KY
The order arrived quickly and everything was in perfect shape. Thanks Mister Art, we'll be back!
Rated by: David G. in Bonsall, CA
We were very happy with this paint, especially when it dripped on an upholstered chair and cleaned up with no stain at all.
Rated by: Carole H. in Berryville, VA
We painted a forest stage scene on a HUGE box from a patio set. What fun! The paint has been great; we really needed the larger sizes. Thank you for your great service, the products came very quickly.

Write a Product Review for Artista II Liquid Tempera Paint

Add Your Review

Tell us what you think. We appreciate you taking the time to share your opinion with other artists and crafters. Please keep your review detailed and specific.

Product reviews are intended to be a resource for artists interested in product quality and use. MisterArt.com reserves the right not to post any product review or to remove any published product review at any time without notice. Published reviews must conform to MisterArt.com guidelines. Your review may be posted on this page within five to ten business days.

Tips on Writing Reviews
Rating Scale
  • (5-Star) Excellent
  • (4-Star) Good
  • (3-Star) Average
  • (2-Star) Fair
  • (1-Star) Poor
Do:
  • Give your perspective on how you used the product and why you liked or disliked it.
  • Keep your reviews short enough to hold the audience's attention.
  • Be honest and mindful of others when providing editorial commentary.
Don't:
  • Include phone numbers, addresses, URLs, or HTML tags.
  • Write profanity, obscenities, vulgarities, or spiteful comments.
  • Make defamatory comments.
Please wait...
Please wait...