albums_labels

6 rows where label_id = 964

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
2353 2353 2047 2047 Roswell 964
7050 7050 6138 6138 Roswell 964
13481 13481 11870 11870 Roswell 964
16098 16098 14214 14214 Roswell 964
27020 27020 24360 24360 Roswell 964
29642 29642 26720 26720 Roswell 964

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