albums_labels

8 rows where label_id = 468

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
825 825 698 698 Peacefrog 468
15700 15700 13859 13859 Peacefrog 468
17980 17980 15908 15908 Peacefrog 468
20861 20861 18585 18585 Peacefrog 468
21658 21658 19311 19311 Peacefrog 468
22383 22383 19973 19973 Peacefrog 468
24458 24458 21919 21919 Peacefrog 468
27551 27551 24852 24852 Peacefrog 468

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