SQL Error:
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 'OR news_ac_id_2 = OR news_ac_id_3 = ) ) AS tbMix ORDER ...' at line 1
SELECT *
FROM ( SELECT `alb_dt`
AS alb_dt , `alb_sort_id`
AS alb_sort_id , 'album'
AS dataTable , `alb_sys_id`
AS alb_sys_id , `alb_id`
AS alb_id , `alb_lang`
AS alb_lang , `alb_ac_id`
AS alb_ac_id , `alb_show_date`
AS alb_show_date , `alb_tp`
AS alb_tp , `alb_name`
AS alb_name , `alb_intro`
AS albl_intro , `alb_cover`
AS alb_cover , `alb_url`
AS alb_url , `alb_blank`
AS alb_blank , ''
AS news_pdf , `alb_need_login`
AS alb_need_login , `ac_need_login`
AS ac_need_login
FROM album
LEFT JOIN album_cate
ON ac_lang
= alb_lang
AND ac_id
= alb_ac_id
WHERE alb_lang
= 'tc'
UNION SELECT `news_dt`
AS alb_dt , `news_sort_id`
AS alb_sort_id , 'news'
AS dataTable , `news_sys_id`
AS alb_sys_id, `news_id`
AS alb_id, `news_lang`
AS alb_lang, `news_nc_id`
AS alb_ac_id , 'Y'
AS alb_show_date , `news_tp`
AS alb_tp , `news_name`
AS alb_name, `news_intro`
AS albl_intro , `news_cover`
AS alb_cover , `news_url`
AS alb_url , `news_blank`
AS alb_blank , `news_pdf`
AS news_pdf , `news_need_login`
AS alb_need_login , `nc_need_login`
AS ac_need_login
FROM news
LEFT JOIN news_cate
ON nc_lang
= news_lang
AND nc_id
= news_nc_id
WHERE news_lang
= 'tc'
AND ( news_ac_id_1
= OR news_ac_id_2
= OR news_ac_id_3
= ) ) AS tbMix
ORDER BY 1 DESC , 2
LIMIT 0 , 12
