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
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 RingsDemon WrathBrothers Hildebrandt3D Art$35
Tolkien/Lord of the Rings   Final StrikeBrothers Hildebrandt3D Art$35
Tolkien/Lord of the RingsTriumph At SeaBrothers Hildebrandt3D Art$35