albums_labels

5 rows where label_id = 1548

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
4762 4762 4157 4157 Faitiche 1548
4772 4772 4167 4167 Faitiche 1548
8496 8496 7406 7406 Faitiche 1548
15251 15251 13474 13474 Faitiche 1548
19008 19008 16861 16861 Faitiche 1548

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