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 '%' + 'Collectibles' +'%') OR (search LIKE '%' + 'DynamicForces' +'%') OR (search LIKE '%' + 'Lithographs' +'%') OR (search LIKE '%' + 'Prints' +'%') OR (search LIKE '%' + 'figurines' +'%')) ORDER BY Available DESC, qoh DESC, sort, price, catagory, subcatagory, artist, prodname


ImageCategory/SubcategoryTitleArtistMediumPrice
Prints and Posters/Poster Art   GI Joe Poster sketchGreg HildebrandtPencils - BW$40
Star Wars/Comic Art   Star Wars - Blank Variant Sketch #1Greg HildebrandtPencils - BW$50
Star Wars/Comic Art   Star Wars - Blank Variant Sketch #2Greg HildebrandtPencils - BW$50
Star Wars/Comic Art   Star Wars - Blank Variant Sketch #3Greg HildebrandtPencils - BW$50
Star Wars/Comic Art   Star Wars - Blank Variant Sketch #4Greg HildebrandtPencils - BW$50
Prints and Posters/Poster Art   GI Joe Poster sketchGreg HildebrandtPencils - BW$75
Marvel/Comic Art   Silver SurferBrothers HildebrandtPencils - BW$120
Comic Art/Comic Art   Dynamic Forces sketch for GI Joe lithographBrothers HildebrandtPencils - BW$150