albums_labels

4 rows where label_id = 355

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
584 584 490 490 Lost Kids 355
3608 3608 3147 3147 Lost Kids 355
5345 5345 4654 4654 Lost Kids 355
6867 6867 5984 5984 Lost Kids 355

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