SQL (select a.*,b.code_name as code_name1,c.code_name as code_name2,d.code_name as code_name3, (select CONCAT(file_path, '/', up_re_file) from tbl_site_file where tbl_site_file.file_code='tour_data' and a.no=tbl_site_file.tbl_no order by sort ASC limit 1) as list_file_img from tour_data a left join site_code b on a.code_no1=b.no left join site_code c on a.code_no2=c.no left join site_code d on a.arge_code=d.no where 1=1 and a.tour_type='2' and a.state_yn='Y' order by a.best_yn DESC,a.hit%20DESC limit 48, 8) 쿼리 가 잘못되었습니다. 다시 한번 확인해 보십시오.
 
[이전 화면]