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

Progresso Woodless Colour Pencils

by Koh-I-Noor


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

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

ItemIDList: 49080
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 36
barcode 8593539136064
barcode_type EAN
col1 assorted
col1_sortorder 222
col2 set of 24
col2_sortorder 647
col3 [empty string]
cost 9.98
deal_of_the_week NO
description assorted, set of 24
group_id 3439
group_uname koh-i-noor-progresso-woodless-colour-pencils
id 55386
list_price 21.8
map NO
mfr_num FA8758.24
net_weight 0.8
non_member_discount 26
non_member_price 16.13
prop65 NO
ship_rule_desc STD
shipping STD
sku 55386
sku_pix YES
supplier_id 1
ta_dealer_a_price 10.9
ta_dealer_c_price 10.9
ta_price 17.44
text
array
1 55386
2 FA8758.24
3 assorted, set of 24
timestamp 2015-04-01T21:26:32.701Z
vip_member_price 13.95

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 49080
CACHED false
EXECUTIONTIME 1
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] = '5020' 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.163.190.170

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=fp~5-7~&gr=koh-i-noor-progresso-woodless-colour-pencils.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:48:36'}
sessionid e030e309b63319aca2ce5d3b6c5762c1d6c2
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=fp~2-6~&gr=dover-how-to-draw-pets.html
urltoken CFID=30896318&CFTOKEN=78747232&jsessionid=e030e309b63319aca2ce5d3b6c5762c1d6c2
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:48:36'}
sessionid e030a7b4dd27ff47d60c3f5223576e4d3b27
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=fp~5-7~&gr=koh-i-noor-progresso-woodless-colour-pencils.html
urltoken CFID=30896319&CFTOKEN=83921713&jsessionid=e030a7b4dd27ff47d60c3f5223576e4d3b27
validationerror [empty string]


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

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

ItemIDList: 49080
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 36
barcode 8593539136057
barcode_type EAN
col1 assorted
col1_sortorder 222
col2 set of 12
col2_sortorder 634
col3 [empty string]
cost 4.78
deal_of_the_week NO
description assorted, set of 12
group_id 3439
group_uname koh-i-noor-progresso-woodless-colour-pencils
id 82524
list_price 10.45
map NO
mfr_num FA8756.12
net_weight 0.4
non_member_discount 26
non_member_price 7.73
prop65 NO
ship_rule_desc STD
shipping STD
sku 82524
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.23
ta_dealer_c_price 5.23
ta_price 8.36
text
array
1 82524
2 FA8756.12
3 assorted, set of 12
timestamp 2015-04-01T21:27:21.858Z
vip_member_price 6.69

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 49080
CACHED false
EXECUTIONTIME 1
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] = '5020' 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.163.190.170

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=fp~5-7~&gr=koh-i-noor-progresso-woodless-colour-pencils.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:48:36'}
sessionid e030e309b63319aca2ce5d3b6c5762c1d6c2
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=fp~2-6~&gr=dover-how-to-draw-pets.html
urltoken CFID=30896318&CFTOKEN=78747232&jsessionid=e030e309b63319aca2ce5d3b6c5762c1d6c2
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:48:36'}
sessionid e030a7b4dd27ff47d60c3f5223576e4d3b27
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=fp~5-7~&gr=koh-i-noor-progresso-woodless-colour-pencils.html
urltoken CFID=30896319&CFTOKEN=83921713&jsessionid=e030a7b4dd27ff47d60c3f5223576e4d3b27
validationerror [empty string]


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

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

ItemIDList: 49080
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 36
barcode 8593539098867
barcode_type ISBN13
col1 black
col1_sortorder 402
col2 each
col2_sortorder 344
col3 [empty string]
color_swatch 0-0-0.jpg
cost 0.39
deal_of_the_week NO
description black, each
group_id 3439
group_uname koh-i-noor-progresso-woodless-colour-pencils
id 59328
list_price 0.87
map NO
mfr_num FA8750.12
net_weight 0.04
non_member_discount 26
non_member_price 0.64
prop65 NO
ship_rule_desc STD
shipping STD
sku 59328
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.44
ta_dealer_c_price 0.44
ta_price 0.7
text
array
1 59328
2 FA8750.12
3 black, each
timestamp 2015-04-01T21:26:38.887Z
vip_member_price 0.56

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 49080
CACHED false
EXECUTIONTIME 1
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] = '5020' 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.163.190.170

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=fp~5-7~&gr=koh-i-noor-progresso-woodless-colour-pencils.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:48:36'}
sessionid e030e309b63319aca2ce5d3b6c5762c1d6c2
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=fp~2-6~&gr=dover-how-to-draw-pets.html
urltoken CFID=30896318&CFTOKEN=78747232&jsessionid=e030e309b63319aca2ce5d3b6c5762c1d6c2
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:48:36'}
sessionid e030a7b4dd27ff47d60c3f5223576e4d3b27
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=fp~5-7~&gr=koh-i-noor-progresso-woodless-colour-pencils.html
urltoken CFID=30896319&CFTOKEN=83921713&jsessionid=e030a7b4dd27ff47d60c3f5223576e4d3b27
validationerror [empty string]


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

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

ItemIDList: 49080
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 36
barcode 8593539098850
barcode_type ISBN13
col1 brown
col1_sortorder 799
col2 each
col2_sortorder 344
col3 [empty string]
color_swatch 74-58-0.jpg
cost 0.39
deal_of_the_week NO
description brown, each
group_id 3439
group_uname koh-i-noor-progresso-woodless-colour-pencils
id 59327
list_price 0.87
map NO
mfr_num FA8750.11
net_weight 0.04
non_member_discount 26
non_member_price 0.64
prop65 NO
ship_rule_desc STD
shipping STD
sku 59327
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.44
ta_dealer_c_price 0.44
ta_price 0.7
text
array
1 59327
2 FA8750.11
3 brown, each
timestamp 2015-04-01T21:26:38.885Z
vip_member_price 0.56

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 49080
CACHED false
EXECUTIONTIME 1
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] = '5020' 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.163.190.170

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=fp~5-7~&gr=koh-i-noor-progresso-woodless-colour-pencils.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:48:36'}
sessionid e030e309b63319aca2ce5d3b6c5762c1d6c2
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=fp~2-6~&gr=dover-how-to-draw-pets.html
urltoken CFID=30896318&CFTOKEN=78747232&jsessionid=e030e309b63319aca2ce5d3b6c5762c1d6c2
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:48:36'}
sessionid e030a7b4dd27ff47d60c3f5223576e4d3b27
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=fp~5-7~&gr=koh-i-noor-progresso-woodless-colour-pencils.html
urltoken CFID=30896319&CFTOKEN=83921713&jsessionid=e030a7b4dd27ff47d60c3f5223576e4d3b27
validationerror [empty string]


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

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

