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

Fine Art Graphite Pencils (Dozen)

by Cretacolor


Problem with item sku 28150-PK. Item is found in Solr index but not found in vAvailQtyTbl.

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 32
col1 2B
col1_sortorder 4
col2 [empty string]
col3 [empty string]
cost 8.76
deal_of_the_week NO
description 2B
group_id 7956
group_uname cretacolor-fine-art-graphite-pencils-dozen-
id 28150-PK
list_price 18
map NO
net_weight 0.5
non_member_discount 22
non_member_price 14.04
prop65 NO
ship_rule_desc STD
shipping STD
sku 28150-PK
sku_pix NO
supplier_id 1
ta_dealer_a_price 0
ta_dealer_c_price 0
ta_price 0
text
array
1 28150-PK
2 2B
timestamp 2015-03-27T14:46:51.573Z
vip_member_price 12.24

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 6
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] = '7956' 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.80.69.152

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=fb~cretacolor~&gr=cretacolor-fine-art-graphite-pencils-dozen-.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:15:38'}
sessionid e030729d9a336a0a23be622447d667c65362
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=fb~cretacolor~&gr=cretacolor-fine-art-graphite-pencils-dozen-.html
urltoken CFID=29893875&CFTOKEN=94815947&jsessionid=e030729d9a336a0a23be622447d667c65362
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:15:38'}
sessionid e030729d9a336a0a23be622447d667c65362
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=fb~cretacolor~&gr=cretacolor-fine-art-graphite-pencils-dozen-.html
urltoken CFID=29893875&CFTOKEN=94815947&jsessionid=e030729d9a336a0a23be622447d667c65362
validationerror [empty string]


Problem with item sku 16414-PK. Item is found in Solr index but not found in vAvailQtyTbl.

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 32
col1 2H
col1_sortorder 5
col2 [empty string]
col3 [empty string]
cost 8.76
deal_of_the_week NO
description 2H
group_id 7956
group_uname cretacolor-fine-art-graphite-pencils-dozen-
id 16414-PK
list_price 18
map NO
net_weight 0.5
non_member_discount 22
non_member_price 14.04
prop65 NO
ship_rule_desc STD
shipping STD
sku 16414-PK
sku_pix NO
supplier_id 1
ta_dealer_a_price 0
ta_dealer_c_price 0
ta_price 0
text
array
1 16414-PK
2 2H
timestamp 2015-03-27T14:46:35.824Z
vip_member_price 12.24

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 6
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] = '7956' 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.80.69.152

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=fb~cretacolor~&gr=cretacolor-fine-art-graphite-pencils-dozen-.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:15:38'}
sessionid e030729d9a336a0a23be622447d667c65362
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=fb~cretacolor~&gr=cretacolor-fine-art-graphite-pencils-dozen-.html
urltoken CFID=29893875&CFTOKEN=94815947&jsessionid=e030729d9a336a0a23be622447d667c65362
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:15:38'}
sessionid e030729d9a336a0a23be622447d667c65362
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=fb~cretacolor~&gr=cretacolor-fine-art-graphite-pencils-dozen-.html
urltoken CFID=29893875&CFTOKEN=94815947&jsessionid=e030729d9a336a0a23be622447d667c65362
validationerror [empty string]


Problem with item sku 15007-PK. Item is found in Solr index but not found in vAvailQtyTbl.

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 32
col1 3B
col1_sortorder 7
col2 [empty string]
col3 [empty string]
cost 8.76
deal_of_the_week NO
description 3B
group_id 7956
group_uname cretacolor-fine-art-graphite-pencils-dozen-
id 15007-PK
list_price 18
map NO
net_weight 0.5
non_member_discount 22
non_member_price 14.04
prop65 NO
ship_rule_desc STD
shipping STD
sku 15007-PK
sku_pix NO
supplier_id 1
ta_dealer_a_price 0
ta_dealer_c_price 0
ta_price 0
text
array
1 15007-PK
2 3B
timestamp 2015-03-27T14:46:33.086Z
vip_member_price 12.24

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 6
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] = '7956' 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.80.69.152

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=fb~cretacolor~&gr=cretacolor-fine-art-graphite-pencils-dozen-.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:15:38'}
sessionid e030729d9a336a0a23be622447d667c65362
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=fb~cretacolor~&gr=cretacolor-fine-art-graphite-pencils-dozen-.html
urltoken CFID=29893875&CFTOKEN=94815947&jsessionid=e030729d9a336a0a23be622447d667c65362
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:15:38'}
sessionid e030729d9a336a0a23be622447d667c65362
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=fb~cretacolor~&gr=cretacolor-fine-art-graphite-pencils-dozen-.html
urltoken CFID=29893875&CFTOKEN=94815947&jsessionid=e030729d9a336a0a23be622447d667c65362
validationerror [empty string]


