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

Portfolio Series Acrylic Paint

by Crayola


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

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

ItemIDList: 39905,75218
AvailQtyList: 15.000000000000,20.000000000000

struct
FLAGS 0
VIP_member_discount 25
barcode 071662195700
barcode_type UPC
col1 brilliant blue
col1_sortorder 753
col2 16 oz.
col2_sortorder 1008
col3 [empty string]
color_swatch 77-186-255.jpg
cost 5.66
deal_of_the_week NO
description brilliant blue, 16 oz.
group_id 7458
group_uname crayola-portfolio-series-acrylic-paint
id 35942
list_price 10.84
map NO
mfr_num 20-4016-570
net_weight 1.38
non_member_discount 15
non_member_price 9.21
prop65 NO
ship_rule_desc STD
shipping STD
sku 35942
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.5
ta_dealer_c_price 6.18
ta_price 9.21
text
array
1 35942
2 20-4016-570
3 brilliant blue, 16 oz.
timestamp 2015-03-30T16:20:15.536Z
vip_member_price 8.13

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 15.000000000000 39905
2 20.000000000000 75218
CACHED false
EXECUTIONTIME 169
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] = '1121' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.175.241

URL: www.misterart.com:/index.cfm:module=painting&catB=fb~crayola~fp~8-18~&gr=crayola-portfolio-series-acrylic-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 12:07:04'}
sessionid e0307eb8da8a5cdb86ff7e34793325b5a4b7
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=scales-rulers&CatD=fb~westcott~fp~0-23~&gr=westcott-metric-opaque-ruler.html
urltoken CFID=30518163&CFTOKEN=54315551&jsessionid=e0307eb8da8a5cdb86ff7e34793325b5a4b7
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 12:07:04'}
sessionid e0302dc915484d940981745e415361f7f5d4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~crayola~fp~8-18~&gr=crayola-portfolio-series-acrylic-paint.html
urltoken CFID=30518162&CFTOKEN=24623798&jsessionid=e0302dc915484d940981745e415361f7f5d4
validationerror [empty string]


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

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

ItemIDList: 39905,75218
AvailQtyList: 15.000000000000,20.000000000000

struct
FLAGS 0
VIP_member_discount 25
barcode 071662193812
barcode_type UPC
col1 brilliant blue purple
col1_sortorder 754
col2 16 oz.
col2_sortorder 1008
col3 [empty string]
color_swatch 77-120-255.jpg
cost 5.66
deal_of_the_week NO
description brilliant blue purple, 16 oz.
group_id 7458
group_uname crayola-portfolio-series-acrylic-paint
id 62297
list_price 10.84
map NO
mfr_num 20-4016-381
net_weight 1.38
non_member_discount 15
non_member_price 9.21
prop65 NO
ship_rule_desc STD
shipping STD
sku 62297
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.5
ta_dealer_c_price 6.18
ta_price 9.21
text
array
1 62297
2 20-4016-381
3 brilliant blue purple, 16 oz.
timestamp 2015-03-30T16:21:01.504Z
vip_member_price 8.13

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 15.000000000000 39905
2 20.000000000000 75218
CACHED false
EXECUTIONTIME 169
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] = '1121' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.175.241

URL: www.misterart.com:/index.cfm:module=painting&catB=fb~crayola~fp~8-18~&gr=crayola-portfolio-series-acrylic-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 12:07:04'}
sessionid e0307eb8da8a5cdb86ff7e34793325b5a4b7
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=scales-rulers&CatD=fb~westcott~fp~0-23~&gr=westcott-metric-opaque-ruler.html
urltoken CFID=30518163&CFTOKEN=54315551&jsessionid=e0307eb8da8a5cdb86ff7e34793325b5a4b7
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 12:07:04'}
sessionid e0302dc915484d940981745e415361f7f5d4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~crayola~fp~8-18~&gr=crayola-portfolio-series-acrylic-paint.html
urltoken CFID=30518162&CFTOKEN=24623798&jsessionid=e0302dc915484d940981745e415361f7f5d4
validationerror [empty string]


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

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

ItemIDList: 39905,75218
AvailQtyList: 15.000000000000,20.000000000000

struct
FLAGS 0
VIP_member_discount 25
barcode 071662197209
barcode_type UPC
col1 brilliant orange
col1_sortorder 759
col2 16 oz.
col2_sortorder 1008
col3 [empty string]
color_swatch 240-157-92.jpg
cost 5.66
deal_of_the_week NO
description brilliant orange, 16 oz.
group_id 7458
group_uname crayola-portfolio-series-acrylic-paint
id 57405
list_price 10.84
map NO
mfr_num 20-4016-720
net_weight 1.38
non_member_discount 15
non_member_price 9.21
prop65 NO
ship_rule_desc STD
shipping STD
sku 57405
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.5
ta_dealer_c_price 6.18
ta_price 9.21
text
array
1 57405
2 20-4016-720
3 brilliant orange, 16 oz.
timestamp 2015-03-30T16:20:49.755Z
vip_member_price 8.13

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 15.000000000000 39905
2 20.000000000000 75218
CACHED false
EXECUTIONTIME 169
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] = '1121' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.175.241