ItemIDList: 49080
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 36
barcode 8593539098966
barcode_type EAN
col1 burnt sienna
col1_sortorder 876
col2 each
col2_sortorder 344
col3 [empty string]
color_swatch 149-47-47.jpg
cost 0.39
deal_of_the_week NO
description burnt sienna, each
group_id 3439
group_uname koh-i-noor-progresso-woodless-colour-pencils
id 59340
list_price 0.87
map NO
mfr_num FA8750.22
net_weight 0.03
non_member_discount 26
non_member_price 0.64
prop65 NO
ship_rule_desc STD
shipping STD
sku 59340
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.44
ta_dealer_c_price 0.44
ta_price 0.7
text
array
1 59340
2 FA8750.22
3 burnt sienna, each
timestamp 2015-04-01T21:26:38.911Z
vip_member_price 0.56

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 49080
CACHED false
EXECUTIONTIME 1
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] = '5020' 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.163.190.170

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=fp~5-7~&gr=koh-i-noor-progresso-woodless-colour-pencils.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:48:36'}
sessionid e030e309b63319aca2ce5d3b6c5762c1d6c2
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=fp~2-6~&gr=dover-how-to-draw-pets.html
urltoken CFID=30896318&CFTOKEN=78747232&jsessionid=e030e309b63319aca2ce5d3b6c5762c1d6c2
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:48:36'}
sessionid e030a7b4dd27ff47d60c3f5223576e4d3b27
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=fp~5-7~&gr=koh-i-noor-progresso-woodless-colour-pencils.html
urltoken CFID=30896319&CFTOKEN=83921713&jsessionid=e030a7b4dd27ff47d60c3f5223576e4d3b27
validationerror [empty string]


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

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

ItemIDList: 49080
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 36
barcode 8593539098843
barcode_type ISBN13
col1 carmine
col1_sortorder 1111
col2 each
col2_sortorder 344
col3 [empty string]
color_swatch 164-0-0.jpg
cost 0.39
deal_of_the_week NO
description carmine, each
group_id 3439
group_uname koh-i-noor-progresso-woodless-colour-pencils
id 59326
list_price 0.87
map NO
mfr_num FA8750.10
net_weight 0.04
non_member_discount 26
non_member_price 0.64
prop65 NO
ship_rule_desc STD
shipping STD
sku 59326
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.44
ta_dealer_c_price 0.44
ta_price 0.7
text
array
1 59326
2 FA8750.10
3 carmine, each
timestamp 2015-04-01T21:26:38.883Z
vip_member_price 0.56

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 49080
CACHED false
EXECUTIONTIME 1
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] = '5020' 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.163.190.170

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=fp~5-7~&gr=koh-i-noor-progresso-woodless-colour-pencils.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:48:36'}
sessionid e030e309b63319aca2ce5d3b6c5762c1d6c2
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=fp~2-6~&gr=dover-how-to-draw-pets.html
urltoken CFID=30896318&CFTOKEN=78747232&jsessionid=e030e309b63319aca2ce5d3b6c5762c1d6c2
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:48:36'}
sessionid e030a7b4dd27ff47d60c3f5223576e4d3b27
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=fp~5-7~&gr=koh-i-noor-progresso-woodless-colour-pencils.html
urltoken CFID=30896319&CFTOKEN=83921713&jsessionid=e030a7b4dd27ff47d60c3f5223576e4d3b27
validationerror [empty string]


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

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

ItemIDList: 49080
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 36
barcode 8593539098812
barcode_type ISBN13
col1 dark blue
col1_sortorder 1677
col2 each
col2_sortorder 344
col3 [empty string]
color_swatch 0-0-119.jpg
cost 0.39
deal_of_the_week NO
description dark blue, each
group_id 3439
group_uname koh-i-noor-progresso-woodless-colour-pencils
id 59361
list_price 0.87
map NO
mfr_num FA8750.7
net_weight 0.04
non_member_discount 26
non_member_price 0.64
prop65 NO
ship_rule_desc STD
shipping STD
sku 59361
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.44
ta_dealer_c_price 0.44
ta_price 0.7
text
array
1 59361
2 FA8750.7
3 dark blue, each
timestamp 2015-04-01T21:26:38.951Z
vip_member_price 0.56

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 49080
CACHED false
EXECUTIONTIME 1
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] = '5020' 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.163.190.170

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=fp~5-7~&gr=koh-i-noor-progresso-woodless-colour-pencils.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:48:36'}
sessionid e030e309b63319aca2ce5d3b6c5762c1d6c2
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=fp~2-6~&gr=dover-how-to-draw-pets.html
urltoken CFID=30896318&CFTOKEN=78747232&jsessionid=e030e309b63319aca2ce5d3b6c5762c1d6c2
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:48:36'}
sessionid e030a7b4dd27ff47d60c3f5223576e4d3b27
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=fp~5-7~&gr=koh-i-noor-progresso-woodless-colour-pencils.html
urltoken CFID=30896319&CFTOKEN=83921713&jsessionid=e030a7b4dd27ff47d60c3f5223576e4d3b27
validationerror [empty string]


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

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

ItemIDList: 49080
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 36
barcode 8593539098942
barcode_type ISBN13
col1 dark green
col1_sortorder 1711
col2 each
col2_sortorder 344
col3 [empty string]
color_swatch 67-104-47.jpg
cost 0.39
deal_of_the_week NO
description dark green, each
group_id 3439
group_uname koh-i-noor-progresso-woodless-colour-pencils
id 59338
list_price 0.87
map NO
mfr_num FA8750.20
net_weight 0.02
non_member_discount 26
non_member_price 0.64
prop65 NO
ship_rule_desc STD
shipping STD
sku 59338
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.44
ta_dealer_c_price 0.44
ta_price 0.7
text
array
1 59338
2 FA8750.20
3 dark green, each
timestamp 2015-04-01T21:26:38.907Z
vip_member_price 0.56

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 49080
CACHED false
EXECUTIONTIME 1
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] = '5020' 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.163.190.170

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=fp~5-7~&gr=koh-i-noor-progresso-woodless-colour-pencils.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:48:36'}
sessionid e030e309b63319aca2ce5d3b6c5762c1d6c2
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=fp~2-6~&gr=dover-how-to-draw-pets.html
urltoken CFID=30896318&CFTOKEN=78747232&jsessionid=e030e309b63319aca2ce5d3b6c5762c1d6c2
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:48:36'}
sessionid e030a7b4dd27ff47d60c3f5223576e4d3b27
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=fp~5-7~&gr=koh-i-noor-progresso-woodless-colour-pencils.html
urltoken CFID=30896319&CFTOKEN=83921713&jsessionid=e030a7b4dd27ff47d60c3f5223576e4d3b27
validationerror [empty string]


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

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

