对使用子查询计算的值进行过滤

This query works :

这个查询的工作原理:

select r.id, name, description, private, auth,
(select count (*) from message m where m.room = r.id) as messageCount
from room r left join room_auth a on a.room=r.id and a.player='11'
where private is false or auth is not null;
select r.id,