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.