URL: www.misterart.com:/index.cfm:module=painting&catB=fb~crayola~fp~8-18~&gr=crayola-portfolio-series-acrylic-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 12:07:04'}
sessionid e0307eb8da8a5cdb86ff7e34793325b5a4b7
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=scales-rulers&CatD=fb~westcott~fp~0-23~&gr=westcott-metric-opaque-ruler.html
urltoken CFID=30518163&CFTOKEN=54315551&jsessionid=e0307eb8da8a5cdb86ff7e34793325b5a4b7
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 12:07:04'}
sessionid e0302dc915484d940981745e415361f7f5d4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~crayola~fp~8-18~&gr=crayola-portfolio-series-acrylic-paint.html
urltoken CFID=30518162&CFTOKEN=24623798&jsessionid=e0302dc915484d940981745e415361f7f5d4
validationerror [empty string]


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

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

ItemIDList: 39905,75218
AvailQtyList: 15.000000000000,20.000000000000

struct
FLAGS 0
VIP_member_discount 25
barcode 071662198305
barcode_type UPC
col1 brilliant yellow
col1_sortorder 772
col2 16 oz.
col2_sortorder 1008
col3 [empty string]
color_swatch 240-240-47.jpg
cost 5.66
deal_of_the_week NO
description brilliant yellow, 16 oz.
group_id 7458
group_uname crayola-portfolio-series-acrylic-paint
id 31961
list_price 10.84
map NO
mfr_num 20-4016-830
net_weight 1.38
non_member_discount 15
non_member_price 9.21
prop65 NO
ship_rule_desc STD
shipping STD
sku 31961
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.5
ta_dealer_c_price 6.18
ta_price 9.21
text
array
1 31961
2 20-4016-830
3 brilliant yellow, 16 oz.
timestamp 2015-03-30T16:20:01.95Z
vip_member_price 8.13

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 15.000000000000 39905
2 20.000000000000 75218
CACHED false
EXECUTIONTIME 169
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] = '1121' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.175.241

URL: www.misterart.com:/index.cfm:module=painting&catB=fb~crayola~fp~8-18~&gr=crayola-portfolio-series-acrylic-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 12:07:04'}
sessionid e0307eb8da8a5cdb86ff7e34793325b5a4b7
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=scales-rulers&CatD=fb~westcott~fp~0-23~&gr=westcott-metric-opaque-ruler.html
urltoken CFID=30518163&CFTOKEN=54315551&jsessionid=e0307eb8da8a5cdb86ff7e34793325b5a4b7
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 12:07:04'}
sessionid e0302dc915484d940981745e415361f7f5d4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~crayola~fp~8-18~&gr=crayola-portfolio-series-acrylic-paint.html
urltoken CFID=30518162&CFTOKEN=24623798&jsessionid=e0302dc915484d940981745e415361f7f5d4
validationerror [empty string]


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

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

ItemIDList: 39905,75218
AvailQtyList: 15.000000000000,20.000000000000

struct
FLAGS 0
VIP_member_discount 25
barcode 071662195304
barcode_type UPC
col1 bronze yellow
col1_sortorder 797
col2 16 oz.
col2_sortorder 1008
col3 [empty string]
color_swatch 240-209-92.jpg
cost 5.66
deal_of_the_week NO
description bronze yellow, 16 oz.
group_id 7458
group_uname crayola-portfolio-series-acrylic-paint
id 52841
list_price 10.84
map NO
mfr_num 20-4016-530
net_weight 1.38
non_member_discount 15
non_member_price 9.21
prop65 NO
ship_rule_desc STD
shipping STD
sku 52841
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.5
ta_dealer_c_price 6.18
ta_price 9.21
text
array
1 52841
2 20-4016-530
3 bronze yellow, 16 oz.
timestamp 2015-03-30T16:20:45.501Z
vip_member_price 8.13

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 15.000000000000 39905
2 20.000000000000 75218
CACHED false
EXECUTIONTIME 169
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] = '1121' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.175.241

URL: www.misterart.com:/index.cfm:module=painting&catB=fb~crayola~fp~8-18~&gr=crayola-portfolio-series-acrylic-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 12:07:04'}
sessionid e0307eb8da8a5cdb86ff7e34793325b5a4b7
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=scales-rulers&CatD=fb~westcott~fp~0-23~&gr=westcott-metric-opaque-ruler.html
urltoken CFID=30518163&CFTOKEN=54315551&jsessionid=e0307eb8da8a5cdb86ff7e34793325b5a4b7
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 12:07:04'}
sessionid e0302dc915484d940981745e415361f7f5d4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~crayola~fp~8-18~&gr=crayola-portfolio-series-acrylic-paint.html
urltoken CFID=30518162&CFTOKEN=24623798&jsessionid=e0302dc915484d940981745e415361f7f5d4
validationerror [empty string]


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

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

