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

8 products were found.
ImageCategory/SubcategoryTitleArtistMediumPrice
Trans-Siberian Orchestra/EntertainmentTrans-Siberian Orchestra 2016 Program Book - WESTGreg HildebrandtBooks$5
Trans-Siberian Orchestra/EntertainmentTrans-Siberian Orchestra 2015 Program - WestGreg HildebrandtBooks$5
Trans-Siberian Orchestra/EntertainmentTrans-Siberian Orchestra 2018 Program Book - WESTGreg HildebrandtBooks$5
Trans-Siberian Orchestra/EntertainmentTrans-Siberian Orchestra 2018 Program Book - EASTGreg HildebrandtBooks$5
Trans-Siberian Orchestra/Entertainment   Trans-Siberian Orchestra 2016 Program Book - EASTGreg HildebrandtBooks$5
Classics/Entertainment   Film Fax #121Greg HildebrandtBooks$20
Star Wars/Entertainment   Film Fax #122Brothers HildebrandtBooks$20
Fantasy/Paperback   The Brothers Hildebrandt fanzineBrothers HildebrandtBooks$45