Problem with item sku 10683-PK. Item is found in Solr index but not found in vAvailQtyTbl.

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 32
col1 3H
col1_sortorder 8
col2 [empty string]
col3 [empty string]
cost 8.76
deal_of_the_week NO
description 3H
group_id 7956
group_uname cretacolor-fine-art-graphite-pencils-dozen-
id 10683-PK
list_price 18
map NO
net_weight 0.5
non_member_discount 22
non_member_price 14.04
prop65 NO
ship_rule_desc STD
shipping STD
sku 10683-PK
sku_pix NO
supplier_id 1
ta_dealer_a_price 0
ta_dealer_c_price 0
ta_price 0
text
array
1 10683-PK
2 3H
timestamp 2015-03-27T14:46:24.7Z
vip_member_price 12.24

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 6
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] = '7956' 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.80.69.152

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=fb~cretacolor~&gr=cretacolor-fine-art-graphite-pencils-dozen-.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:15:38'}
sessionid e030729d9a336a0a23be622447d667c65362
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=fb~cretacolor~&gr=cretacolor-fine-art-graphite-pencils-dozen-.html
urltoken CFID=29893875&CFTOKEN=94815947&jsessionid=e030729d9a336a0a23be622447d667c65362
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:15:38'}
sessionid e030729d9a336a0a23be622447d667c65362
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=fb~cretacolor~&gr=cretacolor-fine-art-graphite-pencils-dozen-.html
urltoken CFID=29893875&CFTOKEN=94815947&jsessionid=e030729d9a336a0a23be622447d667c65362
validationerror [empty string]


Problem with item sku 32036-PK. Item is found in Solr index but not found in vAvailQtyTbl.

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 32
col1 4B
col1_sortorder 9
col2 [empty string]
col3 [empty string]
cost 8.76
deal_of_the_week NO
description 4B
group_id 7956
group_uname cretacolor-fine-art-graphite-pencils-dozen-
id 32036-PK
list_price 18
map NO
net_weight 0.5
non_member_discount 22
non_member_price 14.04
prop65 NO
ship_rule_desc STD
shipping STD
sku 32036-PK
sku_pix NO
supplier_id 1
ta_dealer_a_price 0
ta_dealer_c_price 0
ta_price 0
text
array
1 32036-PK
2 4B
timestamp 2015-03-27T14:46:57.849Z
vip_member_price 12.24

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 6
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] = '7956' 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.80.69.152

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=fb~cretacolor~&gr=cretacolor-fine-art-graphite-pencils-dozen-.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:15:38'}
sessionid e030729d9a336a0a23be622447d667c65362
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=fb~cretacolor~&gr=cretacolor-fine-art-graphite-pencils-dozen-.html
urltoken CFID=29893875&CFTOKEN=94815947&jsessionid=e030729d9a336a0a23be622447d667c65362
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:15:38'}
sessionid e030729d9a336a0a23be622447d667c65362
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=fb~cretacolor~&gr=cretacolor-fine-art-graphite-pencils-dozen-.html
urltoken CFID=29893875&CFTOKEN=94815947&jsessionid=e030729d9a336a0a23be622447d667c65362
validationerror [empty string]


Problem with item sku 14659-PK. Item is found in Solr index but not found in vAvailQtyTbl.

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 32
col1 4H
col1_sortorder 11
col2 [empty string]
col3 [empty string]
cost 8.76
deal_of_the_week NO
description 4H
group_id 7956
group_uname cretacolor-fine-art-graphite-pencils-dozen-
id 14659-PK
list_price 18
map NO
net_weight 0.2
non_member_discount 22
non_member_price 14.04
prop65 NO
ship_rule_desc STD
shipping STD
sku 14659-PK
sku_pix NO
supplier_id 1
ta_dealer_a_price 0
ta_dealer_c_price 0
ta_price 0
text
array
1 14659-PK
2 4H
timestamp 2015-03-27T14:46:31.362Z
vip_member_price 12.24

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 6
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] = '7956' 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.80.69.152

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=fb~cretacolor~&gr=cretacolor-fine-art-graphite-pencils-dozen-.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:15:38'}
sessionid e030729d9a336a0a23be622447d667c65362
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=fb~cretacolor~&gr=cretacolor-fine-art-graphite-pencils-dozen-.html
urltoken CFID=29893875&CFTOKEN=94815947&jsessionid=e030729d9a336a0a23be622447d667c65362
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:15:38'}
sessionid e030729d9a336a0a23be622447d667c65362
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=fb~cretacolor~&gr=cretacolor-fine-art-graphite-pencils-dozen-.html
urltoken CFID=29893875&CFTOKEN=94815947&jsessionid=e030729d9a336a0a23be622447d667c65362
validationerror [empty string]


