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
Pinup Art/Pinup Art   Blonde, White and Blue - ZIPPO LighterGreg HildebrandtLighters$50
Pinup Art/Pinup Art   Fly Me to the Moon - Zippo LighterGreg HildebrandtLighters$50
Pinup Art/Pinup Art   Keep 'Em Flying - Zippo LighterGreg HildebrandtLighters$50
Pinup Art/Pinup ArtLicense to Kill - Zippo LighterGreg HildebrandtLighters$50
Pinup Art/Pinup ArtOverheated - ZIPPO LighterGreg HildebrandtLighters$50
Pinup Art/Pinup ArtRound 15 - Zippo LighterGreg HildebrandtLighters$50
Pinup Art/Pinup Art   The Ledge - Zippo LighterGreg HildebrandtLighters$50
Pinup Art/Pinup Art   Woody - Zippo LighterGreg HildebrandtLighters$50