albums_labels

6 rows where label_id = 690

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
1456 1456 1263 1263 Platoon 690
2169 2169 1887 1887 Platoon 690
2565 2565 2234 2234 Platoon 690
3550 3550 3097 3097 Platoon 690
3551 3551 3098 3098 Platoon 690
29538 29538 26630 26630 Platoon 690

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