[Rootpassword]

SELECT * FROM `rooms` WHERE `rooms`.`type`="forever" OR EXISTS(SELECT * FROM `sessions` WHERE `sessions`.`room`=`rooms`.`id`)
типа того