public static function get_free_room($term, $gender, $randomize = false) { $db = new PHPWS_DB('hms_room'); // Only get free rooms $db->addJoin('LEFT OUTER', 'hms_room', 'hms_bed', 'id', 'room_id'); $db->addJOIN('LEFT OUTER', 'hms_bed', 'hms_assignment', 'id', 'bed_id'); }