SELECT jn_posts.id AS post_id,jn_posts.title, jn_posts.created_on, jn_posts.post_datetime, DATE(jn_posts.post_datetime) ndate, jn_images.image_name AS image_name, jn_programs.program_title,jn_programs.id AS program_id,program_slug FROM (SELECT category_id,post_id FROM jn_post_category_relation WHERE jn_post_category_relation.category_id != 14 ORDER BY post_id DESC LIMIT 0,22) AS t JOIN jn_posts ON jn_posts.id = t.post_id INNER JOIN jn_programs ON t.category_id = jn_programs.category_id LEFT JOIN jn_post_images ON jn_post_images.post_id = jn_posts.id AND is_featured=1 LEFT JOIN jn_images ON jn_images.id = jn_post_images.image_id WHERE jn_posts.publish_status=1 and jn_programs.publish_status=1 AND post_type=1 AND jn_posts.post_format=1 ORDER BY jn_posts.post_datetime DESC LIMIT 12