Problem with item sku 18822-PK. Item is found in Solr index but not found in vAvailQtyTbl.

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 32
col1 5B
col1_sortorder 12
col2 [empty string]
col3 [empty string]
cost 8.76
deal_of_the_week NO
description 5B
group_id 7956
group_uname cretacolor-fine-art-graphite-pencils-dozen-
id 18822-PK
list_price 18
map NO
net_weight 0.2
non_member_discount 22
non_member_price 14.04
prop65 NO
ship_rule_desc STD
shipping STD
sku 18822-PK
sku_pix NO
supplier_id 1
ta_dealer_a_price 0
ta_dealer_c_price 0
ta_price 0
text
array
1 18822-PK
2 5B
timestamp 2015-03-27T14:46:39.072Z
vip_member_price 12.24

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 6
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] = '7956' 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.80.69.152

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=fb~cretacolor~&gr=cretacolor-fine-art-graphite-pencils-dozen-.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:15:38'}
sessionid e030729d9a336a0a23be622447d667c65362
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=fb~cretacolor~&gr=cretacolor-fine-art-graphite-pencils-dozen-.html
urltoken CFID=29893875&CFTOKEN=94815947&jsessionid=e030729d9a336a0a23be622447d667c65362
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:15:38'}
sessionid e030729d9a336a0a23be622447d667c65362
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=fb~cretacolor~&gr=cretacolor-fine-art-graphite-pencils-dozen-.html
urltoken CFID=29893875&CFTOKEN=94815947&jsessionid=e030729d9a336a0a23be622447d667c65362
validationerror [empty string]


Problem with item sku 29099-PK. Item is found in Solr index but not found in vAvailQtyTbl.

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 32
col1 5H
col1_sortorder 14
col2 [empty string]
col3 [empty string]
cost 8.76
deal_of_the_week NO
description 5H
group_id 7956
group_uname cretacolor-fine-art-graphite-pencils-dozen-
id 29099-PK
list_price 18
map NO
net_weight 0.2
non_member_discount 22
non_member_price 14.04
prop65 NO
ship_rule_desc STD
shipping STD
sku 29099-PK
sku_pix NO
supplier_id 1
ta_dealer_a_price 0
ta_dealer_c_price 0
ta_price 0
text
array
1 29099-PK
2 5H
timestamp 2015-03-27T14:46:52.958Z
vip_member_price 12.24

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 6
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] = '7956' 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.80.69.152

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=fb~cretacolor~&gr=cretacolor-fine-art-graphite-pencils-dozen-.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:15:38'}
sessionid e030729d9a336a0a23be622447d667c65362
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=fb~cretacolor~&gr=cretacolor-fine-art-graphite-pencils-dozen-.html
urltoken CFID=29893875&CFTOKEN=94815947&jsessionid=e030729d9a336a0a23be622447d667c65362
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:15:38'}
sessionid e030729d9a336a0a23be622447d667c65362
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=fb~cretacolor~&gr=cretacolor-fine-art-graphite-pencils-dozen-.html
urltoken CFID=29893875&CFTOKEN=94815947&jsessionid=e030729d9a336a0a23be622447d667c65362
validationerror [empty string]


Problem with item sku 14368-PK. Item is found in Solr index but not found in vAvailQtyTbl.

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 32
col1 6B
col1_sortorder 15
col2 [empty string]
col3 [empty string]
cost 8.76
deal_of_the_week NO
description 6B
group_id 7956
group_uname cretacolor-fine-art-graphite-pencils-dozen-
id 14368-PK
list_price 18
map NO
net_weight 0.2
non_member_discount 22
non_member_price 14.04
prop65 NO
ship_rule_desc STD
shipping STD
sku 14368-PK
sku_pix NO
supplier_id 1
ta_dealer_a_price 0
ta_dealer_c_price 0
ta_price 0
text
array
1 14368-PK
2 6B
timestamp 2015-03-27T14:46:30.488Z
vip_member_price 12.24

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 6
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] = '7956' 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.80.69.152

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=fb~cretacolor~&gr=cretacolor-fine-art-graphite-pencils-dozen-.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:15:38'}
sessionid e030729d9a336a0a23be622447d667c65362
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=fb~cretacolor~&gr=cretacolor-fine-art-graphite-pencils-dozen-.html
urltoken CFID=29893875&CFTOKEN=94815947&jsessionid=e030729d9a336a0a23be622447d667c65362
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:15:38'}
sessionid e030729d9a336a0a23be622447d667c65362
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=fb~cretacolor~&gr=cretacolor-fine-art-graphite-pencils-dozen-.html
urltoken CFID=29893875&CFTOKEN=94815947&jsessionid=e030729d9a336a0a23be622447d667c65362
validationerror [empty string]


