SELECT `jn_posts`.`id` AS `post_id`, `jn_posts`.`title` AS `title`, `jn_posts`.`description` AS `description`, `jn_posts`.`sequence` AS `sequence`, `jn_posts`.`slug` AS `post_slug`, `jn_posts`.`slug` AS `slug`, `jn_posts`.`post_datetime` AS `post_datetime`, `jn_posts`.`excerpt` AS `excerpt`, `jn_posts`.`post_type` AS `post_type`, `jn_image_gallery`.`images` AS `images`, `jn_image_gallery`.`images` AS `image_name`, `jn_post_author_relation`.`author_id` AS `author_id`, `jn_authers`.`full_name` AS `author_name`, `jn_authers`.`slug` AS `author_slug`
FROM `jn_posts`
LEFT JOIN `jn_image_gallery` ON `jn_image_gallery`.`post_id` = `jn_posts`.`id`
LEFT JOIN `jn_post_author_relation` ON `jn_post_author_relation`.`post_id` = `jn_posts`.`id`
LEFT JOIN `jn_authers` ON `jn_authers`.`id` = `jn_post_author_relation`.`author_id`
WHERE `jn_posts`.`publish_status` = 1
AND `jn_post_author_relation`.`author_id` = '150'
ORDER BY `post_datetime` DESC
LIMIT 14
Muhammad Mehdi Column - Urdu Columns Pakistan | Jang Columns
|
|
