albums_labels

18 rows where label_id = 3671

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
18571 18571 16461 16461 Flameshovel 3671
19498 19498 17348 17348 Flameshovel 3671
20696 20696 18440 18440 Flameshovel 3671
20795 20795 18526 18526 Flameshovel 3671
21286 21286 18973 18973 Flameshovel 3671
21357 21357 19039 19039 Flameshovel 3671
22158 22158 19771 19771 Flameshovel 3671
22255 22255 19860 19860 Flameshovel 3671
22653 22653 20218 20218 Flameshovel 3671
22843 22843 20395 20395 Flameshovel 3671
23083 23083 20620 20620 Flameshovel 3671
23254 23254 20784 20784 Flameshovel 3671
23396 23396 20920 20920 Flameshovel 3671
23841 23841 21336 21336 Flameshovel 3671
23963 23963 21451 21451 Flameshovel 3671
24031 24031 21518 21518 Flameshovel 3671
24530 24530 21986 21986 Flameshovel 3671
25499 25499 22913 22913 Flameshovel 3671

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