albums_labels

4 rows where label_id = 4907

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
27174 27174 24499 24499 Some Odd Pilot 4907
27987 27987 25257 25257 Some Odd Pilot 4907
28168 28168 25418 25418 Some Odd Pilot 4907
29001 29001 26175 26175 Some Odd Pilot 4907

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