albums_labels

7 rows where label_id = 705

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
1498 1498 1298 1298 Peak Oil 705
4107 4107 3598 3598 Peak Oil 705
4319 4319 3770 3770 Peak Oil 705
5863 5863 5111 5111 Peak Oil 705
12876 12876 11309 11309 Peak Oil 705
29992 29992 27023 27023 Peak Oil 705
30379 30379 27373 27373 Peak Oil 705

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