ItemIDList: 49080
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 36
barcode 8593539098829
barcode_type ISBN13
col1 dark violet
col1_sortorder 1769
col2 each
col2_sortorder 344
col3 [empty string]
color_swatch 127-0-164.jpg
cost 0.39
deal_of_the_week NO
description dark violet, each
group_id 3439
group_uname koh-i-noor-progresso-woodless-colour-pencils
id 59362
list_price 0.87
map NO
mfr_num FA8750.8
net_weight 0.04
non_member_discount 26
non_member_price 0.64
prop65 NO
ship_rule_desc STD
shipping STD
sku 59362
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.44
ta_dealer_c_price 0.44
ta_price 0.7
text
array
1 59362
2 FA8750.8
3 dark violet, each
timestamp 2015-04-01T21:26:38.953Z
vip_member_price 0.56

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 49080
CACHED false
EXECUTIONTIME 1
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] = '5020' 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.163.190.170

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=fp~5-7~&gr=koh-i-noor-progresso-woodless-colour-pencils.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:48:36'}
sessionid e030e309b63319aca2ce5d3b6c5762c1d6c2
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=fp~2-6~&gr=dover-how-to-draw-pets.html
urltoken CFID=30896318&CFTOKEN=78747232&jsessionid=e030e309b63319aca2ce5d3b6c5762c1d6c2
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:48:36'}
sessionid e030a7b4dd27ff47d60c3f5223576e4d3b27
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=fp~5-7~&gr=koh-i-noor-progresso-woodless-colour-pencils.html
urltoken CFID=30896319&CFTOKEN=83921713&jsessionid=e030a7b4dd27ff47d60c3f5223576e4d3b27
validationerror [empty string]


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

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

ItemIDList: 49080
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 36
barcode 8593539098874
barcode_type ISBN13
col1 dark yellow
col1_sortorder 1776
col2 each
col2_sortorder 344
col3 [empty string]
color_swatch 240-132-47.jpg
cost 0.39
deal_of_the_week NO
description dark yellow, each
group_id 3439
group_uname koh-i-noor-progresso-woodless-colour-pencils
id 59329
list_price 0.87
map NO
mfr_num FA8750.13
net_weight 0.04
non_member_discount 26
non_member_price 0.64
prop65 NO
ship_rule_desc STD
shipping STD
sku 59329
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.44
ta_dealer_c_price 0.44
ta_price 0.7
text
array
1 59329
2 FA8750.13
3 dark yellow, each
timestamp 2015-04-01T21:26:38.889Z
vip_member_price 0.56

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 49080
CACHED false
EXECUTIONTIME 1
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] = '5020' 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.163.190.170

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=fp~5-7~&gr=koh-i-noor-progresso-woodless-colour-pencils.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:48:36'}
sessionid e030e309b63319aca2ce5d3b6c5762c1d6c2
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=fp~2-6~&gr=dover-how-to-draw-pets.html
urltoken CFID=30896318&CFTOKEN=78747232&jsessionid=e030e309b63319aca2ce5d3b6c5762c1d6c2
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:48:36'}
sessionid e030a7b4dd27ff47d60c3f5223576e4d3b27
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=fp~5-7~&gr=koh-i-noor-progresso-woodless-colour-pencils.html
urltoken CFID=30896319&CFTOKEN=83921713&jsessionid=e030a7b4dd27ff47d60c3f5223576e4d3b27
validationerror [empty string]


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

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

ItemIDList: 49080
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 36
barcode 8593539098799
barcode_type ISBN13
col1 hooker's green
col1_sortorder 2846
col2 each
col2_sortorder 344
col3 [empty string]
color_swatch 0-74-45.jpg
cost 0.39
deal_of_the_week NO
description hooker's green, each
group_id 3439
group_uname koh-i-noor-progresso-woodless-colour-pencils
id 59359
list_price 0.87
map NO
mfr_num FA8750.5
net_weight 0.04
non_member_discount 26
non_member_price 0.64
prop65 NO
ship_rule_desc STD
shipping STD
sku 59359
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.44
ta_dealer_c_price 0.44
ta_price 0.7
text
array
1 59359
2 FA8750.5
3 hooker's green, each
timestamp 2015-04-01T21:26:38.947Z
vip_member_price 0.56

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 49080
CACHED false
EXECUTIONTIME 1
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] = '5020' 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.163.190.170

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=fp~5-7~&gr=koh-i-noor-progresso-woodless-colour-pencils.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:48:36'}
sessionid e030e309b63319aca2ce5d3b6c5762c1d6c2
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=fp~2-6~&gr=dover-how-to-draw-pets.html
urltoken CFID=30896318&CFTOKEN=78747232&jsessionid=e030e309b63319aca2ce5d3b6c5762c1d6c2
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:48:36'}
sessionid e030a7b4dd27ff47d60c3f5223576e4d3b27
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=fp~5-7~&gr=koh-i-noor-progresso-woodless-colour-pencils.html
urltoken CFID=30896319&CFTOKEN=83921713&jsessionid=e030a7b4dd27ff47d60c3f5223576e4d3b27
validationerror [empty string]


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

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

ItemIDList: 49080
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 36
barcode 8593539098805
barcode_type ISBN13
col1 light blue
col1_sortorder 3316
col2 each
col2_sortorder 344
col3 [empty string]
color_swatch 0-75-210.jpg
cost 0.39
deal_of_the_week NO
description light blue, each
group_id 3439
group_uname koh-i-noor-progresso-woodless-colour-pencils
id 59360
list_price 0.87
map NO
mfr_num FA8750.6
net_weight 0.04
non_member_discount 26
non_member_price 0.64
prop65 NO
ship_rule_desc STD
shipping STD
sku 59360
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.44
ta_dealer_c_price 0.44
ta_price 0.7
text
array
1 59360
2 FA8750.6
3 light blue, each
timestamp 2015-04-01T21:26:38.949Z
vip_member_price 0.56

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 49080
CACHED false
EXECUTIONTIME 1
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] = '5020' 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.163.190.170

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=fp~5-7~&gr=koh-i-noor-progresso-woodless-colour-pencils.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:48:36'}
sessionid e030e309b63319aca2ce5d3b6c5762c1d6c2
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=fp~2-6~&gr=dover-how-to-draw-pets.html
urltoken CFID=30896318&CFTOKEN=78747232&jsessionid=e030e309b63319aca2ce5d3b6c5762c1d6c2
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:48:36'}
sessionid e030a7b4dd27ff47d60c3f5223576e4d3b27
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=fp~5-7~&gr=koh-i-noor-progresso-woodless-colour-pencils.html
urltoken CFID=30896319&CFTOKEN=83921713&jsessionid=e030a7b4dd27ff47d60c3f5223576e4d3b27
validationerror [empty string]


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

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

