SELECT p.`id`, p.`title`, p.`text`,
				gp.`sysname` "gp_sysname", r.`sysname` "rubric_sysname"
				FROM `info_post` p
				INNER JOIN `info_rubric` r ON (p.`rubric` = r.`id`)
				INNER JOIN `global_part` gp ON (p.`global_part` = gp.`id`)
				WHERE p.`rubric` = 1
				ORDER BY p.`id`

---------------------
172.69.63.156 06.07.2020 05:14:00  http://stroim.bvf.ru/info/constructing/parcel/