ItemIDList: 39905,75218
AvailQtyList: 15.000000000000,20.000000000000

struct
FLAGS 0
VIP_member_discount 25
barcode 071662191276
barcode_type UPC
col1 burnt sienna
col1_sortorder 876
col2 16 oz.
col2_sortorder 1008
col3 [empty string]
color_swatch 149-92-47.jpg
cost 5.66
deal_of_the_week NO
description burnt sienna, 16 oz.
group_id 7458
group_uname crayola-portfolio-series-acrylic-paint
id 27986
list_price 10.84
map NO
mfr_num 20-4016-127
net_weight 1.38
non_member_discount 15
non_member_price 9.21
prop65 NO
ship_rule_desc STD
shipping STD
sku 27986
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.5
ta_dealer_c_price 6.18
ta_price 9.21
text
array
1 27986
2 20-4016-127
3 burnt sienna, 16 oz.
timestamp 2015-03-30T16:19:52.924Z
vip_member_price 8.13

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 15.000000000000 39905
2 20.000000000000 75218
CACHED false
EXECUTIONTIME 169
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] = '1121' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.175.241

URL: www.misterart.com:/index.cfm:module=painting&catB=fb~crayola~fp~8-18~&gr=crayola-portfolio-series-acrylic-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 12:07:04'}
sessionid e0307eb8da8a5cdb86ff7e34793325b5a4b7
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=scales-rulers&CatD=fb~westcott~fp~0-23~&gr=westcott-metric-opaque-ruler.html
urltoken CFID=30518163&CFTOKEN=54315551&jsessionid=e0307eb8da8a5cdb86ff7e34793325b5a4b7
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 12:07:04'}
sessionid e0302dc915484d940981745e415361f7f5d4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~crayola~fp~8-18~&gr=crayola-portfolio-series-acrylic-paint.html
urltoken CFID=30518162&CFTOKEN=24623798&jsessionid=e0302dc915484d940981745e415361f7f5d4
validationerror [empty string]


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

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

ItemIDList: 39905,75218
AvailQtyList: 15.000000000000,20.000000000000

struct
FLAGS 0
VIP_member_discount 25
barcode 071662191283
barcode_type UPC
col1 burnt umber
col1_sortorder 887
col2 16 oz.
col2_sortorder 1008
col3 [empty string]
color_swatch 119-60-0.jpg
cost 5.66
deal_of_the_week NO
description burnt umber, 16 oz.
group_id 7458
group_uname crayola-portfolio-series-acrylic-paint
id 89786
list_price 10.84
map NO
mfr_num 20-4016-128
net_weight 1.38
non_member_discount 15
non_member_price 9.21
prop65 NO
ship_rule_desc STD
shipping STD
sku 89786
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.5
ta_dealer_c_price 6.18
ta_price 9.21
text
array
1 89786
2 20-4016-128
3 burnt umber, 16 oz.
timestamp 2015-03-30T16:22:02.612Z
vip_member_price 8.13

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 15.000000000000 39905
2 20.000000000000 75218
CACHED false
EXECUTIONTIME 169
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] = '1121' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.175.241

URL: www.misterart.com:/index.cfm:module=painting&catB=fb~crayola~fp~8-18~&gr=crayola-portfolio-series-acrylic-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 12:07:04'}
sessionid e0307eb8da8a5cdb86ff7e34793325b5a4b7
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=scales-rulers&CatD=fb~westcott~fp~0-23~&gr=westcott-metric-opaque-ruler.html
urltoken CFID=30518163&CFTOKEN=54315551&jsessionid=e0307eb8da8a5cdb86ff7e34793325b5a4b7
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 12:07:04'}
sessionid e0302dc915484d940981745e415361f7f5d4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~crayola~fp~8-18~&gr=crayola-portfolio-series-acrylic-paint.html
urltoken CFID=30518162&CFTOKEN=24623798&jsessionid=e0302dc915484d940981745e415361f7f5d4
validationerror [empty string]


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

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

ItemIDList: 39905,75218
AvailQtyList: 15.000000000000,20.000000000000

struct
FLAGS 0
VIP_member_discount 25
barcode 071662193003
barcode_type UPC
col1 deep magenta
col1_sortorder 1821
col2 16 oz.
col2_sortorder 1008
col3 [empty string]
color_swatch 195-47-195.jpg
cost 5.66
deal_of_the_week NO
description deep magenta, 16 oz.
group_id 7458
group_uname crayola-portfolio-series-acrylic-paint
id 62296
list_price 10.84
map NO
mfr_num 20-4016-300
net_weight 1.38
non_member_discount 15
non_member_price 9.21
prop65 NO
ship_rule_desc STD
shipping STD
sku 62296
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.5
ta_dealer_c_price 6.18
ta_price 9.21
text
array
1 62296
2 20-4016-300
3 deep magenta, 16 oz.
timestamp 2015-03-30T16:21:01.498Z
vip_member_price 8.13

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 15.000000000000 39905
2 20.000000000000 75218
CACHED false
EXECUTIONTIME 169
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] = '1121' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.175.241