Problem with item sku 30553-PK. Item is found in Solr index but not found in vAvailQtyTbl.

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 32
col1 6H
col1_sortorder 17
col2 [empty string]
col3 [empty string]
cost 8.76
deal_of_the_week NO
description 6H
group_id 7956
group_uname cretacolor-fine-art-graphite-pencils-dozen-
id 30553-PK
list_price 18
map NO
net_weight 0.2
non_member_discount 22
non_member_price 14.04
prop65 NO
ship_rule_desc STD
shipping STD
sku 30553-PK
sku_pix NO
supplier_id 1
ta_dealer_a_price 0
ta_dealer_c_price 0
ta_price 0
text
array
1 30553-PK
2 6H
timestamp 2015-03-27T14:46:55.24Z
vip_member_price 12.24

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 6
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] = '7956' 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.80.69.152

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=fb~cretacolor~&gr=cretacolor-fine-art-graphite-pencils-dozen-.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:15:38'}
sessionid e030729d9a336a0a23be622447d667c65362
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=fb~cretacolor~&gr=cretacolor-fine-art-graphite-pencils-dozen-.html
urltoken CFID=29893875&CFTOKEN=94815947&jsessionid=e030729d9a336a0a23be622447d667c65362
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:15:38'}
sessionid e030729d9a336a0a23be622447d667c65362
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=fb~cretacolor~&gr=cretacolor-fine-art-graphite-pencils-dozen-.html
urltoken CFID=29893875&CFTOKEN=94815947&jsessionid=e030729d9a336a0a23be622447d667c65362
validationerror [empty string]


Problem with item sku 14023-PK. Item is found in Solr index but not found in vAvailQtyTbl.

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 32
col1 7B
col1_sortorder 18
col2 [empty string]
col3 [empty string]
cost 8.76
deal_of_the_week NO
description 7B
group_id 7956
group_uname cretacolor-fine-art-graphite-pencils-dozen-
id 14023-PK
list_price 18
map NO
net_weight 0.2
non_member_discount 22
non_member_price 14.04
prop65 NO
ship_rule_desc STD
shipping STD
sku 14023-PK
sku_pix NO
supplier_id 1
ta_dealer_a_price 0
ta_dealer_c_price 0
ta_price 0
text
array
1 14023-PK
2 7B
timestamp 2015-03-27T14:46:29.897Z
vip_member_price 12.24

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 6
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] = '7956' 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.80.69.152

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=fb~cretacolor~&gr=cretacolor-fine-art-graphite-pencils-dozen-.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:15:38'}
sessionid e030729d9a336a0a23be622447d667c65362
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=fb~cretacolor~&gr=cretacolor-fine-art-graphite-pencils-dozen-.html
urltoken CFID=29893875&CFTOKEN=94815947&jsessionid=e030729d9a336a0a23be622447d667c65362
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:15:38'}
sessionid e030729d9a336a0a23be622447d667c65362
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=fb~cretacolor~&gr=cretacolor-fine-art-graphite-pencils-dozen-.html
urltoken CFID=29893875&CFTOKEN=94815947&jsessionid=e030729d9a336a0a23be622447d667c65362
validationerror [empty string]


Problem with item sku 29817-PK. Item is found in Solr index but not found in vAvailQtyTbl.

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 32
col1 7H
col1_sortorder 19
col2 [empty string]
col3 [empty string]
cost 8.76
deal_of_the_week NO
description 7H
group_id 7956
group_uname cretacolor-fine-art-graphite-pencils-dozen-
id 29817-PK
list_price 18
map NO
net_weight 0.2
non_member_discount 22
non_member_price 14.04
prop65 NO
ship_rule_desc STD
shipping STD
sku 29817-PK
sku_pix NO
supplier_id 1
ta_dealer_a_price 0
ta_dealer_c_price 0
ta_price 0
text
array
1 29817-PK
2 7H
timestamp 2015-03-27T14:46:53.732Z
vip_member_price 12.24

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 6
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] = '7956' 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.80.69.152

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=fb~cretacolor~&gr=cretacolor-fine-art-graphite-pencils-dozen-.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:15:38'}
sessionid e030729d9a336a0a23be622447d667c65362
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=fb~cretacolor~&gr=cretacolor-fine-art-graphite-pencils-dozen-.html
urltoken CFID=29893875&CFTOKEN=94815947&jsessionid=e030729d9a336a0a23be622447d667c65362
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:15:38'}
sessionid e030729d9a336a0a23be622447d667c65362
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=fb~cretacolor~&gr=cretacolor-fine-art-graphite-pencils-dozen-.html
urltoken CFID=29893875&CFTOKEN=94815947&jsessionid=e030729d9a336a0a23be622447d667c65362
validationerror [empty string]


