albums_labels

8 rows where label_id = 193

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
263 263 228 228 ESGN 193
3175 3175 2778 2778 ESGN 193
4448 4448 3882 3882 ESGN 193
5306 5306 4623 4623 ESGN 193
5878 5878 5123 5123 ESGN 193
7773 7773 6767 6767 ESGN 193
9750 9750 8532 8532 ESGN 193
13031 13031 11447 11447 ESGN 193

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