URL: www.misterart.com:/index.cfm:module=painting&catB=fb~crayola~fp~8-18~&gr=crayola-portfolio-series-acrylic-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 12:07:04'}
sessionid e0307eb8da8a5cdb86ff7e34793325b5a4b7
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=scales-rulers&CatD=fb~westcott~fp~0-23~&gr=westcott-metric-opaque-ruler.html
urltoken CFID=30518163&CFTOKEN=54315551&jsessionid=e0307eb8da8a5cdb86ff7e34793325b5a4b7
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 12:07:04'}
sessionid e0302dc915484d940981745e415361f7f5d4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~crayola~fp~8-18~&gr=crayola-portfolio-series-acrylic-paint.html
urltoken CFID=30518162&CFTOKEN=24623798&jsessionid=e0302dc915484d940981745e415361f7f5d4
validationerror [empty string]


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

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

ItemIDList: 39905,75218
AvailQtyList: 15.000000000000,20.000000000000

struct
FLAGS 0
VIP_member_discount 25
barcode 071662191153
barcode_type UPC
col1 deep red
col1_sortorder 1829
col2 16 oz.
col2_sortorder 1008
col3 [empty string]
color_swatch 195-47-80.jpg
cost 5.66
deal_of_the_week NO
description deep red, 16 oz.
group_id 7458
group_uname crayola-portfolio-series-acrylic-paint
id 14188
list_price 10.84
map NO
mfr_num 20-4016-115
net_weight 1.38
non_member_discount 15
non_member_price 9.21
prop65 NO
ship_rule_desc STD
shipping STD
sku 14188
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.5
ta_dealer_c_price 6.18
ta_price 9.21
text
array
1 14188
2 20-4016-115
3 deep red, 16 oz.
timestamp 2015-03-30T16:19:24.284Z
vip_member_price 8.13

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 15.000000000000 39905
2 20.000000000000 75218
CACHED false
EXECUTIONTIME 169
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] = '1121' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.175.241

URL: www.misterart.com:/index.cfm:module=painting&catB=fb~crayola~fp~8-18~&gr=crayola-portfolio-series-acrylic-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 12:07:04'}
sessionid e0307eb8da8a5cdb86ff7e34793325b5a4b7
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=scales-rulers&CatD=fb~westcott~fp~0-23~&gr=westcott-metric-opaque-ruler.html
urltoken CFID=30518163&CFTOKEN=54315551&jsessionid=e0307eb8da8a5cdb86ff7e34793325b5a4b7
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 12:07:04'}
sessionid e0302dc915484d940981745e415361f7f5d4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~crayola~fp~8-18~&gr=crayola-portfolio-series-acrylic-paint.html
urltoken CFID=30518162&CFTOKEN=24623798&jsessionid=e0302dc915484d940981745e415361f7f5d4
validationerror [empty string]


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

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

ItemIDList: 39905,75218
AvailQtyList: 15.000000000000,20.000000000000

struct
FLAGS 0
VIP_member_discount 25
barcode 071662192440
barcode_type UPC
col1 ivory black
col1_sortorder 3126
col2 16 oz.
col2_sortorder 1008
col3 [empty string]
color_swatch 0-0-0.jpg
cost 5.66
deal_of_the_week NO
description ivory black, 16 oz.
group_id 7458
group_uname crayola-portfolio-series-acrylic-paint
id 22309
list_price 10.84
map NO
mfr_num 20-4016-244
net_weight 1.38
non_member_discount 15
non_member_price 9.21
prop65 NO
ship_rule_desc STD
shipping STD
sku 22309
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.5
ta_dealer_c_price 6.18
ta_price 9.21
text
array
1 22309
2 20-4016-244
3 ivory black, 16 oz.
timestamp 2015-03-30T16:19:43.062Z
vip_member_price 8.13

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 15.000000000000 39905
2 20.000000000000 75218
CACHED false
EXECUTIONTIME 169
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] = '1121' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.175.241

URL: www.misterart.com:/index.cfm:module=painting&catB=fb~crayola~fp~8-18~&gr=crayola-portfolio-series-acrylic-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 12:07:04'}
sessionid e0307eb8da8a5cdb86ff7e34793325b5a4b7
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=scales-rulers&CatD=fb~westcott~fp~0-23~&gr=westcott-metric-opaque-ruler.html
urltoken CFID=30518163&CFTOKEN=54315551&jsessionid=e0307eb8da8a5cdb86ff7e34793325b5a4b7
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 12:07:04'}
sessionid e0302dc915484d940981745e415361f7f5d4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~crayola~fp~8-18~&gr=crayola-portfolio-series-acrylic-paint.html
urltoken CFID=30518162&CFTOKEN=24623798&jsessionid=e0302dc915484d940981745e415361f7f5d4
validationerror [empty string]


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

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

ItemIDList: 39905,75218
AvailQtyList: 15.000000000000,20.000000000000

