albums_labels

5 rows where label_id = 3261

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
15491 15491 13688 13688 Green Owl 3261
17074 17074 15090 15090 Green Owl 3261
18148 18148 16066 16066 Green Owl 3261
19230 19230 17083 17083 Green Owl 3261
19958 19958 17788 17788 Green Owl 3261

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