ItemIDList: 49080
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 36
barcode 8593539098980
barcode_type ISBN13
col1 light gray
col1_sortorder 3351
col2 each
col2_sortorder 344
col3 [empty string]
color_swatch 135-135-135.jpg
cost 0.39
deal_of_the_week NO
description light gray, each
group_id 3439
group_uname koh-i-noor-progresso-woodless-colour-pencils
id 59342
list_price 0.87
map NO
mfr_num FA8750.24
net_weight 0.04
non_member_discount 26
non_member_price 0.64
prop65 NO
ship_rule_desc STD
shipping STD
sku 59342
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.44
ta_dealer_c_price 0.44
ta_price 0.7
text
array
1 59342
2 FA8750.24
3 light gray, each
timestamp 2015-04-01T21:26:38.915Z
vip_member_price 0.56

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 49080
CACHED false
EXECUTIONTIME 1
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] = '5020' 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.163.190.170

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=fp~5-7~&gr=koh-i-noor-progresso-woodless-colour-pencils.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:48:36'}
sessionid e030e309b63319aca2ce5d3b6c5762c1d6c2
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=fp~2-6~&gr=dover-how-to-draw-pets.html
urltoken CFID=30896318&CFTOKEN=78747232&jsessionid=e030e309b63319aca2ce5d3b6c5762c1d6c2
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:48:36'}
sessionid e030a7b4dd27ff47d60c3f5223576e4d3b27
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=fp~5-7~&gr=koh-i-noor-progresso-woodless-colour-pencils.html
urltoken CFID=30896319&CFTOKEN=83921713&jsessionid=e030a7b4dd27ff47d60c3f5223576e4d3b27
validationerror [empty string]


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

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

ItemIDList: 49080
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 36
barcode 8593539098935
barcode_type ISBN13
col1 light green
col1_sortorder 3353
col2 each
col2_sortorder 344
col3 [empty string]
color_swatch 122-210-122.jpg
cost 0.39
deal_of_the_week NO
description light green, each
group_id 3439
group_uname koh-i-noor-progresso-woodless-colour-pencils
id 59335
list_price 0.87
map NO
mfr_num FA8750.19
net_weight 0.02
non_member_discount 26
non_member_price 0.64
prop65 NO
ship_rule_desc STD
shipping STD
sku 59335
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.44
ta_dealer_c_price 0.44
ta_price 0.7
text
array
1 59335
2 FA8750.19
3 light green, each
timestamp 2015-04-01T21:26:38.901Z
vip_member_price 0.56

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 49080
CACHED false
EXECUTIONTIME 1
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] = '5020' 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.163.190.170

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=fp~5-7~&gr=koh-i-noor-progresso-woodless-colour-pencils.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:48:36'}
sessionid e030e309b63319aca2ce5d3b6c5762c1d6c2
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=fp~2-6~&gr=dover-how-to-draw-pets.html
urltoken CFID=30896318&CFTOKEN=78747232&jsessionid=e030e309b63319aca2ce5d3b6c5762c1d6c2
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:48:36'}
sessionid e030a7b4dd27ff47d60c3f5223576e4d3b27
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=fp~5-7~&gr=koh-i-noor-progresso-woodless-colour-pencils.html
urltoken CFID=30896319&CFTOKEN=83921713&jsessionid=e030a7b4dd27ff47d60c3f5223576e4d3b27
validationerror [empty string]


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

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

ItemIDList: 49080
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 36
barcode 8593539093619
barcode_type EAN
col1 light ochre
col1_sortorder 3386
col2 each
col2_sortorder 344
col3 [empty string]
color_swatch 240-186-92.jpg
cost 0.39
deal_of_the_week NO
description light ochre, each
group_id 3439
group_uname koh-i-noor-progresso-woodless-colour-pencils
id 59339
list_price 0.87
map NO
mfr_num FA8750.21
net_weight 0.02
non_member_discount 26
non_member_price 0.64
prop65 NO
ship_rule_desc STD
shipping STD
sku 59339
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.44
ta_dealer_c_price 0.44
ta_price 0.7
text
array
1 59339
2 FA8750.21
3 light ochre, each
timestamp 2015-04-01T21:26:38.909Z
vip_member_price 0.56

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 49080
CACHED false
EXECUTIONTIME 1
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] = '5020' 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.163.190.170

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=fp~5-7~&gr=koh-i-noor-progresso-woodless-colour-pencils.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:48:36'}
sessionid e030e309b63319aca2ce5d3b6c5762c1d6c2
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=fp~2-6~&gr=dover-how-to-draw-pets.html
urltoken CFID=30896318&CFTOKEN=78747232&jsessionid=e030e309b63319aca2ce5d3b6c5762c1d6c2
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:48:36'}
sessionid e030a7b4dd27ff47d60c3f5223576e4d3b27
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=fp~5-7~&gr=koh-i-noor-progresso-woodless-colour-pencils.html
urltoken CFID=30896319&CFTOKEN=83921713&jsessionid=e030a7b4dd27ff47d60c3f5223576e4d3b27
validationerror [empty string]


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

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

ItemIDList: 49080
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 36
barcode 8593539098836
barcode_type ISBN13
col1 light vermillion
col1_sortorder 3440
col2 each
col2_sortorder 344
col3 [empty string]
color_swatch 210-0-72.jpg
cost 0.39
deal_of_the_week NO
description light vermillion, each
group_id 3439
group_uname koh-i-noor-progresso-woodless-colour-pencils
id 59363
list_price 0.87
map NO
mfr_num FA8750.9
net_weight 0.04
non_member_discount 26
non_member_price 0.64
prop65 NO
ship_rule_desc STD
shipping STD
sku 59363
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.44
ta_dealer_c_price 0.44
ta_price 0.7
text
array
1 59363
2 FA8750.9
3 light vermillion, each
timestamp 2015-04-01T21:26:38.955Z
vip_member_price 0.56

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 49080
CACHED false
EXECUTIONTIME 1
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] = '5020' 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.163.190.170

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=fp~5-7~&gr=koh-i-noor-progresso-woodless-colour-pencils.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:48:36'}
sessionid e030e309b63319aca2ce5d3b6c5762c1d6c2
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=fp~2-6~&gr=dover-how-to-draw-pets.html
urltoken CFID=30896318&CFTOKEN=78747232&jsessionid=e030e309b63319aca2ce5d3b6c5762c1d6c2
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:48:36'}
sessionid e030a7b4dd27ff47d60c3f5223576e4d3b27
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=fp~5-7~&gr=koh-i-noor-progresso-woodless-colour-pencils.html
urltoken CFID=30896319&CFTOKEN=83921713&jsessionid=e030a7b4dd27ff47d60c3f5223576e4d3b27
validationerror [empty string]


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

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