struct
FLAGS 0
VIP_member_discount 25
barcode 071662193133
barcode_type UPC
col1 light green
col1_sortorder 3353
col2 16 oz.
col2_sortorder 1008
col3 [empty string]
color_swatch 47-195-47.jpg
cost 5.66
deal_of_the_week NO
description light green, 16 oz.
group_id 7458
group_uname crayola-portfolio-series-acrylic-paint
id 62295
list_price 10.84
map NO
mfr_num 20-4016-313
net_weight 1.38
non_member_discount 15
non_member_price 9.21
prop65 NO
ship_rule_desc STD
shipping STD
sku 62295
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.5
ta_dealer_c_price 6.18
ta_price 9.21
text
array
1 62295
2 20-4016-313
3 light green, 16 oz.
timestamp 2015-03-30T16:21:01.486Z
vip_member_price 8.13

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 15.000000000000 39905
2 20.000000000000 75218
CACHED false
EXECUTIONTIME 169
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] = '1121' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.175.241

URL: www.misterart.com:/index.cfm:module=painting&catB=fb~crayola~fp~8-18~&gr=crayola-portfolio-series-acrylic-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 12:07:04'}
sessionid e0307eb8da8a5cdb86ff7e34793325b5a4b7
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=scales-rulers&CatD=fb~westcott~fp~0-23~&gr=westcott-metric-opaque-ruler.html
urltoken CFID=30518163&CFTOKEN=54315551&jsessionid=e0307eb8da8a5cdb86ff7e34793325b5a4b7
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 12:07:04'}
sessionid e0302dc915484d940981745e415361f7f5d4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~crayola~fp~8-18~&gr=crayola-portfolio-series-acrylic-paint.html
urltoken CFID=30518162&CFTOKEN=24623798&jsessionid=e0302dc915484d940981745e415361f7f5d4
validationerror [empty string]


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

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

ItemIDList: 39905,75218
AvailQtyList: 15.000000000000,20.000000000000

struct
FLAGS 0
VIP_member_discount 25
barcode 071662191139
barcode_type UPC
col1 light red
col1_sortorder 3402
col2 16 oz.
col2_sortorder 1008
col3 [empty string]
color_swatch 240-120-92.jpg
cost 5.66
deal_of_the_week NO
description light red, 16 oz.
group_id 7458
group_uname crayola-portfolio-series-acrylic-paint
id 62293
list_price 10.84
map NO
mfr_num 20-4016-113
net_weight 1.38
non_member_discount 15
non_member_price 9.21
prop65 NO
ship_rule_desc STD
shipping STD
sku 62293
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.5
ta_dealer_c_price 6.18
ta_price 9.21
text
array
1 62293
2 20-4016-113
3 light red, 16 oz.
timestamp 2015-03-30T16:21:01.478Z
vip_member_price 8.13

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 15.000000000000 39905
2 20.000000000000 75218
CACHED false
EXECUTIONTIME 169
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] = '1121' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.175.241

URL: www.misterart.com:/index.cfm:module=painting&catB=fb~crayola~fp~8-18~&gr=crayola-portfolio-series-acrylic-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 12:07:04'}
sessionid e0307eb8da8a5cdb86ff7e34793325b5a4b7
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=scales-rulers&CatD=fb~westcott~fp~0-23~&gr=westcott-metric-opaque-ruler.html
urltoken CFID=30518163&CFTOKEN=54315551&jsessionid=e0307eb8da8a5cdb86ff7e34793325b5a4b7
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 12:07:04'}
sessionid e0302dc915484d940981745e415361f7f5d4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~crayola~fp~8-18~&gr=crayola-portfolio-series-acrylic-paint.html
urltoken CFID=30518162&CFTOKEN=24623798&jsessionid=e0302dc915484d940981745e415361f7f5d4
validationerror [empty string]


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

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

ItemIDList: 39905,75218
AvailQtyList: 15.000000000000,20.000000000000

struct
FLAGS 0
VIP_member_discount 25
barcode 071662193164
barcode_type UPC
col1 phthalo blue
col1_sortorder 4660
col2 16 oz.
col2_sortorder 1008
col3 [empty string]
color_swatch 77-98-164.jpg
cost 5.66
deal_of_the_week NO
description phthalo blue, 16 oz.
group_id 7458
group_uname crayola-portfolio-series-acrylic-paint
id 15628
list_price 10.84
map NO
mfr_num 20-4016-316
net_weight 1.38
non_member_discount 15
non_member_price 9.21
prop65 NO
ship_rule_desc STD
shipping STD
sku 15628
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.5
ta_dealer_c_price 6.18
ta_price 9.21
text
array
1 15628
2 20-4016-316
3 phthalo blue, 16 oz.
timestamp 2015-03-30T16:19:31.153Z
vip_member_price 8.13

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 15.000000000000 39905
2 20.000000000000 75218
CACHED false
EXECUTIONTIME 169
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] = '1121' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.175.241

