albums_labels

9 rows where label_id = 2347

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
8891 8891 7762 7762 Manifesto 2347
9203 9203 8048 8048 Manifesto 2347
23417 23417 20937 20937 Manifesto 2347
24473 24473 21934 21934 Manifesto 2347
26509 26509 23879 23879 Manifesto 2347
27104 27104 24435 24435 Manifesto 2347
27352 27352 24664 24664 Manifesto 2347
27883 27883 25158 25158 Manifesto 2347
29128 29128 26276 26276 Manifesto 2347

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