AUSTRALIA

SELECT * FROM `posts` WHERE `channel_id` = '29' AND `status` = 1 AND published_at <='2019-09-18 08:41:49' AND `deleted` IS NULL ORDER BY `published_at` DESC LIMIT 30