SELECT staff.`id`, staff.`title`, staff.`shortdescr`, staff.`descr`, staff.`avdprice`,
				shop.`id` "shopid", shop.`sysname` "shopsysname", shop.`name` "shopname", shop.`address`, shop.`phone`, shop.`site`, ss.`price`,
				ph.`id` "photo"
				FROM `staff_post` staff
				LEFT JOIN `staff_shop` ss ON (ss.`staff` = staff.`id`)
				LEFT JOIN `shop` shop ON (ss.`shop` = shop.`id`)
				LEFT JOIN `photo` ph ON (ph.`board` = 2 AND ph.`owner` = staff.`id` AND ph.`n` = 1)
				WHERE staff.`staff_rubric` = 33
				ORDER BY staff.`id` DESC, shop.`top` DESC

---------------------
172.69.63.192 25.05.2020 05:06:02  http://stroim.bvf.ru/staff/workpeople/raznorabochie/