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 '%' + '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 12 products were found. Image Category/Subcategory Title Artist Medium Price Marvel/Prints   Iron Man Takes Flight Mike Kungl Canvas Prints $475 Marvel/Prints   The Incredible Hulk #377 Dale Keown Canvas Prints $650 Marvel/Comic Art   X-Men Visionaries Jim Lee Canvas Prints $750 Marvel/Prints   Secret Invasion Gabrielle Dell Canvas Prints $775 Marvel/Prints   Astonishing X-Men 25 Simone Bianchi Canvas Prints $775 Marvel/Prints   Captain America #100 Jack Kirby Canvas Prints $850 Marvel/Prints   Fantastic Four #49 Jack Kirby Canvas Prints $850 Marvel/Prints   X-Men Heroes Jim Lee Canvas Prints $975 Marvel/Prints   X-Men Villains Jim Lee Canvas Prints $975 Marvel/Prints   Spider-Man 19 Steve Ditko Canvas Prints $975 Tolkien/Lord of the Rings Gift of the Elf Queen - Custom Order Greg Hildebrandt Canvas Prints $200 Tolkien/Lord of the Rings Ring of the Elf Queen - Custom Order Greg Hildebrandt Canvas Prints $200