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 = 'Masterprints') 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


ImageCategory/SubcategoryTitleArtistMediumPrice
Marvel/MasterprintsVenom MasterprintBrothers HildebrandtMasterprints$20
Marvel/MasterprintsMasterprints - Captain AmericaBrothers HildebrandtMasterprints$20
Marvel/MasterprintsMasterprints - GambitBrothers HildebrandtMasterprints$20
Marvel/MasterprintsMasterprints - Human TorchBrothers HildebrandtMasterprints$20
Marvel/MasterprintsMasterprints - PsylockeBrothers HildebrandtMasterprints$20
Marvel/MasterprintsMasterprints - RogueBrothers HildebrandtMasterprints$20
Marvel/MasterprintsMasterprints - Silver SurferBrothers HildebrandtMasterprints$20
Marvel/MasterprintsMasterprints - ThingBrothers HildebrandtMasterprints$20
Marvel/MasterprintsMasterprints - VenomBrothers HildebrandtMasterprints$20
Marvel/MasterprintsMasterprints - WolverineBrothers HildebrandtMasterprints$20
Marvel/MasterprintsMasterprints - War Machine Brothers HildebrandtMasterprints$20
Marvel/MasterprintsMarvel Masterprints - Full Set of 10Brothers HildebrandtMasterprints$175
Star Wars/Shadows of the EmpireDarth Vader & Emperor Imperial PalaceBrothers HildebrandtMasterprints$10
Marvel/Masterprints   Captain America MasterprintBrothers HildebrandtMasterprints$10