albums_labels

6 rows where label_id = 1360

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
3856 3856 3370 3370 Mad Love 1360
4100 4100 3592 3592 Mad Love 1360
5358 5358 4666 4666 Mad Love 1360
6390 6390 5562 5562 Mad Love 1360
7617 7617 6632 6632 Mad Love 1360
10398 10398 9097 9097 Mad Love 1360

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