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 = 'Mixed Medium') 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
Trans-Siberian Orchestra/Night CastleMorpheus is at Your Side #2Greg HildebrandtMixed Medium$30
Trans-Siberian Orchestra/Night CastleNight Castle explosionGreg HildebrandtMixed Medium$200
Childrens Art/Fairy TalesBrothers Grimm Fairy Tales- Hansel and Gretel p1-2Greg HildebrandtMixed Medium$600
Trans-Siberian Orchestra/Night Castle   Night Castle color roughGreg HildebrandtMixed Medium$45
Trans-Siberian Orchestra/Night Castle   TSO TracersGreg HildebrandtMixed Medium$45
Trans-Siberian Orchestra/Night Castle   TSO 2009 Wolf #2Greg HildebrandtMixed Medium$50
Tolkien/Lord of the Rings   Balrog RemarqueBrothers HildebrandtMixed Medium$350
Tolkien/Lord of the Rings   Orc RemarqueBrothers HildebrandtMixed Medium$350
Childrens Art/Fairy Tales   Brothers Grimm Fairy Tales- Hansel and Gretel p5-6Greg HildebrandtMixed Medium$600
Trans-Siberian Orchestra/Night Castle   Morpheus #2 - Black BoardGreg HildebrandtMixed Medium$700
Tolkien/Lord of the Rings   Tolkien "A" RemarqueBrothers HildebrandtMixed Medium$850
Tolkien/Lord of the Rings   Tolkien "B" RemarqueBrothers HildebrandtMixed Medium$850
Personal Art/Gallery Piece   Drinking Buddies: Blood of the PeopleGreg HildebrandtMixed Medium$1500
Pinup Art/Pinup Art   Hey Kitty, Kitty - Black BoardGreg HildebrandtMixed Medium$2500