albums_labels

12 rows where label_id = 3004

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
13445 13445 11836 11836 Cooperative 3004
13944 13944 12289 12289 Cooperative 3004
14112 14112 12440 12440 Cooperative 3004
14879 14879 13139 13139 Cooperative 3004
15637 15637 13809 13809 Cooperative 3004
15805 15805 13952 13952 Cooperative 3004
15846 15846 13989 13989 Cooperative 3004
15878 15878 14018 14018 Cooperative 3004
16024 16024 14146 14146 Cooperative 3004
16094 16094 14210 14210 Cooperative 3004
16149 16149 14257 14257 Cooperative 3004
16398 16398 14480 14480 Cooperative 3004

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