ItemIDList: 49080
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 36
barcode 8593539098904
barcode_type ISBN13
col1 light violet
col1_sortorder 3441
col2 each
col2_sortorder 344
col3 [empty string]
color_swatch 119-0-0.jpg
cost 0.39
deal_of_the_week NO
description light violet, each
group_id 3439
group_uname koh-i-noor-progresso-woodless-colour-pencils
id 59332
list_price 0.87
map NO
mfr_num FA8750.16
net_weight 0.04
non_member_discount 26
non_member_price 0.64
prop65 NO
ship_rule_desc STD
shipping STD
sku 59332
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.44
ta_dealer_c_price 0.44
ta_price 0.7
text
array
1 59332
2 FA8750.16
3 light violet, each
timestamp 2015-04-01T21:26:38.895Z
vip_member_price 0.56

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 49080
CACHED false
EXECUTIONTIME 1
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] = '5020' 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.163.190.170

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=fp~5-7~&gr=koh-i-noor-progresso-woodless-colour-pencils.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:48:36'}
sessionid e030e309b63319aca2ce5d3b6c5762c1d6c2
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=fp~2-6~&gr=dover-how-to-draw-pets.html
urltoken CFID=30896318&CFTOKEN=78747232&jsessionid=e030e309b63319aca2ce5d3b6c5762c1d6c2
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:48:36'}
sessionid e030a7b4dd27ff47d60c3f5223576e4d3b27
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=fp~5-7~&gr=koh-i-noor-progresso-woodless-colour-pencils.html
urltoken CFID=30896319&CFTOKEN=83921713&jsessionid=e030a7b4dd27ff47d60c3f5223576e4d3b27
validationerror [empty string]


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

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

ItemIDList: 49080
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 36
barcode 8593539098751
barcode_type ISBN13
col1 light yellow
col1_sortorder 3447
col2 each
col2_sortorder 344
col3 [empty string]
color_swatch 240-229-92.jpg
cost 0.39
deal_of_the_week NO
description light yellow, each
group_id 3439
group_uname koh-i-noor-progresso-woodless-colour-pencils
id 59325
list_price 0.87
map NO
mfr_num FA8750.1
net_weight 0.04
non_member_discount 26
non_member_price 0.64
prop65 NO
ship_rule_desc STD
shipping STD
sku 59325
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.44
ta_dealer_c_price 0.44
ta_price 0.7
text
array
1 59325
2 FA8750.1
3 light yellow, each
timestamp 2015-04-01T21:26:38.881Z
vip_member_price 0.56

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 49080
CACHED false
EXECUTIONTIME 1
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] = '5020' 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.163.190.170

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=fp~5-7~&gr=koh-i-noor-progresso-woodless-colour-pencils.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:48:36'}
sessionid e030e309b63319aca2ce5d3b6c5762c1d6c2
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=fp~2-6~&gr=dover-how-to-draw-pets.html
urltoken CFID=30896318&CFTOKEN=78747232&jsessionid=e030e309b63319aca2ce5d3b6c5762c1d6c2
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:48:36'}
sessionid e030a7b4dd27ff47d60c3f5223576e4d3b27
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=fp~5-7~&gr=koh-i-noor-progresso-woodless-colour-pencils.html
urltoken CFID=30896319&CFTOKEN=83921713&jsessionid=e030a7b4dd27ff47d60c3f5223576e4d3b27
validationerror [empty string]


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

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

ItemIDList: 49080
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 36
barcode 8593539098973
barcode_type ISBN13
col1 natural sepia
col1_sortorder 3945
col2 each
col2_sortorder 344
col3 [empty string]
color_swatch 74-40-0.jpg
cost 0.39
deal_of_the_week NO
description natural sepia, each
group_id 3439
group_uname koh-i-noor-progresso-woodless-colour-pencils
id 59341
list_price 0.87
map NO
mfr_num FA8750.23
net_weight 0.03
non_member_discount 26
non_member_price 0.64
prop65 NO
ship_rule_desc STD
shipping STD
sku 59341
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.44
ta_dealer_c_price 0.44
ta_price 0.7
text
array
1 59341
2 FA8750.23
3 natural sepia, each
timestamp 2015-04-01T21:26:38.913Z
vip_member_price 0.56

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 49080
CACHED false
EXECUTIONTIME 1
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] = '5020' 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.163.190.170

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=fp~5-7~&gr=koh-i-noor-progresso-woodless-colour-pencils.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:48:36'}
sessionid e030e309b63319aca2ce5d3b6c5762c1d6c2
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=fp~2-6~&gr=dover-how-to-draw-pets.html
urltoken CFID=30896318&CFTOKEN=78747232&jsessionid=e030e309b63319aca2ce5d3b6c5762c1d6c2
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:48:36'}
sessionid e030a7b4dd27ff47d60c3f5223576e4d3b27
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=fp~5-7~&gr=koh-i-noor-progresso-woodless-colour-pencils.html
urltoken CFID=30896319&CFTOKEN=83921713&jsessionid=e030a7b4dd27ff47d60c3f5223576e4d3b27
validationerror [empty string]


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

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

ItemIDList: 49080
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 36
barcode 8593539098768
barcode_type ISBN13
col1 orange
col1_sortorder 4222
col2 each
col2_sortorder 344
col3 [empty string]
color_swatch 210-90-0.jpg
cost 0.39
deal_of_the_week NO
description orange, each
group_id 3439
group_uname koh-i-noor-progresso-woodless-colour-pencils
id 59337
list_price 0.87
map NO
mfr_num FA8750.2
net_weight 0.03
non_member_discount 26
non_member_price 0.64
prop65 NO
ship_rule_desc STD
shipping STD
sku 59337
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.44
ta_dealer_c_price 0.44
ta_price 0.7
text
array
1 59337
2 FA8750.2
3 orange, each
timestamp 2015-04-01T21:26:38.905Z
vip_member_price 0.56

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 49080
CACHED false
EXECUTIONTIME 1
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] = '5020' 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.163.190.170

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=fp~5-7~&gr=koh-i-noor-progresso-woodless-colour-pencils.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:48:36'}
sessionid e030e309b63319aca2ce5d3b6c5762c1d6c2
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=fp~2-6~&gr=dover-how-to-draw-pets.html
urltoken CFID=30896318&CFTOKEN=78747232&jsessionid=e030e309b63319aca2ce5d3b6c5762c1d6c2
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:48:36'}
sessionid e030a7b4dd27ff47d60c3f5223576e4d3b27
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=fp~5-7~&gr=koh-i-noor-progresso-woodless-colour-pencils.html
urltoken CFID=30896319&CFTOKEN=83921713&jsessionid=e030a7b4dd27ff47d60c3f5223576e4d3b27
validationerror [empty string]


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

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

