albums_labels

7 rows where label_id = 2808

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
12024 12024 10525 10525 Shrimper 2808
14700 14700 12983 12983 Shrimper 2808
16376 16376 14460 14460 Shrimper 2808
18753 18753 16633 16633 Shrimper 2808
25930 25930 23327 23327 Shrimper 2808
26460 26460 23830 23830 Shrimper 2808
27582 27582 24881 24881 Shrimper 2808

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