CREATE TABLE tags (index DECIMAL, id DECIMAL, tag TEXT)
CREATE TABLE torrents (groupname TEXT, totalsnatched DECIMAL, artist TEXT, groupyear DECIMAL, releasetype TEXT, groupid DECIMAL, id DECIMAL)

Which tag is used for which release title?
SELECT T1.tag, T2.groupname FROM torrents AS T2 JOIN tags AS T1 ON T1.id = T2.id
SELECT "T1"."tag", "T2"."groupname" FROM "torrents" AS "T2" JOIN "tags" AS "T1" ON "T1"."id" = "T2"."id"