ItemIDList: 49080
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 36
barcode 8593539098928
barcode_type ISBN13
col1 Paris blue
col1_sortorder 4390
col2 each
col2_sortorder 344
col3 [empty string]
color_swatch 0-53-119.jpg
cost 0.39
deal_of_the_week NO
description Paris blue, each
group_id 3439
group_uname koh-i-noor-progresso-woodless-colour-pencils
id 59334
list_price 0.87
map NO
mfr_num FA8750.18
net_weight 0.04
non_member_discount 26
non_member_price 0.64
prop65 NO
ship_rule_desc STD
shipping STD
sku 59334
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.44
ta_dealer_c_price 0.44
ta_price 0.7
text
array
1 59334
2 FA8750.18
3 Paris blue, each
timestamp 2015-04-01T21:26:38.899Z
vip_member_price 0.56

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 49080
CACHED false
EXECUTIONTIME 1
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] = '5020' 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.163.190.170

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=fp~5-7~&gr=koh-i-noor-progresso-woodless-colour-pencils.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:48:36'}
sessionid e030e309b63319aca2ce5d3b6c5762c1d6c2
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=fp~2-6~&gr=dover-how-to-draw-pets.html
urltoken CFID=30896318&CFTOKEN=78747232&jsessionid=e030e309b63319aca2ce5d3b6c5762c1d6c2
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:48:36'}
sessionid e030a7b4dd27ff47d60c3f5223576e4d3b27
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=fp~5-7~&gr=koh-i-noor-progresso-woodless-colour-pencils.html
urltoken CFID=30896319&CFTOKEN=83921713&jsessionid=e030a7b4dd27ff47d60c3f5223576e4d3b27
validationerror [empty string]


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

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

ItemIDList: 49080
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 36
barcode 8593539098881
barcode_type ISBN13
col1 pink
col1_sortorder 4724
col2 each
col2_sortorder 344
col3 [empty string]
color_swatch 240-138-161.jpg
cost 0.39
deal_of_the_week NO
description pink, each
group_id 3439
group_uname koh-i-noor-progresso-woodless-colour-pencils
id 59330
list_price 0.87
map NO
mfr_num FA8750.14
net_weight 0.04
non_member_discount 26
non_member_price 0.64
prop65 NO
ship_rule_desc STD
shipping STD
sku 59330
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.44
ta_dealer_c_price 0.44
ta_price 0.7
text
array
1 59330
2 FA8750.14
3 pink, each
timestamp 2015-04-01T21:26:38.891Z
vip_member_price 0.56

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 49080
CACHED false
EXECUTIONTIME 1
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] = '5020' 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.163.190.170

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=fp~5-7~&gr=koh-i-noor-progresso-woodless-colour-pencils.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:48:36'}
sessionid e030e309b63319aca2ce5d3b6c5762c1d6c2
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=fp~2-6~&gr=dover-how-to-draw-pets.html
urltoken CFID=30896318&CFTOKEN=78747232&jsessionid=e030e309b63319aca2ce5d3b6c5762c1d6c2
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:48:36'}
sessionid e030a7b4dd27ff47d60c3f5223576e4d3b27
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=fp~5-7~&gr=koh-i-noor-progresso-woodless-colour-pencils.html
urltoken CFID=30896319&CFTOKEN=83921713&jsessionid=e030a7b4dd27ff47d60c3f5223576e4d3b27
validationerror [empty string]


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

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

ItemIDList: 49080
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 36
barcode 8593539098782
barcode_type ISBN13
col1 sap green
col1_sortorder 5370
col2 each
col2_sortorder 344
col3 [empty string]
color_swatch 0-119-0.jpg
cost 0.39
deal_of_the_week NO
description sap green, each
group_id 3439
group_uname koh-i-noor-progresso-woodless-colour-pencils
id 59344
list_price 0.87
map NO
mfr_num FA8750.4
net_weight 0.04
non_member_discount 26
non_member_price 0.64
prop65 NO
ship_rule_desc STD
shipping STD
sku 59344
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.44
ta_dealer_c_price 0.44
ta_price 0.7
text
array
1 59344
2 FA8750.4
3 sap green, each
timestamp 2015-04-01T21:26:38.919Z
vip_member_price 0.56

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 49080
CACHED false
EXECUTIONTIME 1
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] = '5020' 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.163.190.170

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=fp~5-7~&gr=koh-i-noor-progresso-woodless-colour-pencils.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:48:36'}
sessionid e030e309b63319aca2ce5d3b6c5762c1d6c2
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=fp~2-6~&gr=dover-how-to-draw-pets.html
urltoken CFID=30896318&CFTOKEN=78747232&jsessionid=e030e309b63319aca2ce5d3b6c5762c1d6c2
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:48:36'}
sessionid e030a7b4dd27ff47d60c3f5223576e4d3b27
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=fp~5-7~&gr=koh-i-noor-progresso-woodless-colour-pencils.html
urltoken CFID=30896319&CFTOKEN=83921713&jsessionid=e030a7b4dd27ff47d60c3f5223576e4d3b27
validationerror [empty string]


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

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

ItemIDList: 49080
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 36
barcode 8593539098898
barcode_type ISBN13
col1 scarlet lake
col1_sortorder 5395
col2 each
col2_sortorder 344
col3 [empty string]
color_swatch 210-77-135.jpg
cost 0.39
deal_of_the_week NO
description scarlet lake, each
group_id 3439
group_uname koh-i-noor-progresso-woodless-colour-pencils
id 59331
list_price 0.87
map NO
mfr_num FA8750.15
net_weight 0.04
non_member_discount 26
non_member_price 0.64
prop65 NO
ship_rule_desc STD
shipping STD
sku 59331
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.44
ta_dealer_c_price 0.44
ta_price 0.7
text
array
1 59331
2 FA8750.15
3 scarlet lake, each
timestamp 2015-04-01T21:26:38.893Z
vip_member_price 0.56

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 49080
CACHED false
EXECUTIONTIME 1
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] = '5020' 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.163.190.170

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=fp~5-7~&gr=koh-i-noor-progresso-woodless-colour-pencils.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:48:36'}
sessionid e030e309b63319aca2ce5d3b6c5762c1d6c2
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=fp~2-6~&gr=dover-how-to-draw-pets.html
urltoken CFID=30896318&CFTOKEN=78747232&jsessionid=e030e309b63319aca2ce5d3b6c5762c1d6c2
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:48:36'}
sessionid e030a7b4dd27ff47d60c3f5223576e4d3b27
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=fp~5-7~&gr=koh-i-noor-progresso-woodless-colour-pencils.html
urltoken CFID=30896319&CFTOKEN=83921713&jsessionid=e030a7b4dd27ff47d60c3f5223576e4d3b27
validationerror [empty string]


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

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

