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 = 'Tin Signs') AND ((search LIKE '%' + 'FLAMING' +'%') AND (search LIKE '%' + 'JUNE' +'%')) ORDER BY Available DESC, qoh DESC, sort, price, catagory, subcatagory, artist, prodname Image Category/Subcategory Title Artist Medium Price Pinup Art/Pinup Art Flaming June - Vintage Tin Sign - Square - Small Greg Hildebrandt Tin Signs $35 Pinup Art/Pinup Art Flaming June - Vintage Tin Sign - Square - Extra-Large Greg Hildebrandt Tin Signs $150 Pinup Art/Pinup Art Flaming June - Vintage Tin Sign - Round - Small Greg Hildebrandt Tin Signs $45 Pinup Art/Pinup Art Flaming June - Vintage Tin Sign - Square - Large Greg Hildebrandt Tin Signs $50 Pinup Art/Pinup Art Flaming June - Vintage Tin Sign - Round - Large Greg Hildebrandt Tin Signs $100