albums_labels

4 rows where label_id = 1253

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
3434 3434 3003 3003 Monkeywrench 1253
12644 12644 11100 11100 Monkeywrench 1253
15909 15909 14045 14045 Monkeywrench 1253
18204 18204 16116 16116 Monkeywrench 1253

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