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 'ORDER BY wp_club_stats.year DESC' at line 1]
SELECT wp_club_stats.*, wp_club_players.first_name, wp_club_players.last_name, wp_club_teams.name AS team_name, wp_posts.post_name AS page_slug FROM wp_club_stats JOIN wp_club_players ON (wp_club_stats.player_id = wp_club_players.id) LEFT JOIN wp_club_teams ON (wp_club_stats.team_id = wp_club_teams.id) LEFT JOIN wp_posts ON (wp_club_teams.page_id = wp_posts.ID) WHERE player_id= ORDER BY wp_club_stats.year DESC