ItemIDList: 49080
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 36
barcode 8593539098911
barcode_type ISBN13
col1 sky blue
col1_sortorder 5628
col2 each
col2_sortorder 344
col3 [empty string]
color_swatch 47-102-195.jpg
cost 0.39
deal_of_the_week NO
description sky blue, each
group_id 3439
group_uname koh-i-noor-progresso-woodless-colour-pencils
id 59333
list_price 0.87
map NO
mfr_num FA8750.17
net_weight 0.02
non_member_discount 26
non_member_price 0.64
prop65 NO
ship_rule_desc STD
shipping STD
sku 59333
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.44
ta_dealer_c_price 0.44
ta_price 0.7
text
array
1 59333
2 FA8750.17
3 sky blue, each
timestamp 2015-04-01T21:26:38.897Z
vip_member_price 0.56

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 49080
CACHED false
EXECUTIONTIME 1
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] = '5020' 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.163.190.170

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=fp~5-7~&gr=koh-i-noor-progresso-woodless-colour-pencils.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:48:36'}
sessionid e030e309b63319aca2ce5d3b6c5762c1d6c2
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=fp~2-6~&gr=dover-how-to-draw-pets.html
urltoken CFID=30896318&CFTOKEN=78747232&jsessionid=e030e309b63319aca2ce5d3b6c5762c1d6c2
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:48:36'}
sessionid e030a7b4dd27ff47d60c3f5223576e4d3b27
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=fp~5-7~&gr=koh-i-noor-progresso-woodless-colour-pencils.html
urltoken CFID=30896319&CFTOKEN=83921713&jsessionid=e030a7b4dd27ff47d60c3f5223576e4d3b27
validationerror [empty string]


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

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

ItemIDList: 49080
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 36
barcode 8593539098775
barcode_type ISBN13
col1 white
col1_sortorder 6545
col2 each
col2_sortorder 344
col3 [empty string]
color_swatch 255-255-255.jpg
cost 0.39
deal_of_the_week NO
description white, each
group_id 3439
group_uname koh-i-noor-progresso-woodless-colour-pencils
id 59343
list_price 0.87
map NO
mfr_num FA8750.3
net_weight 0.04
non_member_discount 26
non_member_price 0.64
prop65 NO
ship_rule_desc STD
shipping STD
sku 59343
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.44
ta_dealer_c_price 0.44
ta_price 0.7
text
array
1 59343
2 FA8750.3
3 white, each
timestamp 2015-04-01T21:26:38.917Z
vip_member_price 0.56

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 49080
CACHED false
EXECUTIONTIME 1
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] = '5020' 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.163.190.170

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=fp~5-7~&gr=koh-i-noor-progresso-woodless-colour-pencils.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:48:36'}
sessionid e030e309b63319aca2ce5d3b6c5762c1d6c2
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=fp~2-6~&gr=dover-how-to-draw-pets.html
urltoken CFID=30896318&CFTOKEN=78747232&jsessionid=e030e309b63319aca2ce5d3b6c5762c1d6c2
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:48:36'}
sessionid e030a7b4dd27ff47d60c3f5223576e4d3b27
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=fp~5-7~&gr=koh-i-noor-progresso-woodless-colour-pencils.html
urltoken CFID=30896319&CFTOKEN=83921713&jsessionid=e030a7b4dd27ff47d60c3f5223576e4d3b27
validationerror [empty string]


Put the color on the paper and leave the wood on the tree. These high-density, lacquer-coated Hardtmuth Colour pencils has the smooth feel and excellent lay down properties loved by professional artists. Outlasts standard wood-cased pencils with excellent light permanency. Create a wide variety of unique effects. Sharpen with a standard sharpener.

Available in assorted sets of 12 or 24. Also sold individuallly, order 12 for a full box.

Share on Facebook Twitter Pinterest

Ask a question about Progresso Woodless Colour Pencils Ask a question about this product

Progresso Woodless Colour Pencils

by Koh-I-Noor

Average User Rating: Based on (19 Reviews)

5 19

Melanie from Pittston, PA says:

These pencils are awesome! I ordered these with a few other small sets for a comparison, as I'm a beginner at pencils. I ordered a prismacolor 12 set, a crayola 24 set and this set. This set has the brightest...[more]

[Read All Reviews] [Write a Review]









  Item# Swatch Image color
Ascending
unit Manufacturer Number List Price
Non-Member
Price
VIP Member
Club Price
Quantity
Add to Favorites
55386
Progresso Woodless Colour Pencils assorted set of 24
Zoom Image
assorted set of 24 FA8758.24 $21.80 $16.13 26% Off $13.95 36% Off Email When In Stock
Add to Favorites
82524
Progresso Woodless Colour Pencils assorted set of 12
Zoom Image
assorted set of 12 FA8756.12 $10.45 $7.73 26% Off $6.69 36% Off Email When In Stock
Add to Favorites
59328
Progresso Woodless Colour Pencils black each
Zoom Image
black each FA8750.12 $0.87 $0.64 26% Off $0.56 36% Off Email When In Stock
Add to Favorites
59327
Progresso Woodless Colour Pencils brown each
Zoom Image
brown each FA8750.11 $0.87 $0.64 26% Off $0.56 36% Off Email When In Stock
Add to Favorites
59340
Progresso Woodless Colour Pencils burnt sienna each
Zoom Image
burnt sienna each FA8750.22 $0.87 $0.64 26% Off $0.56 36% Off Email When In Stock
Add to Favorites
59326
Progresso Woodless Colour Pencils carmine each
Zoom Image
carmine each FA8750.10 $0.87 $0.64 26% Off $0.56 36% Off Email When In Stock
Add to Favorites
59361
Progresso Woodless Colour Pencils dark blue each
Zoom Image
dark blue each FA8750.7 $0.87 $0.64 26% Off $0.56 36% Off Email When In Stock
Add to Favorites
59338
Progresso Woodless Colour Pencils dark green each
Zoom Image
dark green each FA8750.20 $0.87 $0.64 26% Off $0.56 36% Off Email When In Stock
Add to Favorites
59362
Progresso Woodless Colour Pencils dark violet each
Zoom Image
dark violet each FA8750.8 $0.87 $0.64 26% Off $0.56 36% Off Email When In Stock
Add to Favorites
59329
Progresso Woodless Colour Pencils dark yellow each
Zoom Image
dark yellow each FA8750.13 $0.87 $0.64 26% Off $0.56 36% Off Email When In Stock
Add to Favorites
59359
Progresso Woodless Colour Pencils hooker's green each
Zoom Image
hooker's green each FA8750.5 $0.87 $0.64 26% Off $0.56 36% Off Email When In Stock
Add to Favorites
59360
Progresso Woodless Colour Pencils light blue each
Zoom Image
light blue each FA8750.6 $0.87 $0.64 26% Off $0.56 36% Off Email When In Stock
Add to Favorites
59342
Progresso Woodless Colour Pencils light gray each
Zoom Image
light gray each FA8750.24 $0.87 $0.64 26% Off $0.56 36% Off Email When In Stock
Add to Favorites
59335
Progresso Woodless Colour Pencils light green each
Zoom Image
light green each FA8750.19 $0.87 $0.64 26% Off $0.56 36% Off Email When In Stock
Add to Favorites
59339
Progresso Woodless Colour Pencils light ochre each
Zoom Image
light ochre each FA8750.21 $0.87 $0.64 26% Off $0.56 36% Off Email When In Stock
Add to Favorites
59363
Progresso Woodless Colour Pencils light vermillion each
Zoom Image
light vermillion each FA8750.9 $0.87 $0.64 26% Off $0.56 36% Off Email When In Stock
Add to Favorites
59332
Progresso Woodless Colour Pencils light violet each
Zoom Image
light violet each FA8750.16 $0.87 $0.64 26% Off $0.56 36% Off Email When In Stock
Add to Favorites
59325
Progresso Woodless Colour Pencils light yellow each
Zoom Image
light yellow each FA8750.1 $0.87 $0.64 26% Off $0.56 36% Off Email When In Stock
Add to Favorites
59341
Progresso Woodless Colour Pencils natural sepia each
Zoom Image
natural sepia each FA8750.23 $0.87 $0.64 26% Off $0.56 36% Off Email When In Stock
Add to Favorites
59337
Progresso Woodless Colour Pencils orange each
Zoom Image
orange each FA8750.2 $0.87 $0.64 26% Off $0.56 36% Off Email When In Stock
Add to Favorites
59334
Progresso Woodless Colour Pencils Paris blue each
Zoom Image
Paris blue each FA8750.18 $0.87 $0.64 26% Off $0.56 36% Off Email When In Stock
Add to Favorites
59330
Progresso Woodless Colour Pencils pink each
Zoom Image
pink each FA8750.14 $0.87 $0.64 26% Off $0.56 36% Off Email When In Stock
Add to Favorites
59344
Progresso Woodless Colour Pencils sap green each
Zoom Image
sap green each FA8750.4 $0.87 $0.64 26% Off $0.56 36% Off Email When In Stock
Add to Favorites
59331
Progresso Woodless Colour Pencils scarlet lake each
Zoom Image
scarlet lake each FA8750.15 $0.87 $0.64 26% Off $0.56 36% Off Email When In Stock
Add to Favorites
59333
Progresso Woodless Colour Pencils sky blue each
Zoom Image
sky blue each FA8750.17 $0.87 $0.64 26% Off $0.56 36% Off Email When In Stock
Add to Favorites
59343
Progresso Woodless Colour Pencils white each
Zoom Image
white each FA8750.3 $0.87 $0.64 26% Off $0.56 36% 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...

