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 = 'Paintings - Acrylic') AND ((search LIKE '%' + 'kong' +'%')) ORDER BY Available DESC, qoh DESC, sort, price, catagory, subcatagory, artist, prodname


ImageCategory/SubcategoryTitleArtistMediumPrice
Fantasy/Commissioned Art   King KongGreg HildebrandtPaintings - Acrylic$5000
Entertainment/What If   What If? - King Kong Greg HildebrandtPaintings - Acrylic$60000