Notice: Undefined index: id in /var/www/html/sevenlakestennis/wp-content/themes/sevenlakes/page_session_roster.php on line 15

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 2]
SELECT s.id,t.name,s.cost,s.start_date,'' AS start_date_nice, s.start_time,'' AS start_time_nice,s.regis_closed_date,'' AS regis_closed_date_nice,0 as registered,0 as subs, t.max_players FROM wp_7lt_im_session AS s INNER JOIN wp_7lt_im_type AS t ON s.type_id=t.id WHERE s.id =


Notice: Trying to get property 'id' of non-object in /var/www/html/sevenlakestennis/wp-content/themes/sevenlakes/functions.php on line 263

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND registration_type='Competitor'' at line 4]
SELECT COUNT(DISTINCT player_id) FROM wp_7lt_im_registrations WHERE session_id = AND registration_type='Competitor'


Warning: Creating default object from empty value in /var/www/html/sevenlakestennis/wp-content/themes/sevenlakes/functions.php on line 266

Notice: Undefined property: stdClass::$id in /var/www/html/sevenlakestennis/wp-content/themes/sevenlakes/functions.php on line 271

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND registration_type='Sub'' at line 4]
SELECT COUNT(DISTINCT player_id) FROM wp_7lt_im_registrations WHERE session_id = AND registration_type='Sub'


Notice: Undefined property: stdClass::$start_date in /var/www/html/sevenlakestennis/wp-content/themes/sevenlakes/functions.php on line 276

Notice: Undefined property: stdClass::$start_date in /var/www/html/sevenlakestennis/wp-content/themes/sevenlakes/functions.php on line 278

Notice: Undefined property: stdClass::$start_time in /var/www/html/sevenlakestennis/wp-content/themes/sevenlakes/functions.php on line 278

Notice: Undefined property: stdClass::$regis_closed_date in /var/www/html/sevenlakestennis/wp-content/themes/sevenlakes/functions.php on line 279

Notice: Undefined property: stdClass::$cost in /var/www/html/sevenlakestennis/wp-content/themes/sevenlakes/functions.php on line 281

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND r.registration_type='Competitor' AND r.status = 'Active' ORDER BY last' at line 3]
SELECT DISTINCT p.id,p.first_name,p.last_name, p.email,p.phone,r.status,p.note,r.registration_type,0 as games_won,0 as last_court,'' AS last_match_status,0 as last_games_won,r.unavail_start,'' AS unavail_start_nice,r.unavail_end,'' AS unavail_end_nice,r.note,'' AS notes FROM wp_7lt_im_players AS p INNER JOIN wp_7lt_im_registrations AS r ON r.player_id=p.id INNER JOIN wp_7lt_im_session AS s ON r.session_id=s.id WHERE s.id = AND r.registration_type='Competitor' AND r.status = 'Active' ORDER BY last_name,first_name

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND r.registration_type='Sub' AND r.status = 'Active' ORDER BY last_name,f' at line 3]
SELECT DISTINCT p.id,p.first_name,p.last_name, p.email,p.phone,r.status,p.note,r.registration_type,0 as games_won,r.unavail_start,'' AS unavail_start_nice,r.unavail_end,'' AS unavail_end_nice,r.note,'' AS notes FROM wp_7lt_im_players AS p INNER JOIN wp_7lt_im_registrations AS r ON r.player_id=p.id INNER JOIN wp_7lt_im_session AS s ON r.session_id=s.id WHERE s.id = AND r.registration_type='Sub' AND r.status = 'Active' ORDER BY last_name,first_name

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND r.registration_type='Competitor' AND r.status != 'Active' ORDER BY las' at line 3]
SELECT DISTINCT p.id,p.first_name,p.last_name, p.email,p.phone,r.status,p.note,r.registration_type,0 as games_won,0 as last_court,'' AS last_match_status,0 as last_games_won,r.unavail_start,'' AS unavail_start_nice,r.unavail_end,'' AS unavail_end_nice,r.note,'' AS notes FROM wp_7lt_im_players AS p INNER JOIN wp_7lt_im_registrations AS r ON r.player_id=p.id INNER JOIN wp_7lt_im_session AS s ON r.session_id=s.id WHERE s.id = AND r.registration_type='Competitor' AND r.status != 'Active' ORDER BY last_name,first_name

Session Roster:
Notice: Undefined property: stdClass::$name in /var/www/html/sevenlakestennis/wp-content/themes/sevenlakes/page_session_roster.php on line 26

Start Date: Jan 1
Time: 10:58 am

Active Competitors

NamePhoneEmailNotesGames Won

Subs

NamePhoneEmailNotesGames Won

Inactive Competitors

NamePhoneEmailNotesGames Won