albums_labels

7 rows where label_id = 4286

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
22428 22428 20015 20015 Self-Starter Foundation 4286
27114 27114 24443 24443 Self-Starter Foundation 4286
27319 27319 24633 24633 Self-Starter Foundation 4286
27932 27932 25205 25205 Self-Starter Foundation 4286
27972 27972 25243 25243 Self-Starter Foundation 4286
27973 27973 25244 25244 Self-Starter Foundation 4286
28515 28515 25738 25738 Self-Starter Foundation 4286

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