albums_labels

9 rows where label_id = 172

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
226 226 194 194 37d03d 172
678 678 570 570 37d03d 172
751 751 636 636 37d03d 172
1619 1619 1406 1406 37d03d 172
1918 1918 1675 1675 37d03d 172
2373 2373 2064 2064 37d03d 172
3131 3131 2736 2736 37d03d 172
3672 3672 3204 3204 37d03d 172
4159 4159 3641 3641 37d03d 172

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