1 Products Query = SELECT artlist.sku, artlist.prodname, artlist.artist, artlist.medium, artlist.price, artlist.qoh, artlist.catagory, artlist.subcatagory, artlist.sort, artlist.thumb FROM artlist WHERE originalprice<>0 ORDER BY sort, price, artist, catagory, subcatagory, prodname
ImageCategory/SubcategoryTitleArtistMediumPrice
Puzzles/Product Art   Joker's WildGreg Hildebrandt3D Art$10
Pinup Art/ClothingAlien Abduction - Mask Greg Hildebrandt3D Art$12
Pinup Art/ClothingClassic Motors - MaskGreg Hildebrandt3D Art$12
Pinup Art/ClothingEye Candy - MaskGreg Hildebrandt3D Art$12
Pinup Art/ClothingHot Rod - MaskGreg Hildebrandt3D Art$12
Pinup Art/ClothingKeep Em Flying - MaskGreg Hildebrandt3D Art$12
Pinup Art/ClothingKeys to Your Heart - MaskGreg Hildebrandt3D Art$12
Pinup Art/ClothingLiquor Guns and Ammo - MaskGreg Hildebrandt3D Art$12
Pinup Art/ClothingMade in the USA - MaskGreg Hildebrandt3D Art$12
Pinup Art/ClothingMidnight Lace - MaskGreg Hildebrandt3D Art$12
Pinup Art/ClothingRosie the Riveter - MaskGreg Hildebrandt3D Art$12
Pinup Art/ClothingScience Gone Wild - MaskGreg Hildebrandt3D Art$12
Tolkien/Lord of the Rings   #7 - Harnessing EvilBrothers Hildebrandt3D Art$35
Tolkien/Lord of the Rings   #8 - Valiant LeapBrothers Hildebrandt3D Art$35
Tolkien/Lord of the Rings   Conquest of the BeastBrothers Hildebrandt3D Art$35
Tolkien/Lord of the Rings   Demon WrathBrothers Hildebrandt3D Art$35
Tolkien/Lord of the Rings   Final StrikeBrothers Hildebrandt3D Art$35
Tolkien/Lord of the Rings   Triumph At SeaBrothers Hildebrandt3D Art$35