albums_labels

10 rows where label_id = 1505

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
4541 4541 3965 3965 Pampa 1505
6142 6142 5341 5341 Pampa 1505
7629 7629 6644 6644 Pampa 1505
9154 9154 8008 8008 Pampa 1505
11213 11213 9809 9809 Pampa 1505
13427 13427 11819 11819 Pampa 1505
14501 14501 12808 12808 Pampa 1505
15684 15684 13846 13846 Pampa 1505
15800 15800 13949 13949 Pampa 1505
16367 16367 14453 14453 Pampa 1505

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