albums_labels

10 rows where label_id = 267

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
405 405 345 345 ALC 267
1071 1071 917 917 ALC 267
1669 1669 1452 1452 ALC 267
3176 3176 2778 2778 ALC 267
3581 3581 3123 3123 ALC 267
5308 5308 4623 4623 ALC 267
10287 10287 9000 9000 ALC 267
29736 29736 26800 26800 ALC 267
29894 29894 26935 26935 ALC 267
29986 29986 27017 27017 ALC 267

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