SELECT t_mailmagazine.uid,t_mailmagazine.title,t_mailmagazine.web_comment,t_mailmagazine.img,t_mailmagazine.disp_start_date,t_mailmaga_category.category_uid 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/05/20 08:39:11' AND t_mailmagazine.disp_end_date >= '2024/05/20 08:39:11') GROUP BY t_mailmagazine.uid ORDER BY t_mailmagazine.disp_start_date DESC