校園活動
2023-2024
SQL Error:
ORDER BY a_name, a_sort_id
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 a_is_news ='album' ORDER BY a_name, a_sort_id' at line 2
select a.alb_sys_id,a.alb_ac_id,a.alb_dt,a.alb_name,a.alb_cnt,a.alb_cover,b.a_path from album a
left join attachment b on a.alb_sys_id = b.a_ref_id where a.alb_sys_id= and a_is_news ='album' ORDER BY a_name, a_sort_id