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 (medium = 'Pencils - BW') AND ((search LIKE '%' + 'kong' +'%')) ORDER BY Available DESC, qoh DESC, sort, price, catagory, subcatagory, artist, prodname


ImageCategory/SubcategoryTitleArtistMediumPrice
Classics/King KongKING KONG Sacrifice AltarGreg HildebrandtPencils - BW$131
Entertainment/King KongKurious Kong #2Greg HildebrandtPencils - BW$300
Classics/Poster ArtKing KongBrothers HildebrandtPencils - BW$1800
Classics/King Kong   King Kong vs the T-RexGreg HildebrandtPencils - BW$140
Classics/King Kong   KING KONG vs the PTERANODON!Greg HildebrandtPencils - BW$200
Classics/King Kong   King KongGreg HildebrandtPencils - BW$225
Classics/King Kong   KING KONG Altar Sacrifice #2Greg HildebrandtPencils - BW$225
Classics/King Kong   King KongGreg HildebrandtPencils - BW$250
Classics/King Kong   KING KONG on EMPIRE STATE BUILDING #3!Greg HildebrandtPencils - BW$250