albums_labels

15 rows where label_id = 3221

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
15086 15086 13322 13322 Zoe 3221
19681 19681 17526 17526 Zoe 3221
20129 20129 17934 17934 Zoe 3221
20326 20326 18102 18102 Zoe 3221
21044 21044 18754 18754 Zoe 3221
21463 21463 19136 19136 Zoe 3221
21656 21656 19310 19310 Zoe 3221
22894 22894 20441 20441 Zoe 3221
24058 24058 21544 21544 Zoe 3221
24369 24369 21834 21834 Zoe 3221
24795 24795 22232 22232 Zoe 3221
25181 25181 22608 22608 Zoe 3221
26496 26496 23866 23866 Zoe 3221
28385 28385 25620 25620 Zoe 3221
28453 28453 25685 25685 Zoe 3221

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