SELECT tn_posts.title AS title,tn_posts.description AS description,tn_posts.slug AS slug,tn_posts.post_datetime AS post_datetime,date(tn_posts.post_datetime) AS ndate,tn_posts.excerpt AS excerpt,tn_images.image_name AS image_name,t.category_id,t.post_id,t.category_name,t.category_slug,t.category_type_id,t.category_color FROM ( SELECT category_id,post_id,tn_category.category_name,tn_category.slug as category_slug,tn_category.category_type_id,tn_category.color_code as category_color FROM tn_category JOIN tn_post_category_relation ON tn_category.id = tn_post_category_relation.category_id WHERE tn_category.id IN(7) ORDER BY post_id DESC LIMIT 30) AS t JOIN tn_posts ON tn_posts.id = t.post_id LEFT JOIN tn_post_images ON tn_post_images.post_id = tn_posts.id AND is_featured = 1 LEFT JOIN tn_images ON tn_images.id = tn_post_images.image_id LEFT JOIN tn_post_meta ON tn_post_meta.post_id = tn_posts.id AND tn_post_meta.meta_key='show_video_icon' WHERE tn_posts.publish_status = 1 AND tn_posts.post_type=1 GROUP BY tn_posts.id order by tn_posts.id desc LIMIT 30