home / pf

albums_labels

18 rows where label_id = 659

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
1351 1351 1165 1165 Deathwish 659
3902 3902 3410 3410 Deathwish 659
8489 8489 7399 7399 Deathwish 659
9453 9453 8266 8266 Deathwish 659
9883 9883 8644 8644 Deathwish 659
10277 10277 8992 8992 Deathwish 659
10383 10383 9085 9085 Deathwish 659
10524 10524 9211 9211 Deathwish 659
11547 11547 10102 10102 Deathwish 659
11752 11752 10287 10287 Deathwish 659
11944 11944 10451 10451 Deathwish 659
12398 12398 10871 10871 Deathwish 659
12606 12606 11062 11062 Deathwish 659
12683 12683 11135 11135 Deathwish 659
12755 12755 11200 11200 Deathwish 659
13136 13136 11548 11548 Deathwish 659
17889 17889 15822 15822 Deathwish 659
30423 30423 27414 27414 Deathwish 659

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 69.994ms