albums_labels

4 rows where label_id = 1892

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
6430 6430 5597 5597 Computer Ugly 1892
9286 9286 8120 8120 Computer Ugly 1892
11235 11235 9829 9829 Computer Ugly 1892
29779 29779 26837 26837 Computer Ugly 1892

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