WordPress database error: [Unknown column 'sub.entity_name' in 'SELECT']
SELECT u.ID as user_id, u.display_name, SUM(s.score) as total_score, COUNT(s.id) as games_played, COUNT(CASE WHEN s.is_correct = 1 THEN 1 END) as correct_answers, sub.entity_name as city FROM dp_docujuegos_scores s INNER JOIN hZFdZ4L_users u ON s.user_id = u.ID INNER JOIN dp_subscribers sub ON s.user_id = sub.user_id WHERE sub.state_id = '2' GROUP BY u.ID, u.display_name, sub.entity_name ORDER BY total_score DESC, games_played DESC LIMIT 3

WordPress database error: [Unknown column 'sub.entity_name' in 'SELECT']
SELECT u.ID as user_id, u.display_name, SUM(s.score) as total_score, COUNT(s.id) as games_played, COUNT(CASE WHEN s.is_correct = 1 THEN 1 END) as correct_answers, sub.entity_name as city FROM dp_docujuegos_scores s INNER JOIN hZFdZ4L_users u ON s.user_id = u.ID INNER JOIN dp_subscribers sub ON s.user_id = sub.user_id WHERE sub.state_id = '8' GROUP BY u.ID, u.display_name, sub.entity_name ORDER BY total_score DESC, games_played DESC LIMIT 3