albums_labels

6 rows where label_id = 951

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
2308 2308 2008 2008 Flemish Eye 951
2728 2728 2381 2381 Flemish Eye 951
6141 6141 5340 5340 Flemish Eye 951
10986 10986 9619 9619 Flemish Eye 951
12879 12879 11311 11311 Flemish Eye 951
18320 18320 16226 16226 Flemish Eye 951

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