albums_labels

7 rows where label_id = 3705

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
18878 18878 16734 16734 Almost Gold 3705
19509 19509 17359 17359 Almost Gold 3705
19520 19520 17370 17370 Almost Gold 3705
19722 19722 17567 17567 Almost Gold 3705
19874 19874 17713 17713 Almost Gold 3705
20203 20203 17993 17993 Almost Gold 3705
20714 20714 18455 18455 Almost Gold 3705

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