Biggie Sketch Pads

by Canson

Versatile and affordable

Up to 55% Off

All Pencil

by Stabilo

Marks clearly on any transparent, glazed surface

Up to 32% Off

Kneaded Rubber Erasers

by Prismacolor

Perfect for chalk, charcoal, and pastels

From $0.52

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 Progresso Woodless Colour Pencils

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: Melanie in Pittston, PA
These pencils are awesome! I ordered these with a few other small sets for a comparison, as I'm a beginner at pencils. I ordered a prismacolor 12 set, a crayola 24 set and this set. This set has the brightest colors, very easy to 'lay down color', the color doesn't come off on your hand (Hey, I thought it would.. never know!) I would definitely recommend these.
Rated by: gold324 in Gardiner, NY
Strong colors and easy to apply. Prompt delivery and very reasonably priced.
Rated by: Thru Jenn's Eyes in Wyoming
These pencils are awesome! Not only do I get much more out of them with less waste, but they color so smooth and creamy. It is a pleasure to use them! I find myself wanting to do more colored pencil work now!!!
Rated by: Gracie S. in Los Angeles, CA
I really like these pencils. They feel good in my hands, and they are great pencils all around.
Rated by: Maria j. in Glendale, AZ.
I really enjoy drawing with these pencils, they go on really smooth and blend well. They seem to last longer than wood pencils, and I like the heavy feel of them better. I always have a set, and they are totally my go to pencils. LOVE EM!!
Rated by: anthony e. in san diego
I just finished a very nice drawing with these pencils. Very awesome. I'd recommend these pencils to everyone!
Rated by: Rose W. in Twin Cities, MN
Wonderful! I love these. Since I'm a student I can't afford a lot of fancy things but these are still one of couple top brands! I can't believe they are so cheap! They give wonderful smooth texture and because they are woodless you don't have to constantly sharpen. They don't give you as serious bold as Prismacolor(nothing does) but if you need something smooth this is the perfect thing. I recomend these to everyone who enjoys drawing, student and professional!
Rated by: Lily L. in Geneva, NY
I haven't tried out many brands of colored pencils, but I have to say that out of those I have tried, these rank as one of the top brands if not the best. The colors come out very smoothly and are very vibrant. The fact that they're woodless is a plus as well.
Rated by: Srinivasan N. in Palo Alto, CA
Progresso Woodless pencils are great for covering large areas quickly, smooth laying and brilliant colors... in all excellent buy.
Rated by: charla k. in Seattle, WA
Love these pencils. I usually buy Prisma but thought I would try these out. These are just as good if not better for a steal of a price. I have a Bull Mastiff and even after he stepped on a couple of these and snapped them in half they still worked great. I just sharpened the broken end and it was perfect. Im ordering these exclusivly now.
Rated by: karen b. in alto, MI
Love these pencils! No more broken pencils you can't sharpen. And this product is top quality. I have tried other brands and my students don't get the same high quality results with them.
Rated by: Patricia J. in Fernley NV 89408, NV
I've used many brands of colored pencils for years but these are absolutely the BEST! I love the feel, almost sensual! And the colors are intense, they also sharpen nicely.
Rated by: Carolyn S. in Crestview, FL
I can't keep them on the shelves! Very popular!
Rated by: Brandie T. in West Valley City, UT
I needed something that would draw on felt for a dolls face and these pencils were the only ones that wrote the smoothest and brightest on my skin at the store. I tested all brands at Michaels. Easy to sharpen without breaking. Mister Art's prices are much better then my local stores.
Rated by: Gina M. in fair oaks, CA
Better than Prisma. And I bought both to compare.
Rated by: Karen R. in Athens, IL
I bought these for my artistic kids for Christmas. We all love them. I will probably purchase another set in the future. The lead doesn't break when sharpening like normal colored pencils. Highly recommend these.
Rated by: laura or steve n. in claypool, AZ
I LOVE THESE WOODLESS PENCILS. THEY FEEL REALLY GOOD IN YOUR HANDS AND THE COLORS ARE BEAUTIFUL.THEY LAY OUT SMOOTH AND BRIGHT AND OVERLAY EXCELLENT TO CREATE MANY COLORS. THANKS
Rated by: Brenda C. in Baltimore, MD
I bought these as a novelty because they were woodless. They are quite heavy and have a nice feel.
Rated by: Carolyn C. in Long Beach, WA
I haven't used Color pencils in my work very often, but I am really getting use to these and I like the feel and color lay down. I love the fact that they are woodless.

Write a Product Review for Progresso Woodless Colour Pencils

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...