$query2 = $this->db->query("SELECT * FROM ha_rooms WHERE ha_rooms.deleted != 1 JOIN ha_user_room_merged WHERE ha_rooms.room_id NOT IN (SELECT ha_user_room_merged.room_id FROM ha_user_room_merged WHERE ha_user_room_merged.deleted = 0)  group by ha_rooms.room_id");