albums_labels

5 rows where label_id = 404

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
683 683 574 574 Skint 404
2059 2059 1793 1793 Skint 404
2708 2708 2365 2365 Skint 404
28550 28550 25769 25769 Skint 404
29576 29576 26665 26665 Skint 404

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