albums_labels

10 rows where label_id = 2040

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
7172 7172 6243 6243 Double Six 2040
9436 9436 8252 8252 Double Six 2040
10564 10564 9247 9247 Double Six 2040
13154 13154 11564 11564 Double Six 2040
13378 13378 11773 11773 Double Six 2040
14047 14047 12380 12380 Double Six 2040
15014 15014 13258 13258 Double Six 2040
15416 15416 13622 13622 Double Six 2040
15624 15624 13799 13799 Double Six 2040
17361 17361 15338 15338 Double Six 2040

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