albums_labels

4 rows where label_id = 324

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
509 509 428 428 Portraits GRM 324
594 594 498 498 Portraits GRM 324
2184 2184 1900 1900 Portraits GRM 324
2904 2904 2533 2533 Portraits GRM 324

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