albums_labels

14 rows where label_id = 653

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
1336 1336 1150 1150 Lakeshore 653
4168 4168 3648 3648 Lakeshore 653
5564 5564 4843 4843 Lakeshore 653
6354 6354 5536 5536 Lakeshore 653
6641 6641 5780 5780 Lakeshore 653
6846 6846 5968 5968 Lakeshore 653
7199 7199 6266 6266 Lakeshore 653
7384 7384 6422 6422 Lakeshore 653
7641 7641 6653 6653 Lakeshore 653
8688 8688 7577 7577 Lakeshore 653
15400 15400 13608 13608 Lakeshore 653
19115 19115 16968 16968 Lakeshore 653
24955 24955 22391 22391 Lakeshore 653
29199 29199 26339 26339 Lakeshore 653

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