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 Image Category/Subcategory Title Artist Medium Price Marvel/Masterprints Masterprints - Rogue Brothers Hildebrandt Masterprints $30 Marvel/Masterprints Masterprints - Thing Brothers Hildebrandt Masterprints $30 Marvel/Masterprints Masterprints - Human Torch Brothers Hildebrandt Masterprints $30 Marvel/Masterprints Masterprints - Psylocke Brothers Hildebrandt Masterprints $30 Marvel/Masterprints Masterprints - War Machine Brothers Hildebrandt Masterprints $30 Marvel/Masterprints Masterprints - Silver Surfer Brothers Hildebrandt Masterprints $30 Marvel/Masterprints Masterprints - Captain America Brothers Hildebrandt Masterprints $30 Marvel/Masterprints Masterprints - Wolverine Brothers Hildebrandt Masterprints $30 Marvel/Masterprints Venom Masterprint Brothers Hildebrandt Masterprints $35 Marvel/Masterprints Masterprints - Gambit Brothers Hildebrandt Masterprints $30 Marvel/Masterprints Masterprints - Venom Brothers Hildebrandt Masterprints $30 Marvel/Masterprints Marvel Masterprints - Full Set of 10 Brothers Hildebrandt Masterprints $250 Star Wars/Shadows of the Empire Darth Vader & Emperor Imperial Palace Brothers Hildebrandt Masterprints $40 Marvel/Masterprints   Captain America Masterprint Brothers Hildebrandt Masterprints $10