albums_labels

7 rows where label_id = 4009

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
20612 20612 18365 18365 Red Ink 4009
21005 21005 18718 18718 Red Ink 4009
22933 22933 20477 20477 Red Ink 4009
25028 25028 22464 22464 Red Ink 4009
25033 25033 22469 22469 Red Ink 4009
25044 25044 22480 22480 Red Ink 4009
26839 26839 24194 24194 Red Ink 4009

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