Something went wrong. Try again.
This string has no description
Something went wrong. Try again.
311 B · 12 lines · Created 9mo ago
SQL
123456789101112SELECT t.xata_id, t.title, t.artist, t.album, s.timestamp FROM scrobbles s LEFT JOIN tracks t ON t.xata_id = s.track_id LEFT JOIN albums al ON s.album_id = al.xata_id LEFT JOIN artists ar ON ar.xata_id = s.artist_id WHERE ar.genres @> ARRAY['drill'] ORDER BY s.timestamp DESC LIMIT 40;