albums_labels

5 rows where label_id = 883

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
2093 2093 1821 1821 Cosmo Rhythmatic 883
2851 2851 2487 2487 Cosmo Rhythmatic 883
3532 3532 3084 3084 Cosmo Rhythmatic 883
4997 4997 4365 4365 Cosmo Rhythmatic 883
5852 5852 5100 5100 Cosmo Rhythmatic 883

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