Problem with item sku 30287-PK. Item is found in Solr index but not found in vAvailQtyTbl.

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 32
col1 8B
col1_sortorder 20
col2 [empty string]
col3 [empty string]
cost 8.76
deal_of_the_week NO
description 8B
group_id 7956
group_uname cretacolor-fine-art-graphite-pencils-dozen-
id 30287-PK
list_price 18
map NO
net_weight 0.2
non_member_discount 22
non_member_price 14.04
prop65 NO
ship_rule_desc STD
shipping STD
sku 30287-PK
sku_pix NO
supplier_id 1
ta_dealer_a_price 0
ta_dealer_c_price 0
ta_price 0
text
array
1 30287-PK
2 8B
timestamp 2015-03-27T14:46:54.697Z
vip_member_price 12.24

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 6
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] = '7956' 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.80.69.152

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=fb~cretacolor~&gr=cretacolor-fine-art-graphite-pencils-dozen-.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:15:38'}
sessionid e030729d9a336a0a23be622447d667c65362
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=fb~cretacolor~&gr=cretacolor-fine-art-graphite-pencils-dozen-.html
urltoken CFID=29893875&CFTOKEN=94815947&jsessionid=e030729d9a336a0a23be622447d667c65362
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:15:38'}
sessionid e030729d9a336a0a23be622447d667c65362
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=fb~cretacolor~&gr=cretacolor-fine-art-graphite-pencils-dozen-.html
urltoken CFID=29893875&CFTOKEN=94815947&jsessionid=e030729d9a336a0a23be622447d667c65362
validationerror [empty string]


Problem with item sku 31482-PK. Item is found in Solr index but not found in vAvailQtyTbl.

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 32
col1 8H
col1_sortorder 22
col2 [empty string]
col3 [empty string]
cost 8.76
deal_of_the_week NO
description 8H
group_id 7956
group_uname cretacolor-fine-art-graphite-pencils-dozen-
id 31482-PK
list_price 18
map NO
net_weight 0.2
non_member_discount 22
non_member_price 14.04
prop65 NO
ship_rule_desc STD
shipping STD
sku 31482-PK
sku_pix NO
supplier_id 1
ta_dealer_a_price 0
ta_dealer_c_price 0
ta_price 0
text
array
1 31482-PK
2 8H
timestamp 2015-03-27T14:46:57.003Z
vip_member_price 12.24

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 6
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] = '7956' 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.80.69.152

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=fb~cretacolor~&gr=cretacolor-fine-art-graphite-pencils-dozen-.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:15:38'}
sessionid e030729d9a336a0a23be622447d667c65362
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=fb~cretacolor~&gr=cretacolor-fine-art-graphite-pencils-dozen-.html
urltoken CFID=29893875&CFTOKEN=94815947&jsessionid=e030729d9a336a0a23be622447d667c65362
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:15:38'}
sessionid e030729d9a336a0a23be622447d667c65362
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=fb~cretacolor~&gr=cretacolor-fine-art-graphite-pencils-dozen-.html
urltoken CFID=29893875&CFTOKEN=94815947&jsessionid=e030729d9a336a0a23be622447d667c65362
validationerror [empty string]


