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` = '342' ORDER BY `post_datetime` DESC LIMIT 14