抱歉，您的浏览器无法访问本站

SELECT
	*, count(c.recruit_info_id) AS apply_number,
	count(
		IF (c.approval_status= 5, 1, NULL)
	) AS s_number
FROM
	`sh_further_position_posting` `a`
LEFT JOIN `sh_student_keshi` `b` ON `a`.`student_keshi_id` = `b`.`student_keshi_id`
LEFT JOIN `sh_further_recruit_info` `c` ON `c`.`post_id` = `a`.`post_id`
WHERE
	1 = 1
GROUP BY
	`a`.`post_id`
ORDER BY
	`a`.`create_time` DESC
LIMIT 10