albums_labels

6 rows where label_id = 3088

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
14102 14102 12430 12430 Perlon 3088
16401 16401 14483 14483 Perlon 3088
19820 19820 17661 17661 Perlon 3088
20175 20175 17972 17972 Perlon 3088
24612 24612 22060 22060 Perlon 3088
30217 30217 27229 27229 Perlon 3088

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