albums_labels

15 rows where label_id = 105

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
120 120 104 104 Hollywood 105
6982 6982 6077 6077 Hollywood 105
7237 7237 6298 6298 Hollywood 105
9457 9457 8269 8269 Hollywood 105
22052 22052 19672 19672 Hollywood 105
23104 23104 20638 20638 Hollywood 105
23230 23230 20760 20760 Hollywood 105
23503 23503 21016 21016 Hollywood 105
24613 24613 22061 22061 Hollywood 105
25213 25213 22639 22639 Hollywood 105
25514 25514 22927 22927 Hollywood 105
27909 27909 25183 25183 Hollywood 105
28294 28294 25534 25534 Hollywood 105
28324 28324 25563 25563 Hollywood 105
28817 28817 26013 26013 Hollywood 105

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