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 '%' + 'kong' +'%')) ORDER BY Available DESC, qoh DESC, sort, price, catagory, subcatagory, artist, prodname

20 products were found in the following 4 mediums:
Prints (9)   Pencils - BW (9)   Paintings - Acrylic (1)   Paintings - Oil (1)   Show all mediums

ImageCategory/SubcategoryTitleArtistMediumPrice
Classics/King KongKING KONG Sacrifice AltarGreg HildebrandtPencils - BW$131
Classics/King KongKing Kong vs the T-RexGreg HildebrandtPencils - BW$200
Entertainment/King KongKurious Kong #2Greg HildebrandtPencils - BW$300
Classics/Poster ArtKing KongBrothers HildebrandtPencils - BW$1800
Classics/King KongKing Kong The Eighth Wonder Of The WorldMark RomanoskiPaintings - Oil$3500
Classics/King Kong   Kong and PterodactylByron CrabbePrints$350
Classics/King Kong   Kong at WindowByron CrabbePrints$350
Classics/King Kong   Kong in StadiumByron CrabbePrints$350
Classics/King Kong   Kong Raises CarByron CrabbePrints$350
Classics/King Kong   Kong of Skull IslandJoe DeVitoPrints$350
Classics/King Kong   Kong on TopJoe DeVitoPrints$350
Classics/King Kong   Kong VictoriousJoe DeVitoPrints$350
Classics/King Kong   King Kong - Empire StateMario LarrinagaPrints$350
Classics/King Kong   King Kong - Empire StateMario LarrinagaPrints$750
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
Fantasy/Commissioned Art   King KongGreg HildebrandtPaintings - Acrylic$5000