albums_labels

12 rows where label_id = 418

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
709 709 598 598 Paper Route Empire 418
1192 1192 1025 1025 Paper Route Empire 418
1378 1378 1189 1189 Paper Route Empire 418
1709 1709 1489 1489 Paper Route Empire 418
2168 2168 1886 1886 Paper Route Empire 418
3107 3107 2714 2714 Paper Route Empire 418
3629 3629 3165 3165 Paper Route Empire 418
4301 4301 3755 3755 Paper Route Empire 418
6868 6868 5985 5985 Paper Route Empire 418
19184 19184 17037 17037 Paper Route Empire 418
29164 29164 26309 26309 Paper Route Empire 418
29730 29730 26795 26795 Paper Route Empire 418

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