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 ArtBlonde, White and Blue - ZIPPO LighterGreg HildebrandtLighters$50
Pinup Art/Pinup ArtFly Me to the Moon - Zippo LighterGreg HildebrandtLighters$50
Pinup Art/Pinup ArtKeep '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 ArtThe Ledge - Zippo LighterGreg HildebrandtLighters$50
Pinup Art/Pinup ArtWoody - Zippo LighterGreg HildebrandtLighters$50