albums_labels

11 rows where label_id = 1182

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
3127 3127 2733 2733 Dekmantel 1182
4508 4508 3933 3933 Dekmantel 1182
6199 6199 5396 5396 Dekmantel 1182
6898 6898 6012 6012 Dekmantel 1182
7464 7464 6494 6494 Dekmantel 1182
7941 7941 6911 6911 Dekmantel 1182
7949 7949 6918 6918 Dekmantel 1182
9743 9743 8525 8525 Dekmantel 1182
9844 9844 8611 8611 Dekmantel 1182
11083 11083 9698 9698 Dekmantel 1182
14089 14089 12417 12417 Dekmantel 1182

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