albums_labels

7 rows where label_id = 2271

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
8467 8467 7379 7379 Big Brother 2271
11374 11374 9949 9949 Big Brother 2271
11861 11861 10379 10379 Big Brother 2271
17179 17179 15185 15185 Big Brother 2271
18590 18590 16480 16480 Big Brother 2271
19415 19415 17266 17266 Big Brother 2271
30107 30107 27128 27128 Big Brother 2271

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