SELECT `posts`.`id`, `posts`.`lang_id`, `posts`.`title`, `posts`.`slug`, `posts`.`summary`, `posts`.`category_id`, `posts`.`image_id`, `posts`.`slider_order`, `posts`.`featured_order`, `posts`.`post_type`, `posts`.`image_url`, `posts`.`user_id`, `posts`.`pageviews`, `posts`.`post_url`, `posts`.`comment_count`, `posts`.`updated_at`, `posts`.`created_at`, `posts`.`is_paid`, (SELECT CONCAT('img_bg::', `i`.`image_big`, '||', 'img_df::', `i`.`image_default`, '||', 'img_sl::', `i`.`image_slider`, '||', 'img_md::', `i`.`image_mid`, '||', 'img_sm::', `i`.`image_small`, '||', 'img_mi::', `i`.`image_mime`, '||', 'img_st::', i.storage) FROM images i WHERE i.id = posts.image_id LIMIT 1) AS image_data, `categories`.`name` AS `category_name`, `categories`.`slug` AS `category_slug`, `categories`.`color` AS `category_color`, `users`.`username` AS `author_username`, `users`.`slug` AS `author_slug`, `users`.`avatar` AS `author_avatar` FROM `posts` USE INDEX (idx_posts_profile) JOIN `categories` ON `categories`.`id` = `posts`.`category_id` LEFT JOIN `users` ON `users`.`id` = `posts`.`user_id` LEFT JOIN `users` `authors2` ON `authors2`.`id` = `posts`.`author2_user_id` LEFT JOIN `users` `authors3` ON `authors3`.`id` = `posts`.`author3_user_id` LEFT JOIN `users` `authors4` ON `authors4`.`id` = `posts`.`author4_user_id` LEFT JOIN `users` `authors5` ON `authors5`.`id` = `posts`.`author5_user_id` WHERE `posts`.`lang_id` = 3 AND `posts`.`is_scheduled` = 0 AND `posts`.`visibility` = 1 AND `posts`.`status` = 1 AND `posts`.`user_id` = 7178 ORDER BY `posts`.`created_at` DESC LIMIT 16