albums_labels

11 rows where label_id = 609

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
1184 1184 1019 1019 PMR 609
2314 2314 2014 2014 PMR 609
3075 3075 2692 2692 PMR 609
6112 6112 5319 5319 PMR 609
9767 9767 8547 8547 PMR 609
10119 10119 8854 8854 PMR 609
11276 11276 9864 9864 PMR 609
13168 13168 11576 11576 PMR 609
14218 14218 12542 12542 PMR 609
15323 15323 13534 13534 PMR 609
29521 29521 26618 26618 PMR 609

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