albums_labels

9 rows where label_id = 4901

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
27128 27128 24456 24456 Mr. Lady 4901
27508 27508 24812 24812 Mr. Lady 4901
27526 27526 24829 24829 Mr. Lady 4901
27608 27608 24904 24904 Mr. Lady 4901
27898 27898 25173 25173 Mr. Lady 4901
27936 27936 25209 25209 Mr. Lady 4901
28123 28123 25379 25379 Mr. Lady 4901
28493 28493 25720 25720 Mr. Lady 4901
28922 28922 26105 26105 Mr. Lady 4901

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