Page: /surf/tourlist.php
Query: select distinct b.country_no, nvl(decode(':lang','KR',h.name,i.name),h.name) as country_name from surf_tour a left join surf_user b on a.no_user = b.no left join code h on h.no = b.country_no left join code_lang i on i.no=h.no and i.lang=:lang where nvl(country_no,0) > 10000 and a.cd_city = order by country_name