Problem with item sku 16046-PK. Item is found in Solr index but not found in vAvailQtyTbl.

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 32
col1 9B
col1_sortorder 23
col2 [empty string]
col3 [empty string]
cost 8.76
deal_of_the_week NO
description 9B
group_id 7956
group_uname cretacolor-fine-art-graphite-pencils-dozen-
id 16046-PK
list_price 18
map NO
net_weight 0.2
non_member_discount 22
non_member_price 14.04
prop65 NO
ship_rule_desc STD
shipping STD
sku 16046-PK
sku_pix NO
supplier_id 1
ta_dealer_a_price 0
ta_dealer_c_price 0
ta_price 0
text
array
1 16046-PK
2 9B
timestamp 2015-03-27T14:46:35.242Z
vip_member_price 12.24

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 6
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] = '7956' 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.80.69.152

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=fb~cretacolor~&gr=cretacolor-fine-art-graphite-pencils-dozen-.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:15:38'}
sessionid e030729d9a336a0a23be622447d667c65362
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=fb~cretacolor~&gr=cretacolor-fine-art-graphite-pencils-dozen-.html
urltoken CFID=29893875&CFTOKEN=94815947&jsessionid=e030729d9a336a0a23be622447d667c65362
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:15:38'}
sessionid e030729d9a336a0a23be622447d667c65362
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=fb~cretacolor~&gr=cretacolor-fine-art-graphite-pencils-dozen-.html
urltoken CFID=29893875&CFTOKEN=94815947&jsessionid=e030729d9a336a0a23be622447d667c65362
validationerror [empty string]


Problem with item sku 24567-PK. Item is found in Solr index but not found in vAvailQtyTbl.

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 32
col1 9H
col1_sortorder 24
col2 [empty string]
col3 [empty string]
cost 8.76
deal_of_the_week NO
description 9H
group_id 7956
group_uname cretacolor-fine-art-graphite-pencils-dozen-
id 24567-PK
list_price 18
map NO
net_weight 0.2
non_member_discount 22
non_member_price 14.04
prop65 NO
ship_rule_desc STD
shipping STD
sku 24567-PK
sku_pix NO
supplier_id 1
ta_dealer_a_price 0
ta_dealer_c_price 0
ta_price 0
text
array
1 24567-PK
2 9H
timestamp 2015-03-27T14:46:45.89Z
vip_member_price 12.24

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 6
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] = '7956' 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.80.69.152

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=fb~cretacolor~&gr=cretacolor-fine-art-graphite-pencils-dozen-.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:15:38'}
sessionid e030729d9a336a0a23be622447d667c65362
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=fb~cretacolor~&gr=cretacolor-fine-art-graphite-pencils-dozen-.html
urltoken CFID=29893875&CFTOKEN=94815947&jsessionid=e030729d9a336a0a23be622447d667c65362
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:15:38'}
sessionid e030729d9a336a0a23be622447d667c65362
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=fb~cretacolor~&gr=cretacolor-fine-art-graphite-pencils-dozen-.html
urltoken CFID=29893875&CFTOKEN=94815947&jsessionid=e030729d9a336a0a23be622447d667c65362
validationerror [empty string]


Problem with item sku 13885-PK. Item is found in Solr index but not found in vAvailQtyTbl.

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 32
col1 B
col1_sortorder 28
col2 [empty string]
col3 [empty string]
cost 8.76
deal_of_the_week NO
description B
group_id 7956
group_uname cretacolor-fine-art-graphite-pencils-dozen-
id 13885-PK
list_price 18
map NO
net_weight 0.5
non_member_discount 22
non_member_price 14.04
prop65 NO
ship_rule_desc STD
shipping STD
sku 13885-PK
sku_pix NO
supplier_id 1
ta_dealer_a_price 0
ta_dealer_c_price 0
ta_price 0
text
array
1 13885-PK
2 B
timestamp 2015-03-27T14:46:29.628Z
vip_member_price 12.24

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 6
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] = '7956' 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.80.69.152

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=fb~cretacolor~&gr=cretacolor-fine-art-graphite-pencils-dozen-.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:15:38'}
sessionid e030729d9a336a0a23be622447d667c65362
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=fb~cretacolor~&gr=cretacolor-fine-art-graphite-pencils-dozen-.html
urltoken CFID=29893875&CFTOKEN=94815947&jsessionid=e030729d9a336a0a23be622447d667c65362
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:15:38'}
sessionid e030729d9a336a0a23be622447d667c65362
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=fb~cretacolor~&gr=cretacolor-fine-art-graphite-pencils-dozen-.html
urltoken CFID=29893875&CFTOKEN=94815947&jsessionid=e030729d9a336a0a23be622447d667c65362
validationerror [empty string]


