SELECT t_mailmagazine.uid,t_mailmagazine.title FROM t_mailmagazine LEFT JOIN t_mailmaga_category ON t_mailmaga_category.mailmaga_uid=t_mailmagazine.uid WHERE t_mailmagazine.kbn = '1' AND t_mailmagazine.send_kbn <> '9' AND t_mailmagazine.disp_start_date <= '2024/03/29 00:50:12' AND t_mailmagazine.disp_end_date >= '2024/03/29 00:50:12') ORDER BY t_mailmagazine.disp_start_date DESC