albums_labels

8 rows where label_id = 763

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
1672 1672 1455 1455 Ruination 763
2311 2311 2011 2011 Ruination 763
2451 2451 2135 2135 Ruination 763
29381 29381 26493 26493 Ruination 763
29453 29453 26553 26553 Ruination 763
30023 30023 27050 27050 Ruination 763
30397 30397 27390 27390 Ruination 763
30452 30452 27439 27439 Ruination 763

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)
);