albums_labels

7 rows where label_id = 2821

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
12089 12089 10583 10583 Razor & Tie 2821
19017 19017 16870 16870 Razor & Tie 2821
23493 23493 21007 21007 Razor & Tie 2821
25979 25979 23370 23370 Razor & Tie 2821
26553 26553 23921 23921 Razor & Tie 2821
28618 28618 25831 25831 Razor & Tie 2821
29189 29189 26330 26330 Razor & Tie 2821

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