SELECT a.id, a.name, a.genres,
COUNT(*) AS play_count,
COUNT(DISTINCT s.user_id) AS unique_listeners
FROM artists a
LEFT JOIN scrobbles s ON s.artist_id = a.id
WHERE genres IS NOT NULL AND array_length(genres, 1) > 0 GROUP BY a.id, a.name, a.genres
ORDER BY play_count DESC LIMIT 200;