albums_labels

10 rows where label_id = 4427

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
23681 23681 21184 21184 Gooom 4427
24549 24549 22002 22002 Gooom 4427
25474 25474 22889 22889 Gooom 4427
25488 25488 22903 22903 Gooom 4427
25581 25581 22988 22988 Gooom 4427
25618 25618 23025 23025 Gooom 4427
25807 25807 23211 23211 Gooom 4427
25808 25808 23212 23212 Gooom 4427
26076 26076 23464 23464 Gooom 4427
26549 26549 23918 23918 Gooom 4427

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