isIN the room with two queries instead of a join
over the same table.