albums_labels

14 rows where label_id = 1679

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
5295 5295 4613 4613 Sublime Frequencies 1679
12311 12311 10790 10790 Sublime Frequencies 1679
15314 15314 13526 13526 Sublime Frequencies 1679
15718 15718 13876 13876 Sublime Frequencies 1679
15907 15907 14043 14043 Sublime Frequencies 1679
16227 16227 14328 14328 Sublime Frequencies 1679
17165 17165 15173 15173 Sublime Frequencies 1679
17220 17220 15217 15217 Sublime Frequencies 1679
17221 17221 15218 15218 Sublime Frequencies 1679
17425 17425 15393 15393 Sublime Frequencies 1679
18411 18411 16315 16315 Sublime Frequencies 1679
19206 19206 17059 17059 Sublime Frequencies 1679
22295 22295 19893 19893 Sublime Frequencies 1679
23443 23443 20961 20961 Sublime Frequencies 1679

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