albums_labels

4 rows where label_id = 2573

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
10386 10386 9087 9087 Lil' Chief 2573
17762 17762 15700 15700 Lil' Chief 2573
21049 21049 18757 18757 Lil' Chief 2573
21757 21757 19401 19401 Lil' Chief 2573

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