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 = '3D Art') 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
Tolkien/Lord of the RingsDemon WrathBrothers Hildebrandt3D Art$60
Tolkien/Lord of the RingsFinal StrikeBrothers Hildebrandt3D Art$60
Tolkien/Lord of the Rings#7 - Harnessing EvilBrothers Hildebrandt3D Art$60
Tolkien/Lord of the Rings#8 - Valiant LeapBrothers Hildebrandt3D Art$60
Tolkien/Lord of the RingsConquest of the BeastBrothers Hildebrandt3D Art$60
Tolkien/Lord of the RingsGandalf - Franklin Mint DollGreg Hildebrandt3D Art$300
Prints and Posters/Kid StuffSaid the Spider to the Fly - 3D PrintGreg Hildebrandt3D Art$750
Tolkien/Lord of the Rings   #9 - Dark TowerBrothers Hildebrandt3D Art$60
Tolkien/Lord of the Rings   Battle of Fury's FireBrothers Hildebrandt3D Art$60
Tolkien/Lord of the Rings   Battle of ValorBrothers Hildebrandt3D Art$60
Tolkien/Lord of the Rings   Brave AdversaryBrothers Hildebrandt3D Art$60
Tolkien/Lord of the Rings   Conqueror's SpellBrothers Hildebrandt3D Art$60
Tolkien/Lord of the Rings   Demon SlayerBrothers Hildebrandt3D Art$60
Tolkien/Lord of the Rings   Ocean's TreasureBrothers Hildebrandt3D Art$60
Tolkien/Lord of the Rings   Pillar of StrengthBrothers Hildebrandt3D Art$60
Tolkien/Lord of the Rings   Revenge of MadfuryBrothers Hildebrandt3D Art$60
Dolls and Figurines/Fantasy   Dragon Fire - Hidden Shrine Incense burnerBrothers Hildebrandt3D Art$200
Dolls and Figurines/Fantasy   Dragon Fire Incense BurnerBrothers Hildebrandt3D Art$200
Dolls and Figurines/Fantasy   Dragon Fire Sphere of Light Candle HolderBrothers Hildebrandt3D Art$200
Dolls and Figurines/Tolkien   Arwen - Franklin Mint DollGreg Hildebrandt3D Art$300