SELECT CASE b.ref_par WHEN '02' THEN IFNULL(a.sys_fdr, b.sys_fdr) ELSE a.sys_fdr END AS sys_fdr, a.ref_par, a.sno, a.art_level,
a.art_head AS art_head, a.publish_sort
FROM `article` a
INNER JOIN `article` b ON a.art_level=b.sno
WHERE a.art_level=:level AND a.publish_status>0 AND SUBSTR(a.publish_lang,,1)=:lang
ORDER BY a.publish_sort DESCArray
(
[level] => 12
[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 MariaDB server version for the right syntax to use near '1)=?
ORDER BY a.publish_sort DESC' at line 5
You can find the error back in the log.