albums_labels

8 rows where label_id = 748

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
1633 1633 1418 1418 Echo 748
9899 9899 8658 8658 Echo 748
21763 21763 19406 19406 Echo 748
23362 23362 20887 20887 Echo 748
23745 23745 21242 21242 Echo 748
23907 23907 21398 21398 Echo 748
23985 23985 21472 21472 Echo 748
24485 24485 21944 21944 Echo 748

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