albums_labels

8 rows where label_id = 1885

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
6374 6374 5552 5552 Rush Hour 1885
7824 7824 6808 6808 Rush Hour 1885
10364 10364 9069 9069 Rush Hour 1885
13654 13654 12026 12026 Rush Hour 1885
15103 15103 13338 13338 Rush Hour 1885
15259 15259 13480 13480 Rush Hour 1885
15875 15875 14017 14017 Rush Hour 1885
17721 17721 15664 15664 Rush Hour 1885

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