albums_labels

12 rows where label_id = 781

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
1728 1728 1505 1505 eOne 781
2487 2487 2169 2169 eOne 781
2830 2830 2468 2468 eOne 781
2937 2937 2563 2563 eOne 781
3563 3563 3108 3108 eOne 781
4269 4269 3733 3733 eOne 781
5474 5474 4764 4764 eOne 781
6580 6580 5725 5725 eOne 781
6929 6929 6032 6032 eOne 781
12486 12486 10955 10955 eOne 781
13507 13507 11895 11895 eOne 781
16465 16465 14537 14537 eOne 781

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