albums_labels

12 rows where label_id = 2164

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
7865 7865 6844 6844 Bad Boy 2164
7866 7866 6845 6845 Bad Boy 2164
7867 7867 6846 6846 Bad Boy 2164
7868 7868 6847 6847 Bad Boy 2164
8286 8286 7221 7221 Bad Boy 2164
9792 9792 8566 8566 Bad Boy 2164
12784 12784 11226 11226 Bad Boy 2164
13161 13161 11570 11570 Bad Boy 2164
13333 13333 11732 11732 Bad Boy 2164
17318 17318 15305 15305 Bad Boy 2164
22561 22561 20135 20135 Bad Boy 2164
23271 23271 20799 20799 Bad Boy 2164

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