Warning: ociexecute() [
function.ociexecute]: ORA-00936: missing expression in
/home/june/worldtee/mobile_v2/libs/class_oracle.php on line
140
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