SELECT artlist.sku, artlist.prodname, artlist.artist, artlist.medium, artlist.price, artlist.qoh, artlist.catagory, artlist.subcatagory, artlist.originalprice, thumb FROM artlist WHERE Discontinued is null AND ((search LIKE '%' + 'FLAMING' +'%') AND (search LIKE '%' + 'JUNE' +'%')) ORDER BY Available DESC, qoh DESC, sort, price, catagory, subcatagory, artist, prodname

9 products were found in the following 3 mediums:
Prints (3)   Tin Signs (5)   Paintings - Acrylic (1)   Show all mediums

ImageCategory/SubcategoryTitleArtistMediumPrice
Personal Art/Pinup ArtFlaming June - Photo Print - SmallGreg HildebrandtPrints$15
Pinup Art/Pinup ArtFlaming June - Vintage Tin Sign - Square - SmallGreg HildebrandtTin Signs$35
Pinup Art/Pinup ArtFlaming June - Vintage Tin Sign - Square - Extra-LargeGreg HildebrandtTin Signs$150
Pinup Art/Pinup ArtFlaming June - Vintage Tin Sign - Round - SmallGreg HildebrandtTin Signs$45
Pinup Art/Pinup ArtFlaming June - Vintage Tin Sign - Square - LargeGreg HildebrandtTin Signs$50
Pinup Art/Pinup ArtFlaming June - Vintage Tin Sign - Round - LargeGreg HildebrandtTin Signs$100
Pinup Art/Gallery PieceFlaming June - Beautiful Self EditionGreg HildebrandtPrints$25
Personal Art/Pinup ArtFlaming June - Photo Print - LargeGreg HildebrandtPrints$35
Personal Art/Commissioned Art   Flaming June - After Lord Frederick LeightonGreg HildebrandtPaintings - Acrylic$20000