Problem with item sku 15826-PK. Item is found in Solr index but not found in vAvailQtyTbl.

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 32
col1 F
col1_sortorder 37
col2 [empty string]
col3 [empty string]
cost 8.76
deal_of_the_week NO
description F
group_id 7956
group_uname cretacolor-fine-art-graphite-pencils-dozen-
id 15826-PK
list_price 18
map NO
net_weight 0.5
non_member_discount 22
non_member_price 14.04
prop65 NO
ship_rule_desc STD
shipping STD
sku 15826-PK
sku_pix NO
supplier_id 1
ta_dealer_a_price 0
ta_dealer_c_price 0
ta_price 0
text
array
1 15826-PK
2 F
timestamp 2015-03-27T14:46:34.911Z
vip_member_price 12.24

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 6
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] = '7956' 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.80.69.152

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=fb~cretacolor~&gr=cretacolor-fine-art-graphite-pencils-dozen-.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:15:38'}
sessionid e030729d9a336a0a23be622447d667c65362
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=fb~cretacolor~&gr=cretacolor-fine-art-graphite-pencils-dozen-.html
urltoken CFID=29893875&CFTOKEN=94815947&jsessionid=e030729d9a336a0a23be622447d667c65362
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:15:38'}
sessionid e030729d9a336a0a23be622447d667c65362
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=fb~cretacolor~&gr=cretacolor-fine-art-graphite-pencils-dozen-.html
urltoken CFID=29893875&CFTOKEN=94815947&jsessionid=e030729d9a336a0a23be622447d667c65362
validationerror [empty string]


Problem with item sku 30670-PK. Item is found in Solr index but not found in vAvailQtyTbl.

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 32
col1 H
col1_sortorder 38
col2 [empty string]
col3 [empty string]
cost 8.76
deal_of_the_week NO
description H
group_id 7956
group_uname cretacolor-fine-art-graphite-pencils-dozen-
id 30670-PK
list_price 18
map NO
net_weight 0.5
non_member_discount 22
non_member_price 14.04
prop65 NO
ship_rule_desc STD
shipping STD
sku 30670-PK
sku_pix NO
supplier_id 1
ta_dealer_a_price 0
ta_dealer_c_price 0
ta_price 0
text
array
1 30670-PK
2 H
timestamp 2015-03-27T14:46:55.417Z
vip_member_price 12.24

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 6
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] = '7956' 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.80.69.152

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=fb~cretacolor~&gr=cretacolor-fine-art-graphite-pencils-dozen-.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:15:38'}
sessionid e030729d9a336a0a23be622447d667c65362
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=fb~cretacolor~&gr=cretacolor-fine-art-graphite-pencils-dozen-.html
urltoken CFID=29893875&CFTOKEN=94815947&jsessionid=e030729d9a336a0a23be622447d667c65362
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:15:38'}
sessionid e030729d9a336a0a23be622447d667c65362
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=fb~cretacolor~&gr=cretacolor-fine-art-graphite-pencils-dozen-.html
urltoken CFID=29893875&CFTOKEN=94815947&jsessionid=e030729d9a336a0a23be622447d667c65362
validationerror [empty string]


Problem with item sku 12541-PK. Item is found in Solr index but not found in vAvailQtyTbl.

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 32
col1 HB
col1_sortorder 42
col2 [empty string]
col3 [empty string]
cost 8.76
deal_of_the_week NO
description HB
group_id 7956
group_uname cretacolor-fine-art-graphite-pencils-dozen-
id 12541-PK
list_price 18
map NO
net_weight 0.5
non_member_discount 22
non_member_price 14.04
prop65 NO
ship_rule_desc STD
shipping STD
sku 12541-PK
sku_pix NO
supplier_id 1
ta_dealer_a_price 0
ta_dealer_c_price 0
ta_price 0
text
array
1 12541-PK
2 HB
timestamp 2015-03-27T14:46:27.619Z
vip_member_price 12.24

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 6
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] = '7956' 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.80.69.152

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=fb~cretacolor~&gr=cretacolor-fine-art-graphite-pencils-dozen-.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:15:38'}
sessionid e030729d9a336a0a23be622447d667c65362
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=fb~cretacolor~&gr=cretacolor-fine-art-graphite-pencils-dozen-.html
urltoken CFID=29893875&CFTOKEN=94815947&jsessionid=e030729d9a336a0a23be622447d667c65362
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:15:38'}
sessionid e030729d9a336a0a23be622447d667c65362
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=fb~cretacolor~&gr=cretacolor-fine-art-graphite-pencils-dozen-.html
urltoken CFID=29893875&CFTOKEN=94815947&jsessionid=e030729d9a336a0a23be622447d667c65362
validationerror [empty string]


Well known for its superior quality is this traditional graphite pencil. Cedar wood casing guarantees utmost strength and easy sharpening. Range of 20 hardness/softness grades from 9B (softest) to 9H (hardest) covers the full spectrum of applications. Softer grades produce broader and darker strokes; harder grades produce more precise and lighter strokes. Cretacolor graphite pencils are good tools for all sketching, drawing, and hatching applications.

