SELECT mnu_uid , msg_no , msg_idx , msg_subject ,msg_del_type , 'prev' as dirc FROM ( SELECT b.mnu_uid,msg_idx ,b.msg_no,msg_subject,msg_del_type FROM dn_msg b INNER JOIN dn_msgcontent c ON b.mnu_uid = c.mnu_uid AND b.msg_no = c.msg_no WHERE b.mnu_uid = 308 AND (( msg_idx = AND msg_re_idx < ) OR ( msg_idx > )) AND msg_del_type = 0 ORDER BY msg_idx ASC, msg_re_idx DESC LIMIT 1 ) A UNION SELECT mnu_uid , msg_no , msg_idx , msg_subject ,msg_del_type , 'next' as dirc FROM ( SELECT b.mnu_uid,msg_idx ,b.msg_no, msg_subject, msg_del_type FROM dn_msg b INNER JOIN dn_msgcontent c ON b.mnu_uid = c.mnu_uid AND b.msg_no = c.msg_no WHERE b.mnu_uid = 308 AND (( msg_idx = AND msg_re_idx > ) OR ( msg_idx < )) AND msg_del_type = 0 ORDER BY msg_idx DESC, msg_re_idx ASC LIMIT 1 ) B
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 'AND msg_re_idx < ) OR ( msg_idx > )) AND msg_del_type = 0 ...' at line 5