static function get_level_list($seating_chart_id) { global $wpdb; $levels = array(); $transient = seating_chart::get_level_list_transient($seating_chart_id); if (false === ($levels = get_transient($transient))) { $levels = $wpdb->get_results("select distinct level from " . EVENTS_SEATING_CHART_SEAT_TABLE . " where seating_chart_id = {$seating_chart_id} order by level "); set_transient($transient, $levels, 60 * 60 * 24 * 365); } return $levels; }