albums_labels

6 rows where label_id = 370

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
612 612 513 513 1st and 15th 370
5515 5515 4802 4802 1st and 15th 370
7963 7963 6931 6931 1st and 15th 370
10984 10984 9618 9618 1st and 15th 370
20523 20523 18283 18283 1st and 15th 370
22252 22252 19857 19857 1st and 15th 370

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