albums_labels

9 rows where label_id = 4026

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
20734 20734 18473 18473 Rainbow Quartz 4026
24577 24577 22028 22028 Rainbow Quartz 4026
25139 25139 22568 22568 Rainbow Quartz 4026
25428 25428 22847 22847 Rainbow Quartz 4026
25910 25910 23307 23307 Rainbow Quartz 4026
26877 26877 24230 24230 Rainbow Quartz 4026
27071 27071 24406 24406 Rainbow Quartz 4026
27400 27400 24710 24710 Rainbow Quartz 4026
28150 28150 25402 25402 Rainbow Quartz 4026

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