albums_labels

4 rows where label_id = 2540

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
10150 10150 8880 8880 Quite Scientific 2540
12178 12178 10664 10664 Quite Scientific 2540
15940 15940 14073 14073 Quite Scientific 2540
22202 22202 19811 19811 Quite Scientific 2540

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