albums_labels

12 rows where label_id = 134

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
159 159 136 136 Lame-O 134
261 261 226 226 Lame-O 134
379 379 323 323 Lame-O 134
1408 1408 1216 1216 Lame-O 134
3370 3370 2945 2945 Lame-O 134
4327 4327 3777 3777 Lame-O 134
6795 6795 5923 5923 Lame-O 134
7682 7682 6690 6690 Lame-O 134
8813 8813 7691 7691 Lame-O 134
9133 9133 7989 7989 Lame-O 134
29532 29532 26626 26626 Lame-O 134
30245 30245 27255 27255 Lame-O 134

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