Mestniydevil

SELECT sex, room, COUNT(*) as count
FROM `User`
WHERE `room` > 999 AND (`sex`= 1 OR `sex` = 2)
GROUP BY `sex`, `room` 
HAVING if(`sex` = $user1->sex, count < 8, count < 4)