Sold in boxes of 12. Also available individually.



Share on Facebook Twitter Pinterest

Ask a question about Fine Art Graphite Pencils (Dozen) Ask a question about this product

Fine Art Graphite Pencils (Dozen)

by Cretacolor

Average User Rating: Based on (5 Reviews)

5 5

Debbie M. from Browntown, WI says:

As drawing is the basis for success in painting, I feel the proper pencil is of utmost importance. I have looked for a long time for these pencils after being introduced to them by a fellow artist. Finally...[more]

[Read All Reviews] [Write a Review]









  Item# hardness
Ascending
Manufacturer Number List Price
Non-Member
Price
VIP Member
Club Price
Quantity
Add to Favorites
28150-PK
2B $18.00 $14.04 22% Off $12.24 32% Off Email When In Stock
Add to Favorites
16414-PK
2H $18.00 $14.04 22% Off $12.24 32% Off Email When In Stock
Add to Favorites
15007-PK
3B $18.00 $14.04 22% Off $12.24 32% Off Email When In Stock
Add to Favorites
10683-PK
3H $18.00 $14.04 22% Off $12.24 32% Off Email When In Stock
Add to Favorites
32036-PK
4B $18.00 $14.04 22% Off $12.24 32% Off Email When In Stock
Add to Favorites
14659-PK
4H $18.00 $14.04 22% Off $12.24 32% Off Email When In Stock
Add to Favorites
18822-PK
5B $18.00 $14.04 22% Off $12.24 32% Off Email When In Stock
Add to Favorites
29099-PK
5H $18.00 $14.04 22% Off $12.24 32% Off Email When In Stock
Add to Favorites
14368-PK
6B $18.00 $14.04 22% Off $12.24 32% Off Email When In Stock
Add to Favorites
30553-PK
6H $18.00 $14.04 22% Off $12.24 32% Off Email When In Stock
Add to Favorites
14023-PK
7B $18.00 $14.04 22% Off $12.24 32% Off Email When In Stock
Add to Favorites
29817-PK
7H $18.00 $14.04 22% Off $12.24 32% Off Email When In Stock
Add to Favorites
30287-PK
8B $18.00 $14.04 22% Off $12.24 32% Off Email When In Stock
Add to Favorites
31482-PK
8H $18.00 $14.04 22% Off $12.24 32% Off Email When In Stock
Add to Favorites
16046-PK
9B $18.00 $14.04 22% Off $12.24 32% Off Email When In Stock
Add to Favorites
24567-PK
9H $18.00 $14.04 22% Off $12.24 32% Off Email When In Stock
Add to Favorites
13885-PK
B $18.00 $14.04 22% Off $12.24 32% Off Email When In Stock
Add to Favorites
15826-PK
F $18.00 $14.04 22% Off $12.24 32% Off Email When In Stock
Add to Favorites
30670-PK
H $18.00 $14.04 22% Off $12.24 32% Off Email When In Stock
Add to Favorites
12541-PK
HB $18.00 $14.04 22% Off $12.24 32% Off Email When In Stock

Click the to add item to your Favorites.



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

Scale Lumber Gauge

by Midwest

Modeling essentials

From $4.07

Big Brush Watercolor Palette

by Sterling Edwards

22 wells for both mixing and storing color mixes

At Least 39 % Off

Deluxe Woodcarving Set

by X-Acto

Name brand quality for less

Up to 32% 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 Fine Art Graphite Pencils (Dozen)

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: Debbie M. in Browntown, WI
As drawing is the basis for success in painting, I feel the proper pencil is of utmost importance. I have looked for a long time for these pencils after being introduced to them by a fellow artist. Finally I found them at Misterart,com. I have encouraged my students to use them and the results are amazing. There is a clear difference in this product.
Rated by: Erin J. in Saint George, UT
These pencils are great for the most part, especially if you're just starting out. They're not really smooth, but I've been able to overcome that.
Rated by: ConnieOlson E. in Summerville, SC
We do some drafting in the early classes for students to learn form. These are perfect.
Rated by: Patrick L. in San Antonio, TX
I deal with many companies in my profession and MisterArt.com ranks at the top of my list as far as customer service and satisfaction are concerned. Also, their prices are some of the best I've ever seen.
Rated by: Vanesa Littlecrow W. in Rice, MN
A fantastic value. Not as smooth as some higher-end graphite pencils, but they are definitely a great value. Highly recommended.

Write a Product Review for Fine Art Graphite Pencils (Dozen)

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