albums_labels

7 rows where label_id = 1592

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
4938 4938 4316 4316 All City 1592
7540 7540 6564 6564 All City 1592
9494 9494 8302 8302 All City 1592
10479 10479 9170 9170 All City 1592
15245 15245 13468 13468 All City 1592
17267 17267 15262 15262 All City 1592
22544 22544 20118 20118 All City 1592

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