home / pf

albums_labels

28 rows where label_id = 3361

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
16228 16228 14329 14329 Lost Highway 3361
17242 17242 15239 15239 Lost Highway 3361
19025 19025 16878 16878 Lost Highway 3361
19084 19084 16937 16937 Lost Highway 3361
19345 19345 17197 17197 Lost Highway 3361
19394 19394 17245 17245 Lost Highway 3361
19987 19987 17813 17813 Lost Highway 3361
20225 20225 18012 18012 Lost Highway 3361
20761 20761 18496 18496 Lost Highway 3361
21229 21229 18921 18921 Lost Highway 3361
21564 21564 19227 19227 Lost Highway 3361
21724 21724 19374 19374 Lost Highway 3361
22070 22070 19689 19689 Lost Highway 3361
22446 22446 20030 20030 Lost Highway 3361
22533 22533 20109 20109 Lost Highway 3361
23281 23281 20809 20809 Lost Highway 3361
23587 23587 21098 21098 Lost Highway 3361
23850 23850 21345 21345 Lost Highway 3361
24125 24125 21603 21603 Lost Highway 3361
24157 24157 21633 21633 Lost Highway 3361
24653 24653 22099 22099 Lost Highway 3361
24775 24775 22212 22212 Lost Highway 3361
24929 24929 22365 22365 Lost Highway 3361
24930 24930 22366 22366 Lost Highway 3361
25828 25828 23231 23231 Lost Highway 3361
25934 25934 23331 23331 Lost Highway 3361
27182 27182 24506 24506 Lost Highway 3361
28377 28377 25612 25612 Lost Highway 3361

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)
);
Powered by Datasette · Queries took 69.041ms