SELECT artlist.sku, artlist.prodname, artlist.artist, artlist.medium, artlist.price, artlist.qoh, artlist.catagory, artlist.subcatagory, artlist.originalprice, thumb FROM artlist WHERE Discontinued is null AND (medium = 'Pencils - BW') AND ((search LIKE '%' + 'prints' +'%')) ORDER BY Available DESC, qoh DESC, sort, price, catagory, subcatagory, artist, prodname
Image | Category/Subcategory | Title | Artist | Medium | Price | | Prints and Posters/Poster Art |   GI Joe Poster sketch | Greg Hildebrandt | Pencils - BW | $40 | | Prints and Posters/Poster Art |   GI Joe Poster sketch | Greg Hildebrandt | Pencils - BW | $75 | | Marvel/Comic Art |   Silver Surfer | Brothers Hildebrandt | Pencils - BW | $120 |
|