SELECT * FROM ( SELECT sys_fdr, ref_par, sno, art_level, art_head AS art_head, publish_sort, null AS thum FROM `article` WHERE art_level=1 AND (sno NOT IN (6,22)) AND publish_status=1 AND SUBSTR(publish_lang,,1)=:lang1 UNION all (SELECT a.sys_fdr, a.ref_par, a.sno, a.art_level, CONCAT(a.art_head, '', IFNULL(a.art_year,'') ,'') AS art_head , 40 AS publish_sort, CONCAT('../', c.anx_fdr, c.anx_file, c.anx_ext) AS thum FROM `article` a INNER JOIN `article` b ON a.art_level=b.sno LEFT JOIN `annex` c ON a.sno=c.anx_ref AND c.ref_at='03' WHERE ((a.art_level=4 AND a.publish_status=2) OR (a.sno=22 AND a.publish_status=1)) AND SUBSTR(a.publish_lang,,1)=:lang2 LIMIT 0, 3) UNION all (SELECT art_rmk1 AS sys_fdr, '06' AS ref_par, art_field1 AS sno, art_level, CONCAT('Video Dance', '', art_head,'') AS art_head, 50 AS publish_sort, art_field2 AS thum FROM `article` WHERE art_level=6 AND publish_status=2 AND SUBSTR(publish_lang,,1)=:lang3 LIMIT 0, 0) ) m ORDER BY m.publish_sortArray ( [lang1] => [lang2] => [lang3] => ) 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 MariaDB server version for the right syntax to use near '1)=? UNION all (SELECT a.sys_fdr, a.ref_par, a.sno, a.art_level, CON...' at line 3
You can find the error back in the log.