albums_labels

13 rows where label_id = 431

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
738 738 625 625 Grand Jury 431
759 759 643 643 Grand Jury 431
1494 1494 1294 1294 Grand Jury 431
1744 1744 1520 1520 Grand Jury 431
2832 2832 2469 2469 Grand Jury 431
3691 3691 3218 3218 Grand Jury 431
4153 4153 3636 3636 Grand Jury 431
7658 7658 6668 6668 Grand Jury 431
7831 7831 6814 6814 Grand Jury 431
9095 9095 7952 7952 Grand Jury 431
9391 9391 8210 8210 Grand Jury 431
11561 11561 10114 10114 Grand Jury 431
29230 29230 26363 26363 Grand Jury 431

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