SELECT dp.*, CASE WHEN length(dp.post_expire_date) = 8 THEN CONCAT(dp.post_expire_date, '000000') ELSE dp.post_expire_date END AS expire_date, CASE WHEN length(dp.post_start_date) = 8 THEN CONCAT(dp.post_start_date, '000000') ELSE dp.post_start_date END AS start_date FROM `data_posts` AS dp, `users_data` AS ud, `subscription_types` AS st WHERE dp.user_id = ud.user_id AND ud.subscription_id = st.subscription_id AND dp.post_status = '1' AND ud.active = '2' AND st.data_settings LIKE '%74%' AND dp.data_type = '20' AND dp.data_id = '74' AND (
dp.post_title LIKE "%Plant-Based%" OR
dp.post_tags LIKE "%Plant-Based%" OR
dp.post_content LIKE "%Plant-Based%" ) GROUP BY dp.post_id HAVING (expire_date >= '20250315' OR expire_date = '') ORDER BY dp.post_live_date DESC