albums_labels

17 rows where label_id = 4189

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
21731 21731 19379 19379 Mille Plateaux 4189
24621 24621 22069 22069 Mille Plateaux 4189
26512 26512 23882 23882 Mille Plateaux 4189
26625 26625 23992 23992 Mille Plateaux 4189
26904 26904 24255 24255 Mille Plateaux 4189
26969 26969 24314 24314 Mille Plateaux 4189
27310 27310 24624 24624 Mille Plateaux 4189
27398 27398 24708 24708 Mille Plateaux 4189
27685 27685 24976 24976 Mille Plateaux 4189
27869 27869 25145 25145 Mille Plateaux 4189
28076 28076 25337 25337 Mille Plateaux 4189
28083 28083 25344 25344 Mille Plateaux 4189
28167 28167 25417 25417 Mille Plateaux 4189
28419 28419 25652 25652 Mille Plateaux 4189
28607 28607 25821 25821 Mille Plateaux 4189
28798 28798 25994 25994 Mille Plateaux 4189
28861 28861 26051 26051 Mille Plateaux 4189

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