albums_labels

6 rows where label_id = 88

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
102 102 91 91 Closed Casket Activities 88
1037 1037 889 889 Closed Casket Activities 88
2371 2371 2062 2062 Closed Casket Activities 88
2932 2932 2560 2560 Closed Casket Activities 88
5875 5875 5120 5120 Closed Casket Activities 88
30206 30206 27219 27219 Closed Casket Activities 88

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