albums_labels

5 rows where label_id = 1099

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
2825 2825 2463 2463 False Idols 1099
7041 7041 6130 6130 False Idols 1099
11454 11454 10019 10019 False Idols 1099
29470 29470 26569 26569 False Idols 1099
30321 30321 27322 27322 False Idols 1099

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