URL: www.misterart.com:/index.cfm:module=painting&catB=fb~crayola~fp~8-18~&gr=crayola-portfolio-series-acrylic-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 12:07:04'}
sessionid e0307eb8da8a5cdb86ff7e34793325b5a4b7
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=scales-rulers&CatD=fb~westcott~fp~0-23~&gr=westcott-metric-opaque-ruler.html
urltoken CFID=30518163&CFTOKEN=54315551&jsessionid=e0307eb8da8a5cdb86ff7e34793325b5a4b7
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 12:07:04'}
sessionid e0302dc915484d940981745e415361f7f5d4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~crayola~fp~8-18~&gr=crayola-portfolio-series-acrylic-paint.html
urltoken CFID=30518162&CFTOKEN=24623798&jsessionid=e0302dc915484d940981745e415361f7f5d4
validationerror [empty string]


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

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

ItemIDList: 39905,75218
AvailQtyList: 15.000000000000,20.000000000000

struct
FLAGS 0
VIP_member_discount 25
barcode 071662193171
barcode_type UPC
col1 phthalo green
col1_sortorder 4679
col2 16 oz.
col2_sortorder 1008
col3 [empty string]
color_swatch 47-149-117.jpg
cost 5.66
deal_of_the_week NO
description phthalo green, 16 oz.
group_id 7458
group_uname crayola-portfolio-series-acrylic-paint
id 62287
list_price 10.84
map NO
mfr_num 20-4016-317
net_weight 1.38
non_member_discount 15
non_member_price 9.21
prop65 NO
ship_rule_desc STD
shipping STD
sku 62287
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.5
ta_dealer_c_price 6.18
ta_price 9.21
text
array
1 62287
2 20-4016-317
3 phthalo green, 16 oz.
timestamp 2015-03-30T16:21:01.464Z
vip_member_price 8.13

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 15.000000000000 39905
2 20.000000000000 75218
CACHED false
EXECUTIONTIME 169
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] = '1121' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.175.241

URL: www.misterart.com:/index.cfm:module=painting&catB=fb~crayola~fp~8-18~&gr=crayola-portfolio-series-acrylic-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 12:07:04'}
sessionid e0307eb8da8a5cdb86ff7e34793325b5a4b7
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=scales-rulers&CatD=fb~westcott~fp~0-23~&gr=westcott-metric-opaque-ruler.html
urltoken CFID=30518163&CFTOKEN=54315551&jsessionid=e0307eb8da8a5cdb86ff7e34793325b5a4b7
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 12:07:04'}
sessionid e0302dc915484d940981745e415361f7f5d4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~crayola~fp~8-18~&gr=crayola-portfolio-series-acrylic-paint.html
urltoken CFID=30518162&CFTOKEN=24623798&jsessionid=e0302dc915484d940981745e415361f7f5d4
validationerror [empty string]


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

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

ItemIDList: 39905,75218
AvailQtyList: 15.000000000000,20.000000000000

struct
FLAGS 0
VIP_member_discount 25
barcode 071662194321
barcode_type UPC
col1 titanium white
col1_sortorder 6034
col2 16 oz.
col2_sortorder 1008
col3 [empty string]
color_swatch 255-255-255.jpg
cost 5.66
deal_of_the_week NO
description titanium white, 16 oz.
group_id 7458
group_uname crayola-portfolio-series-acrylic-paint
id 49629
list_price 10.84
map NO
mfr_num 20-4016-432
net_weight 1.38
non_member_discount 15
non_member_price 9.21
prop65 NO
ship_rule_desc STD
shipping STD
sku 49629
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.5
ta_dealer_c_price 6.18
ta_price 9.21
text
array
1 49629
2 20-4016-432
3 titanium white, 16 oz.
timestamp 2015-03-30T16:20:37.377Z
vip_member_price 8.13

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 15.000000000000 39905
2 20.000000000000 75218
CACHED false
EXECUTIONTIME 169
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] = '1121' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.175.241

URL: www.misterart.com:/index.cfm:module=painting&catB=fb~crayola~fp~8-18~&gr=crayola-portfolio-series-acrylic-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 12:07:04'}
sessionid e0307eb8da8a5cdb86ff7e34793325b5a4b7
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=scales-rulers&CatD=fb~westcott~fp~0-23~&gr=westcott-metric-opaque-ruler.html
urltoken CFID=30518163&CFTOKEN=54315551&jsessionid=e0307eb8da8a5cdb86ff7e34793325b5a4b7
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 12:07:04'}
sessionid e0302dc915484d940981745e415361f7f5d4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~crayola~fp~8-18~&gr=crayola-portfolio-series-acrylic-paint.html
urltoken CFID=30518162&CFTOKEN=24623798&jsessionid=e0302dc915484d940981745e415361f7f5d4
validationerror [empty string]


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

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

ItemIDList: 39905,75218
AvailQtyList: 15.000000000000,20.000000000000

