select count(s.id),
("select true where s.id in
("select
n.s_id as id"
from news as n inner join staff as s on n.s_id = s.id"
where n.approved = 't'
group by n.s_id, s.pic1, s.name
order by count(n.id) desc, s.name asc offset 0 limit 5)
) as news
from staff as s
left join rank as r on s.id = r.s_id


PHP Fatal error: Uncaught exception 'PDOException' with message '
SQLSTATE[42803]: Grouping error: 7
ERROR: subquery uses ungrouped column "s.id" from outer query'

これの原因だれかわかりませんか？