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 22 products were found in the following 6 mediums: Mixed Medium (4)   Paintings - Acrylic (11)   Paintings - Oil (1)   Paintings - Watercolor (1)   Pencils - BW (5)   Image Category/Subcategory Title Artist Medium Price Fantasy/Pinup Art   Perseus and Andromeda Greg Hildebrandt Pencils - BW $150 Pinup Art/Pinup Art   Pedal Pushers - Final Sketch Greg Hildebrandt Pencils - BW $150