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,16) 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 6
Rukhsati Episode, Rukhsati Drama Cast, Rukhsati Schedule, Rukhsati OST