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 ((search LIKE '%' + 'p-38' +'%')) ORDER BY Available DESC, qoh DESC, sort, price, catagory, subcatagory, artist, prodname Image Category/Subcategory Title Artist Medium Price Pinup Art/Clothing Keep 'Em Flying - T-Shirt - Large Greg Hildebrandt T-shirts $25 Pinup Art/Clothing Keep 'Em Flying - T-Shirt - Large Greg Hildebrandt T-shirts $25 Pinup Art/Clothing   Keep 'Em Flying - T-Shirt - XL Greg Hildebrandt T-shirts $25 Pinup Art/Pinup Art   Thoughts of Midnite Greg Hildebrandt Pencils - BW $150 Pinup Art/pinup art   Thoughts of Midnite Greg Hildebrandt Pencils - BW $225 Portraits/Portraits   P-38 Lighting PINUP Greg Hildebrandt Pencils - BW $750 Pinup Art/Pinup Art   Thoughts of Midnite P38 Nose Cone WWII Greg Hildebrandt Paintings - Acrylic $25000