albums_labels

12 rows where label_id = 436

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
750 750 635 635 10k 436
1853 1853 1622 1622 10k 436
2598 2598 2264 2264 10k 436
3084 3084 2698 2698 10k 436
4455 4455 3888 3888 10k 436
5138 5138 4494 4494 10k 436
7382 7382 6420 6420 10k 436
29158 29158 26303 26303 10k 436
29306 29306 26431 26431 10k 436
30048 30048 27074 27074 10k 436
30417 30417 27408 27408 10k 436
30439 30439 27430 27430 10k 436

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