struct
FLAGS 0
VIP_member_discount 25
barcode 071662197308
barcode_type UPC
col1 Turner's yellow
col1_sortorder 6213
col2 16 oz.
col2_sortorder 1008
col3 [empty string]
color_swatch 240-226-47.jpg
cost 5.66
deal_of_the_week NO
description Turner's yellow, 16 oz.
group_id 7458
group_uname crayola-portfolio-series-acrylic-paint
id 62286
list_price 10.84
map NO
mfr_num 20-4016-730
net_weight 1.38
non_member_discount 15
non_member_price 9.21
prop65 NO
ship_rule_desc STD
shipping STD
sku 62286
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.5
ta_dealer_c_price 6.18
ta_price 9.21
text
array
1 62286
2 20-4016-730
3 Turner's yellow, 16 oz.
timestamp 2015-03-30T16:21:01.45Z
vip_member_price 8.13

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 15.000000000000 39905
2 20.000000000000 75218
CACHED false
EXECUTIONTIME 169
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] = '1121' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.175.241

URL: www.misterart.com:/index.cfm:module=painting&catB=fb~crayola~fp~8-18~&gr=crayola-portfolio-series-acrylic-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 12:07:04'}
sessionid e0307eb8da8a5cdb86ff7e34793325b5a4b7
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=scales-rulers&CatD=fb~westcott~fp~0-23~&gr=westcott-metric-opaque-ruler.html
urltoken CFID=30518163&CFTOKEN=54315551&jsessionid=e0307eb8da8a5cdb86ff7e34793325b5a4b7
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 12:07:04'}
sessionid e0302dc915484d940981745e415361f7f5d4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~crayola~fp~8-18~&gr=crayola-portfolio-series-acrylic-paint.html
urltoken CFID=30518162&CFTOKEN=24623798&jsessionid=e0302dc915484d940981745e415361f7f5d4
validationerror [empty string]


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

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

ItemIDList: 39905,75218
AvailQtyList: 15.000000000000,20.000000000000

struct
FLAGS 0
VIP_member_discount 25
barcode 071662191863
barcode_type UPC
col1 violet
col1_sortorder 6409
col2 16 oz.
col2_sortorder 1008
col3 [empty string]
color_swatch 185-77-210.jpg
cost 5.66
deal_of_the_week NO
description violet, 16 oz.
group_id 7458
group_uname crayola-portfolio-series-acrylic-paint
id 62285
list_price 10.84
map NO
mfr_num 20-4016-186
net_weight 1.38
non_member_discount 15
non_member_price 9.21
prop65 NO
ship_rule_desc STD
shipping STD
sku 62285
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.5
ta_dealer_c_price 6.18
ta_price 9.21
text
array
1 62285
2 20-4016-186
3 violet, 16 oz.
timestamp 2015-03-30T16:21:01.448Z
vip_member_price 8.13

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 15.000000000000 39905
2 20.000000000000 75218
CACHED false
EXECUTIONTIME 169
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] = '1121' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.175.241

URL: www.misterart.com:/index.cfm:module=painting&catB=fb~crayola~fp~8-18~&gr=crayola-portfolio-series-acrylic-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 12:07:04'}
sessionid e0307eb8da8a5cdb86ff7e34793325b5a4b7
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=scales-rulers&CatD=fb~westcott~fp~0-23~&gr=westcott-metric-opaque-ruler.html
urltoken CFID=30518163&CFTOKEN=54315551&jsessionid=e0307eb8da8a5cdb86ff7e34793325b5a4b7
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 12:07:04'}
sessionid e0302dc915484d940981745e415361f7f5d4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~crayola~fp~8-18~&gr=crayola-portfolio-series-acrylic-paint.html
urltoken CFID=30518162&CFTOKEN=24623798&jsessionid=e0302dc915484d940981745e415361f7f5d4
validationerror [empty string]


Portfolio Series Acrylics are ideal for the student artist for acrylic painting and applications as varied as airbrushing, printmaking, and marbling, without chemical additives. The vivid colors are rich in pigment, and they have a thick, tube-like viscosity. Can be diluted 8 to 1 for watercolor techniques without losing intensity. Portfolio Series Acrylics adhere permanently to paper, wood, fabric, and clay. They dry to a flexible water-resistant finish. Clean up is easy - just rinse with soap and water. Plastic recyclable bottles with flip-top lids.

Portfolio Series Acrylic Paint is available in 16 oz. bottles.



Share on Facebook Twitter Pinterest

Ask a question about Portfolio Series Acrylic Paint Ask a question about this product

Portfolio Series Acrylic Paint

by Crayola

Average User Rating: Based on (7 Reviews)

5 7

Edgewood Mom from Edgewood, WA says:

I bought several colors of this paint for my daughter. She is 16 and very artistic. She has created some beautiful works of art with this paint. She likes it because it is thick and easy to work with.

