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


ImageCategory/SubcategoryTitleArtistMediumPrice
September 11 Tribute/September 11 TributeThe Last Full Measure of Devotion - Print - 22 X 34Brothers HildebrandtPrints$35
September 11 Tribute/September 11 Tribute   New Yorks Finest Print - Print - 23 x 35Brothers HildebrandtPrints$35
September 11 Tribute/September 11 Tribute   The Day the Angels Cried - Print - 34 X 24Brothers HildebrandtPrints$35