SELECT bp.`id`, bp.`show`, b.`show` "blog_show", p.`show` "profile_show",
				bp.`title`, bp.`text`, bp.`photo`, bp.`viewcount`, bp.`commentcount`, bp.`dateadd`,
				b.`profile`, b.`count` "blog_count", p.`sysname` "profile_sysname", p.`nickname` "profile_nickname"
				FROM `blog_post` bp
				INNER JOIN `blog` b ON (bp.`blog` = b.`id`)
				INNER JOIN `profile` p ON (b.`profile` = p.`id`)
				WHERE b.`show` = 1 AND bp.`show` = 1 AND p.`show` = 1 AND b.`profile` = 20
				ORDER BY bp.`id` DESC  limit 10 

---------------------
173.245.54.196 07.08.2020 04:47:01  http://noch.bvf.ru/profile/dj/mityapixel/