albums_labels

7 rows where label_id = 334

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
532 532 447 447 Mozzy 334
1960 1960 1712 1712 Mozzy 334
3264 3264 2856 2856 Mozzy 334
6368 6368 5548 5548 Mozzy 334
7162 7162 6237 6237 Mozzy 334
8002 8002 6966 6966 Mozzy 334
8959 8959 7821 7821 Mozzy 334

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