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

Hunt Artists' Pen Nibs--Drawing No. 99

by Speedball


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

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

ItemIDList: 22404
AvailQtyList: 40.000000000000

struct
FLAGS 0
VIP_member_discount 35
barcode 651032094095
barcode_type UPC
col1 box of 12
col1_sortorder 252
col2 [empty string]
col3 [empty string]
cost 7.42
deal_of_the_week NO
description box of 12
group_id 7315
group_uname speedball-hunt-artists-pen-nibs-drawing-no-99
id 61777
list_price 15
map NO
mfr_num 9409
net_weight 0.04
non_member_discount 25
non_member_price 11.25
prop65 NO
ship_rule_desc STD
shipping STD
sku 61777
sku_pix YES
supplier_id 1
ta_dealer_a_price 8.1
ta_dealer_c_price 8.1
ta_price 12
text
array
1 61777
2 9409
3 box of 12
timestamp 2015-03-31T17:54:01.7Z
vip_member_price 9.75

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 40.000000000000 22404
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '6378' 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.89.118.108

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=pens&gr=speedball-hunt-artists-pen-nibs-drawing-no-99.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:14:47'}
sessionid e03022843f93cafdc131327a74a30582b365
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=scales-rulers&CatD=fp~3-14~&gr=westcott-l-square.html
urltoken CFID=30630713&CFTOKEN=92808571&jsessionid=e03022843f93cafdc131327a74a30582b365
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:14:47'}
sessionid e030328ff3a0fabcfe7a1a2a7d636b132830
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pens&gr=speedball-hunt-artists-pen-nibs-drawing-no-99.html
urltoken CFID=30630714&CFTOKEN=60900467&jsessionid=e030328ff3a0fabcfe7a1a2a7d636b132830
validationerror [empty string]


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

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

ItemIDList: 22404
AvailQtyList: 40.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 651032094903
barcode_type UPC
col1 pack of 2
col1_sortorder 362
col2 [empty string]
col3 [empty string]
cost 1.72
deal_of_the_week NO
description pack of 2
group_id 7315
group_uname speedball-hunt-artists-pen-nibs-drawing-no-99
id 32093
list_price 3.49
map NO
mfr_num 9490
net_weight 0.01
non_member_discount 20
non_member_price 2.79
prop65 NO
ship_rule_desc STD
shipping STD
sku 32093
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.88
ta_dealer_c_price 1.88
ta_price 2.97
text
array
1 32093
2 9490
3 pack of 2
timestamp 2015-03-31T17:53:10.592Z
vip_member_price 2.44

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 40.000000000000 22404
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '6378' 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.89.118.108

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=pens&gr=speedball-hunt-artists-pen-nibs-drawing-no-99.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:14:47'}
sessionid e03022843f93cafdc131327a74a30582b365
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=scales-rulers&CatD=fp~3-14~&gr=westcott-l-square.html
urltoken CFID=30630713&CFTOKEN=92808571&jsessionid=e03022843f93cafdc131327a74a30582b365
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:14:47'}
sessionid e030328ff3a0fabcfe7a1a2a7d636b132830
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pens&gr=speedball-hunt-artists-pen-nibs-drawing-no-99.html
urltoken CFID=30630714&CFTOKEN=60900467&jsessionid=e030328ff3a0fabcfe7a1a2a7d636b132830
validationerror [empty string]


Extra fine point for drafting and lithography. Made from the finest steel and handcrafted in the USA. Pen holder sold separately. Use with Speedball #9451 Pen Holder, General's Cork Grip Pen Holder, Koh-I-Noor No. 130N Crow Quill Pen Holder, or Speedball Classic Pen Holders.

Share on Facebook Twitter Pinterest

Ask a question about Hunt Artists' Pen Nibs--Drawing No. 99 Ask a question about this product

Hunt Artists' Pen Nibs--Drawing No. 99

by Speedball

Be the first to write a review on this product!









  Item# Image unit
Ascending
Manufacturer Number List Price
Non-Member
Price
VIP Member
Club Price
Quantity
Add to Favorites
61777
Hunt Artists' Pen Nibs--Drawing No. 99 box of 12
Zoom Image
box of 12 9409 $15.00 $11.25 25% Off $9.75 35% Off Email When In Stock
Add to Favorites
32093
Hunt Artists' Pen Nibs--Drawing No. 99 pack of 2
Zoom Image
pack of 2 9490 $3.49 $2.79 20% Off $2.44 30% Off Email When In Stock

Click the to add item to your Favorites.



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

Hunt Artists' Pen Nibs--Extra Fine No....

by Speedball

Great for ornamental writing and fine ruling

From $2.44

Hunt Artists' Pen Nibs--Imperial No....

by Speedball

Very flexible for ornamental work

Up to 35% Off

Up to 35% 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 Hunt Artists' Pen Nibs--Drawing No. 99

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.

Write a Product Review for Hunt Artists' Pen Nibs--Drawing No. 99

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