<pre>
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` = 9
				ORDER BY p.`id`

---------------------
172.69.63.218 06.07.2020 05:43:27  http://stroim.bvf.ru/info/repairs/windows/ 

</pre>