Warning: Undefined variable $elim_week in /var/www/vhosts/usafootballpools.com/wfe1.usafootballpools.com/nfl-survivor/picks/survivor_top_picks_for_pool.php on line 59
Cannot execute SELECT query.

SELECT week_picks.23_1, t.CITY, t.TEAMNAME, COUNT(week_picks.23_1) AS COUNT FROM ((SELECT p1.PLAYER_NAME, p1.23_1 FROM survivor_standings p1 WHERE p1.PLAYER_STATUS = 'ALIVE' AND p1.SEASON = '2023' AND p1.POOL_ID = '' AND p1.DELETED = 'NO' AND p1.DEADBEAT = 'NO') UNION (SELECT p2.PLAYER_NAME, p2.23_1 FROM survivor_standings p2 WHERE p2. = '1' AND p2.SEASON = '2023' AND p2.POOL_ID = '' AND p2.DELETED = 'NO' AND p2.DEADBEAT = 'NO')) as week_picks, nfl_teams t WHERE week_picks.23_1 = t.TEAMCODE GROUP BY week_picks.23_1, t.CITY, t.TEAMNAME ORDER BY COUNT DESC