albums_labels

10 rows where label_id = 820

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
1896 1896 1656 1656 Ilian Tape 820
2289 2289 1992 1992 Ilian Tape 820
3067 3067 2684 2684 Ilian Tape 820
3068 3068 2685 2685 Ilian Tape 820
3371 3371 2946 2946 Ilian Tape 820
3788 3788 3307 3307 Ilian Tape 820
3960 3960 3461 3461 Ilian Tape 820
4958 4958 4332 4332 Ilian Tape 820
6079 6079 5289 5289 Ilian Tape 820
29413 29413 26517 26517 Ilian Tape 820

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