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

Oil-painting Workshop

by DK Publishing


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

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

ItemIDList: 50067
AvailQtyList: 8.000000000000,7.000000000000,4.000000000000,1.000000000000

struct
AVAILABLEQTY 4
HIGHLIGHTEDSKU 97488
VIP_member_discount 35
barcode 088612259207
barcode_type UPC
col1 6 in. x 9 in.
col1_sortorder 2130
col2 [empty string]
col3 [empty string]
cost 50.82
deal_of_the_week NO
description 6 in. x 9 in.
flags
array
1 1
group_id 10288
group_uname artograph-lightpad-light-boxes
id 97488
list_price 104.99
map YES
mfr_num 225-920
net_weight 3.63
non_member_discount 25
non_member_price 78.74
prop65 NO
ship_rule_desc STD
shipping STD
sku 97488
sku_pix YES
supplier_id 1
ta_dealer_a_price 56.69
ta_dealer_c_price 56.69
ta_price 83.99
text
array
1 97488
2 225-920
3 6 in. x 9 in.
timestamp 2015-03-27T14:48:40.2Z
vip_member_price 68.24

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 8.000000000000 65403
2 7.000000000000 65404
3 4.000000000000 97488
4 1.000000000000 97489
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] = '10288' 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.0.97

URL: www.misterart.com:/index.cfm:module=books-media&catB=painting&CatC=fp~8-17~&gr=dk-publishing-oil-painting-workshop.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 17:36:41'}
sessionid e030ebb48b1a51934a7a1a6721316a193e6e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=photography&catB=lightboxes&CatC=fb~artograph~&gr=artograph-lightpad-light-boxes.html
urltoken CFID=29743219&CFTOKEN=21556000&jsessionid=e030ebb48b1a51934a7a1a6721316a193e6e
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 17:36:41'}
sessionid e03039665525e9c5c2897931979b62621f35
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=painting&CatC=fp~8-17~&gr=dk-publishing-oil-painting-workshop.html
urltoken CFID=29743217&CFTOKEN=53567345&jsessionid=e03039665525e9c5c2897931979b62621f35
validationerror [empty string]


This addition to the Workshop series will show you how to use your oil paints to their best advantage. This simple and innovative guide makes oil painting achievable for everyone.

Filled with practical step-by-step instructions, this portable guide guarantees success.

Format: paperback, 128 pgs., 7 3/4 in. x 10 in.
Publisher: DK, 2006

Share on Facebook Twitter Pinterest

Ask a question about Oil-painting Workshop Ask a question about this product

Oil-painting Workshop

by DK Publishing

Why is the VIP Price not displayed for this product? MisterArt.com's goal is to provide our customers the lowest prices on all products we sell. Some manufacturers restrict retailers from displaying or promoting certain products at any price lower than a Minimum Advertised Price (MAP). It is MisterArt.com's policy to offer these products at their MAP price as our Non-Member Price. VIP Members will see the VIP Price after adding the product to the cart without any purchase obligation.









  Item# Image unit
Ascending
Manufacturer Number List Price
Non-Member
Price
VIP Member
Club Price
Quantity
Add to Favorites
65403
Oil-painting Workshop 12 in. x 17 in.
Zoom Image
12 in. x 17 in. 225-940 $259.99 $194.99 25% Off Click to See VIP Price ON SALE
Add to Favorites
65404
Oil-painting Workshop 17 in. x 24 in.
Zoom Image
17 in. x 24 in. 225-950 $365.00 $273.75 25% Off Click to See VIP Price ON SALE
Add to Favorites
97488
Oil-painting Workshop 6 in. x 9 in.
Zoom Image
6 in. x 9 in. 225-920 $104.99 $78.74 25% Off Click to See VIP Price ON SALE
Add to Favorites
97489
Oil-painting Workshop 9 in. x 12 in.
Zoom Image
9 in. x 12 in. 225-930 $159.99 $119.99 25% Off Click to See VIP Price Email When In Stock

Click the to add item to your Favorites.

Add to Cart


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

Canvasette Paper Canvas

by Bienfang

An economical alternative to canvas

Up to 48% Off

Economy Stretched Canvas

by Discovery

Great value on pre-stretched canvas

Up to 44% Off

Up to 61% 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 Oil-painting Workshop

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 Oil-painting Workshop

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