albums_labels

6 rows where label_id = 1228

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
3328 3328 2907 2907 God? 1228
8414 8414 7328 7328 God? 1228
10879 10879 9522 9522 God? 1228
11514 11514 10073 10073 God? 1228
12352 12352 10826 10826 God? 1228
12441 12441 10912 10912 God? 1228

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