albums_labels

10 rows where label_id = 26

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
31 31 29 29 Upset the Rhythm 26
8674 8674 7564 7564 Upset the Rhythm 26
11092 11092 9707 9707 Upset the Rhythm 26
12407 12407 10879 10879 Upset the Rhythm 26
15758 15758 13911 13911 Upset the Rhythm 26
16619 16619 14674 14674 Upset the Rhythm 26
17264 17264 15259 15259 Upset the Rhythm 26
18295 18295 16203 16203 Upset the Rhythm 26
20149 20149 17950 17950 Upset the Rhythm 26
29487 29487 26585 26585 Upset the Rhythm 26

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