albums_labels

14 rows where label_id = 2367

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
9021 9021 7880 7880 Hotflush 2367
10722 10722 9385 9385 Hotflush 2367
13377 13377 11772 11772 Hotflush 2367
13403 13403 11796 11796 Hotflush 2367
13767 13767 12129 12129 Hotflush 2367
14563 14563 12863 12863 Hotflush 2367
14900 14900 13156 13156 Hotflush 2367
15225 15225 13449 13449 Hotflush 2367
15796 15796 13945 13945 Hotflush 2367
15993 15993 14118 14118 Hotflush 2367
17068 17068 15084 15084 Hotflush 2367
17517 17517 15480 15480 Hotflush 2367
17936 17936 15866 15866 Hotflush 2367
17937 17937 15867 15867 Hotflush 2367

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