albums_labels

4 rows where label_id = 136

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
162 162 139 139 AD 93 136
799 799 673 673 AD 93 136
1388 1388 1198 1198 AD 93 136
1790 1790 1563 1563 AD 93 136

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