[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
35942
Portfolio Series Acrylic Paint brilliant blue 16 oz.
Zoom Image
brilliant blue 16 oz. 20-4016-570 $10.84 $9.21 15% Off $8.13 25% Off Email When In Stock
Add to Favorites
62297
Portfolio Series Acrylic Paint brilliant blue purple 16 oz.
Zoom Image
brilliant blue purple 16 oz. 20-4016-381 $10.84 $9.21 15% Off $8.13 25% Off Email When In Stock
Add to Favorites
57405
Portfolio Series Acrylic Paint brilliant orange 16 oz.
Zoom Image
brilliant orange 16 oz. 20-4016-720 $10.84 $9.21 15% Off $8.13 25% Off Email When In Stock
Add to Favorites
31961
Portfolio Series Acrylic Paint brilliant yellow 16 oz.
Zoom Image
brilliant yellow 16 oz. 20-4016-830 $10.84 $9.21 15% Off $8.13 25% Off Email When In Stock
Add to Favorites
52841
Portfolio Series Acrylic Paint bronze yellow 16 oz.
Zoom Image
bronze yellow 16 oz. 20-4016-530 $10.84 $9.21 15% Off $8.13 25% Off Email When In Stock
Add to Favorites
27986
Portfolio Series Acrylic Paint burnt sienna 16 oz.
Zoom Image
burnt sienna 16 oz. 20-4016-127 $10.84 $9.21 15% Off $8.13 25% Off Email When In Stock
Add to Favorites
89786
Portfolio Series Acrylic Paint burnt umber 16 oz.
Zoom Image
burnt umber 16 oz. 20-4016-128 $10.84 $9.21 15% Off $8.13 25% Off Email When In Stock
Add to Favorites
62296
Portfolio Series Acrylic Paint deep magenta 16 oz.
Zoom Image
deep magenta 16 oz. 20-4016-300 $10.84 $9.21 15% Off $8.13 25% Off Email When In Stock
Add to Favorites
14188
Portfolio Series Acrylic Paint deep red 16 oz.
Zoom Image
deep red 16 oz. 20-4016-115 $10.84 $9.21 15% Off $8.13 25% Off Email When In Stock
Add to Favorites
22309
Portfolio Series Acrylic Paint ivory black 16 oz.
Zoom Image
ivory black 16 oz. 20-4016-244 $10.84 $9.21 15% Off $8.13 25% Off Email When In Stock
Add to Favorites
62295
Portfolio Series Acrylic Paint light green 16 oz.
Zoom Image
light green 16 oz. 20-4016-313 $10.84 $9.21 15% Off $8.13 25% Off Email When In Stock
Add to Favorites
62293
Portfolio Series Acrylic Paint light red 16 oz.
Zoom Image
light red 16 oz. 20-4016-113 $10.84 $9.21 15% Off $8.13 25% Off Email When In Stock
Add to Favorites
15628
Portfolio Series Acrylic Paint phthalo blue 16 oz.
Zoom Image
phthalo blue 16 oz. 20-4016-316 $10.84 $9.21 15% Off $8.13 25% Off Email When In Stock
Add to Favorites
62287
Portfolio Series Acrylic Paint phthalo green 16 oz.
Zoom Image
phthalo green 16 oz. 20-4016-317 $10.84 $9.21 15% Off $8.13 25% Off Email When In Stock
Add to Favorites
49629
Portfolio Series Acrylic Paint titanium white 16 oz.
Zoom Image
titanium white 16 oz. 20-4016-432 $10.84 $9.21 15% Off $8.13 25% Off Email When In Stock
Add to Favorites
62286
Portfolio Series Acrylic Paint Turner's yellow 16 oz.
Zoom Image
Turner's yellow 16 oz. 20-4016-730 $10.84 $9.21 15% Off $8.13 25% Off Email When In Stock
Add to Favorites
62285
Portfolio Series Acrylic Paint violet 16 oz.
Zoom Image
violet 16 oz. 20-4016-186 $10.84 $9.21 15% Off $8.13 25% 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...

Red Label Stretched Cotton Canvas

by Fredrix

Medium texture pre-stretched canvas is an artist favorite

Up to 65% Off

Basics Acrylics Colors

by Liquitex

High quality, affordable acrylic paint

Up to 49% Off

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 »

Ask a Question About Portfolio Series Acrylic 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: Edgewood Mom in Edgewood, WA
I bought several colors of this paint for my daughter. She is 16 and very artistic. She has created some beautiful works of art with this paint. She likes it because it is thick and easy to work with.
Rated by: Melissa C. in Lafayette, LA
Affordable and great quality for student use.
Rated by: Tom M. in Lubbock, TX
Vibrant, lasting color that's affordable.
Rated by: Greg K. in Soap Lake, WA
Misterart.com did a wonderful job delivering my order. They were fast and courteous. I would encourage anybody to use them. I will definitely use them in the future.
Rated by: Jaquey G. in Plumas Lake, CA
I love working with this paint. The colours when dry are beautifully vibrant, and easy to work with.
Rated by: Angela C. in Pelham, AL
I really like this product because it cleans up so well, but when it's dry it's water resistent. Perfect!
Rated by: sheila e. in fort myers beach, FL
Great for the faux finisher looking for alternatives to metallic paint. Highly concentrated, not liquid, but more of a fine artist acrylic. needs water to dilute. can be used in plaster effects as well. a litle goes a long way.

Write a Product Review for Portfolio Series Acrylic 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...