WordPress database error: [Unknown column 'p.Seasons' in 'order clause']
SELECT p.*, s.seasons_concat FROM otg_players p LEFT JOIN ( SELECT nhl_id, GROUP_CONCAT(DISTINCT season ORDER BY season ASC) as seasons_concat FROM ( SELECT nhl_id, season FROM otg_player_seasonal_stats WHERE team_name = 'New York Rangers' UNION SELECT nhl_id, season FROM otg_goalie_seasonal_stats WHERE team_name = 'New York Rangers' ) combined_stats GROUP BY nhl_id ) s ON p.nhl_id = s.nhl_id WHERE 1=1 AND p.Played = 'y' ORDER BY p.Seasons ASC LIMIT 25 OFFSET 0