albums_labels

5 rows where label_id = 1282

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
3544 3544 3092 3092 Famous Class 1282
5369 5369 4675 4675 Famous Class 1282
8723 8723 7608 7608 Famous Class 1282
11012 11012 9644 9644 Famous Class 1282
11026 11026 9656 9656 Famous Class 1282

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