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
Magic The Gathering/7th Edition   Coal FlingerMark RomanoskiPaintings - Acrylic$350
Magic The Gathering/Prophesy   Search for SurvivorsMark RomanoskiPaintings - Acrylic$575
Magic The Gathering/Prophesy   Mercenary InformerNelson DeCastroPaintings - Acrylic$750
Magic The Gathering/Mercadian Masques   EmbargoNelson DeCastroPaintings - Acrylic$800