albums_labels

4 rows where label_id = 4424

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
23659 23659 21163 21163 Coup D'etat 4424
26539 26539 23908 23908 Coup D'etat 4424
27062 27062 24399 24399 Coup D'etat 4424
27672 27672 24965 24965 Coup D'etat 4424

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