home / pf

albums_labels

25 rows where label_id = 3916

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
20032 20032 17853 17853 Lookout! 3916
22849 22849 20401 20401 Lookout! 3916
22850 22850 20402 20402 Lookout! 3916
22851 22851 20403 20403 Lookout! 3916
24001 24001 21488 21488 Lookout! 3916
24056 24056 21542 21542 Lookout! 3916
24269 24269 21740 21740 Lookout! 3916
24829 24829 22266 22266 Lookout! 3916
24997 24997 22433 22433 Lookout! 3916
25040 25040 22476 22476 Lookout! 3916
26050 26050 23440 23440 Lookout! 3916
26244 26244 23624 23624 Lookout! 3916
26875 26875 24228 24228 Lookout! 3916
27044 27044 24382 24382 Lookout! 3916
27053 27053 24390 24390 Lookout! 3916
27065 27065 24402 24402 Lookout! 3916
27200 27200 24522 24522 Lookout! 3916
27345 27345 24657 24657 Lookout! 3916
27447 27447 24753 24753 Lookout! 3916
27638 27638 24934 24934 Lookout! 3916
27926 27926 25199 25199 Lookout! 3916
28317 28317 25557 25557 Lookout! 3916
28364 28364 25602 25602 Lookout! 3916
28468 28468 25696 25696 Lookout! 3916
28708 28708 25913 25913 Lookout! 3916

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 68.898ms