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


ImageCategory/SubcategoryTitleArtistMediumPrice
Marvel/Prints   Iron Man Takes FlightMike KunglCanvas Prints$475
Marvel/Prints   The Incredible Hulk #377Dale KeownCanvas Prints$650
Marvel/Comic Art   X-Men VisionariesJim LeeCanvas Prints$750
Marvel/Prints   Secret InvasionGabrielle DellCanvas Prints$775
Marvel/Prints   Astonishing X-Men 25Simone BianchiCanvas Prints$775
Marvel/Prints   Captain America #100Jack KirbyCanvas Prints$850
Marvel/Prints   Fantastic Four #49Jack KirbyCanvas Prints$850
Marvel/Prints   X-Men HeroesJim LeeCanvas Prints$975
Marvel/Prints   X-Men VillainsJim LeeCanvas Prints$975
Marvel/Prints   Spider-Man 19Steve DitkoCanvas Prints$975
Tolkien/Lord of the RingsGift of the Elf Queen - Custom OrderGreg HildebrandtCanvas Prints$200
Tolkien/Lord of the RingsRing of the Elf Queen - Custom OrderGreg HildebrandtCanvas Prints$200