albums_labels

6 rows where label_id = 3953

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
20261 20261 18042 18042 Empyrean 3953
21312 21312 18999 18999 Empyrean 3953
22264 22264 19869 19869 Empyrean 3953
22664 22664 20229 20229 Empyrean 3953
23467 23467 20984 20984 Empyrean 3953
24275 24275 21746 21746 Empyrean 3953

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