albums_labels

7 rows where label_id = 769

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
1689 1689 1470 1470 Big Scary Monsters 769
4260 4260 3725 3725 Big Scary Monsters 769
6332 6332 5515 5515 Big Scary Monsters 769
9402 9402 8219 8219 Big Scary Monsters 769
12944 12944 11371 11371 Big Scary Monsters 769
13738 13738 12102 12102 Big Scary Monsters 769
21453 21453 19126 19126 Big Scary Monsters 769

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