home / pf

albums_labels

29 rows where label_id = 520

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
967 967 825 825 Last Gang 520
3665 3665 3197 3197 Last Gang 520
4601 4601 4016 4016 Last Gang 520
5526 5526 4812 4812 Last Gang 520
6928 6928 6032 6032 Last Gang 520
7082 7082 6167 6167 Last Gang 520
8821 8821 7700 7700 Last Gang 520
9141 9141 7996 7996 Last Gang 520
10170 10170 8899 8899 Last Gang 520
11203 11203 9803 9803 Last Gang 520
11447 11447 10012 10012 Last Gang 520
11518 11518 10076 10076 Last Gang 520
12490 12490 10958 10958 Last Gang 520
12610 12610 11066 11066 Last Gang 520
14035 14035 12370 12370 Last Gang 520
16951 16951 14974 14974 Last Gang 520
17410 17410 15381 15381 Last Gang 520
17442 17442 15407 15407 Last Gang 520
18560 18560 16452 16452 Last Gang 520
20242 20242 18025 18025 Last Gang 520
20923 20923 18642 18642 Last Gang 520
21113 21113 18818 18818 Last Gang 520
21193 21193 18890 18890 Last Gang 520
21600 21600 19259 19259 Last Gang 520
21927 21927 19553 19553 Last Gang 520
22261 22261 19866 19866 Last Gang 520
22447 22447 20031 20031 Last Gang 520
23495 23495 21009 21009 Last Gang 520
26105 26105 23493 23493 Last Gang 520

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE albums_labels (
	album_id integer NOT NULL,
	label_id integer NOT NULL,
	FOREIGN KEY(album_id) REFERENCES albums(id),
	FOREIGN KEY(label_id) REFERENCES labels(id),
	UNIQUE(album_id,label_id)
);
Powered by Datasette · Queries took 67.992ms