albums_labels

12 rows where label_id = 834

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
1941 1941 1696 1696 Tresor 834
3110 3110 2717 2717 Tresor 834
5808 5808 5060 5060 Tresor 834
7360 7360 6399 6399 Tresor 834
8029 8029 6989 6989 Tresor 834
8253 8253 7191 7191 Tresor 834
10399 10399 9098 9098 Tresor 834
10400 10400 9099 9099 Tresor 834
10401 10401 9100 9100 Tresor 834
11285 11285 9871 9871 Tresor 834
11286 11286 9872 9872 Tresor 834
29118 29118 26267 26267 Tresor 834

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