albums_labels

7 rows where label_id = 1264

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
3464 3464 3027 3027 Apollo 1264
7325 7325 6370 6370 Apollo 1264
10514 10514 9201 9201 Apollo 1264
10568 10568 9251 9251 Apollo 1264
10790 10790 9444 9444 Apollo 1264
12242 12242 10724 10724 Apollo 1264
12966 12966 11390 11390 Apollo 1264

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