albums_labels

14 rows where label_id = 687

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
1442 1442 1250 1250 Fire 687
1806 1806 1577 1577 Fire 687
2334 2334 2030 2030 Fire 687
2614 2614 2279 2279 Fire 687
3171 3171 2774 2774 Fire 687
3492 3492 3051 3051 Fire 687
4506 4506 3931 3931 Fire 687
5546 5546 4829 4829 Fire 687
5923 5923 5164 5164 Fire 687
6560 6560 5707 5707 Fire 687
6622 6622 5764 5764 Fire 687
29596 29596 26682 26682 Fire 687
29666 29666 26741 26741 Fire 687
30056 30056 27081 27081 Fire 687

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