GADGET

SELECT * FROM `posts` WHERE `channel_id` = '54' AND `status` = 1 AND published_at <='2021-10-29 01:41:47' AND `deleted` IS NULL ORDER BY `published_at` DESC LIMIT 30