albums_labels

8 rows where label_id = 1573

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
4849 4849 4236 4236 12XU 1573
7509 7509 6535 6535 12XU 1573
10261 10261 8977 8977 12XU 1573
10419 10419 9115 9115 12XU 1573
10937 10937 9573 9573 12XU 1573
12106 12106 10599 10599 12XU 1573
21883 21883 19513 19513 12XU 1573
30016 30016 27044 27044 12XU 1573

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