albums_labels

9 rows where label_id = 2858

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
12325 12325 10804 10804 Output 2858
12326 12326 10805 10805 Output 2858
12327 12327 10806 10806 Output 2858
12328 12328 10807 10807 Output 2858
23427 23427 20945 20945 Output 2858
24505 24505 21962 21962 Output 2858
24830 24830 22267 22267 Output 2858
25390 25390 22810 22810 Output 2858
25863 25863 23262 23262 Output 2858

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