home / pf

albums_labels

29 rows where label_id = 1967

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
6756 6756 5885 5885 One Little Indian 1967
8034 8034 6994 6994 One Little Indian 1967
9032 9032 7890 7890 One Little Indian 1967
9885 9885 8646 8646 One Little Indian 1967
10719 10719 9383 9383 One Little Indian 1967
10979 10979 9614 9614 One Little Indian 1967
13787 13787 12147 12147 One Little Indian 1967
13801 13801 12159 12159 One Little Indian 1967
14913 14913 13167 13167 One Little Indian 1967
15489 15489 13686 13686 One Little Indian 1967
16729 16729 14769 14769 One Little Indian 1967
18438 18438 16339 16339 One Little Indian 1967
19260 19260 17112 17112 One Little Indian 1967
20476 20476 18240 18240 One Little Indian 1967
21409 21409 19088 19088 One Little Indian 1967
22720 22720 20280 20280 One Little Indian 1967
23358 23358 20883 20883 One Little Indian 1967
23733 23733 21231 21231 One Little Indian 1967
23777 23777 21273 21273 One Little Indian 1967
23956 23956 21444 21444 One Little Indian 1967
25005 25005 22441 22441 One Little Indian 1967
25303 25303 22726 22726 One Little Indian 1967
25304 25304 22727 22727 One Little Indian 1967
25305 25305 22728 22728 One Little Indian 1967
25306 25306 22729 22729 One Little Indian 1967
25330 25330 22753 22753 One Little Indian 1967
25331 25331 22754 22754 One Little Indian 1967
25799 25799 23203 23203 One Little Indian 1967
26737 26737 24100 24100 One Little Indian 1967

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