albums_labels

8 rows where label_id = 2385

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
9137 9137 7992 7992 Greensleeves 2385
17787 17787 15725 15725 Greensleeves 2385
17788 17788 15726 15726 Greensleeves 2385
20944 20944 18660 18660 Greensleeves 2385
20978 20978 18692 18692 Greensleeves 2385
21518 21518 19184 19184 Greensleeves 2385
21711 21711 19361 19361 Greensleeves 2385
24187 24187 21660 21660 Greensleeves 2385

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