select distinct h.*, s.sort_no, s.spa_cd, s.spa_nm, s.spa_kana, s.info1, p.pref_cd, p.pref_nm, p.sort_no, p.spa_link_flg from mst_hotel h left outer join mst_spa s on h.spa_cd = s.spa_cd left outer join mst_pref p on s.pref_cd = p.pref_cd left outer join mst_hotel_plan_type pt on h.hotel_cd = pt.hotel_cd left outer join mst_plan_type mpt on pt.plan_type_cd = mpt.plan_type_cd left outer join mst_plan pln on (h.hotel_cd = pln.hotel_cd and pln.disp_flg = '1') left outer join mst_plan_plan_link lnk on (pln.hotel_cd = lnk.hotel_cd and pln.plan_no = lnk.plan_no) left outer join mst_plan_charge_title ttl on (pln.hotel_cd = ttl.hotel_cd and pln.plan_no = ttl.plan_no) where h.disp_flg = '1' and h.spa_cd = '72' and (p.pref_nm like '%�ޥ�ġ��ޥ�ץ��%' or s.spa_nm like '%�ޥ�ġ��ޥ�ץ��%' or s.spa_kana like '%�ޥ�ġ��ޥ�ץ�ï¿?%' or h.hotel_nm like '%�ޥ�ġ��ޥ�ץ��%' or h.hotel_kana like '%�ޥ�ġ��ޥ�ץ�ï¿?%' or h.address like '%�ޥ�ġ��ޥ�ץ��%' or h.access like '%�ޥ�ġ��ޥ�ץ��%' or h.catch like '%�ޥ�ġ��ޥ�ץ��%' or h.inv_comment like '%�ޥ�ġ��ޥ�ץ��%' or h.notice like '%�ޥ�ġ��ޥ�ץ��%' or h.recom1 like '%�ޥ�ġ��ޥ�ץ��%' or h.gooddeal like '%�ޥ�ġ��ޥ�ץ��%' or (h.notice <> '' and 'Åö´Û¤Î¿··¿¥³¥í¥Ê¥¦¥¤¥ë¥¹´¶À÷¾ÉÂкö¤Ë¤Ä¤¤¤Æ' like '%�ޥ�ġ��ޥ�ץ��%') or pln.plan_nm like '%�ޥ�ġ��ޥ�ץ��%' or mpt.plan_type_nm like '%�ޥ�ġ��ޥ�ץ��%' or pln.rsv_gift like '%�ޥ�ġ��ޥ�ץ��%' or pln.remarks like '%�ޥ�ġ��ޥ�ץ��%' or pln.free_drink like '%�ޥ�ġ��ޥ�ץ��%' or pln.keyword like '%�ޥ�ġ��ޥ�ץ��%' or pln.capture like '%�ޥ�ġ��ޥ�ץ��%' or pln.benefits like '%�ޥ�ġ��ޥ�ץ��%' or pln.add_item like '%�ޥ�ġ��ޥ�ץ��%' or ttl.charge_nm like '%�ޥ�ġ��ޥ�ץ��%' ) order by h.sort_no_all, p.sort_no, s.sort_no, s.spa_cd, h.sort_no, h.hotel_cd