albums_labels

4 rows where label_id = 3409

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
16590 16590 14652 14652 Illegal Art 3409
19800 19800 17642 17642 Illegal Art 3409
19913 19913 17747 17747 Illegal Art 3409
22493 22493 20073 20073 Illegal Art 3409

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