albums_labels

5 rows where label_id = 297

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
463 463 393 393 SRFSCHL 297
2208 2208 1922 1922 SRFSCHL 297
9392 9392 8211 8211 SRFSCHL 297
29788 29788 26845 26845 SRFSCHL 297
30062 30062 27085 27085 SRFSCHL 297

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