SELECT m.*, p.parent_en, p.parent_nm, p.parent_fdr, p.root_nm, p.root_no, r1.anx_fdr, r1.anx_file, r1.anx_ext, r1.anx_size, r1.ref_at FROM `article` m INNER JOIN (SELECT x1.sno AS parent_no, x1.art_head2 AS parent_en, x1.art_head AS parent_nm, IFNULL(x2.sno,1) AS root_no, x2.art_head AS root_nm, IFNULL(x1.sys_fdr, x2.sys_fdr) AS parent_fdr FROM `article` x1 LEFT JOIN `article` x2 ON x1.art_level=x2.sno) p ON m.art_level=p.parent_no LEFT JOIN `annex` r1 ON m.sno=r1.anx_ref AND r1.ref_at='04' WHERE SUBSTR(m.publish_lang,,1)=:lang AND m.sno=:snoArray ( [sno] => 6 [lang] => ) Unhandled Exception.
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1)=? AND m.sno=?' at line 7
You can find the error back in the log.