albums_labels

5 rows where label_id = 1913

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
6508 6508 5662 5662 Lucky Number 1913
7170 7170 6242 6242 Lucky Number 1913
10099 10099 8837 8837 Lucky Number 1913
13580 13580 11960 11960 Lucky Number 1913
19985 19985 17811 17811 Lucky Number 1913

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