home / pf

albums_labels

19 rows where label_id = 17

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
22 22 21 21 Top Dawg Entertainment 17
34 34 32 32 Top Dawg Entertainment 17
481 481 408 408 Top Dawg Entertainment 17
796 796 672 672 Top Dawg Entertainment 17
1720 1720 1499 1499 Top Dawg Entertainment 17
4212 4212 3683 3683 Top Dawg Entertainment 17
4694 4694 4097 4097 Top Dawg Entertainment 17
6490 6490 5647 5647 Top Dawg Entertainment 17
8607 8607 7506 7506 Top Dawg Entertainment 17
8843 8843 7719 7719 Top Dawg Entertainment 17
10756 10756 9411 9411 Top Dawg Entertainment 17
12202 12202 10686 10686 Top Dawg Entertainment 17
13987 13987 12326 12326 Top Dawg Entertainment 17
14509 14509 12816 12816 Top Dawg Entertainment 17
15046 15046 13286 13286 Top Dawg Entertainment 17
15711 15711 13870 13870 Top Dawg Entertainment 17
29283 29283 26411 26411 Top Dawg Entertainment 17
29846 29846 26894 26894 Top Dawg Entertainment 17
30387 30387 27381 27381 Top Dawg Entertainment 17

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