SELECT CONCAT('<a href="https://orbitalscoreboard.com/user/',sc.player_id,'">',sc.player_id,'</a>') AS player id,
        sc.`player_initials`,
        sc.`score`,
        sc.`date`,
        wp_users.id,
        wp_posts.post_name,
        wp_usermeta.meta_value
FROM scores as sc,wp_usermeta,wp_users,wp_posts
WHERE 1=1
    and wp_posts.id = %CURRENT_POST_ID%
    AND sc.`pintable` = wp_posts.post_name
    AND sc.`score` > 1
    and sc.player_id = wp_users.user_login
    and wp_users.id = wp_usermeta.user_id
    and wp_usermeta.meta_key = 'country'
GROUP BY sc.score