java.lang.NullPointerExceptionselect distinct shopkeyword.keycode,keyword.keyword from shopkeyword,keyword where shopkeyword.shopid = any ( select tenpo.shopid from tenpo where tenpo.available=1 and ( tenpo.line1 like '%田園調布%' or tenpo.line2 like '%田園調布%' or tenpo.line3 like '%田園調布%' or tenpo.station1 like '%田園調布%' or tenpo.station2 like '%田園調布%' or tenpo.station3 like '%田園調布%' or tenpo.stationmemo1 like '%田園調布%' or tenpo.stationmemo2 like '%田園調布%' or tenpo.stationmemo3 like '%田園調布%' ) ) and shopkeyword.keycode=keyword.keycode もどる