albums_labels

15 rows where label_id = 527

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
993 993 849 849 Other People 527
2998 2998 2623 2623 Other People 527
3421 3421 2992 2992 Other People 527
3628 3628 3164 3164 Other People 527
4973 4973 4343 4343 Other People 527
6418 6418 5587 5587 Other People 527
8513 8513 7422 7422 Other People 527
9212 9212 8056 8056 Other People 527
9532 9532 8335 8335 Other People 527
9667 9667 8454 8454 Other People 527
10310 10310 9021 9021 Other People 527
11345 11345 9924 9924 Other People 527
12679 12679 11131 11131 Other People 527
30152 30152 27172 27172 Other People 527
30239 30239 27249 27249 Other People 527

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