home / pf

albums_labels

32 rows where label_id = 120

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
138 138 119 119 Quality Control 120
204 204 177 177 Quality Control 120
208 208 180 180 Quality Control 120
1874 1874 1639 1639 Quality Control 120
1908 1908 1667 1667 Quality Control 120
2061 2061 1795 1795 Quality Control 120
2246 2246 1955 1955 Quality Control 120
3050 3050 2670 2670 Quality Control 120
3533 3533 3085 3085 Quality Control 120
4241 4241 3709 3709 Quality Control 120
4950 4950 4326 4326 Quality Control 120
5249 5249 4580 4580 Quality Control 120
5338 5338 4648 4648 Quality Control 120
5397 5397 4701 4701 Quality Control 120
5430 5430 4730 4730 Quality Control 120
5461 5461 4756 4756 Quality Control 120
6040 6040 5264 5264 Quality Control 120
6082 6082 5292 5292 Quality Control 120
6382 6382 5557 5557 Quality Control 120
6542 6542 5693 5693 Quality Control 120
6647 6647 5785 5785 Quality Control 120
6682 6682 5817 5817 Quality Control 120
6683 6683 5818 5818 Quality Control 120
7519 7519 6544 6544 Quality Control 120
8020 8020 6983 6983 Quality Control 120
8788 8788 7669 7669 Quality Control 120
9552 9552 8352 8352 Quality Control 120
10214 10214 8938 8938 Quality Control 120
29221 29221 26356 26356 Quality Control 120
29237 29237 26370 26370 Quality Control 120
29876 29876 26920 26920 Quality Control 120
30076 30076 27099 27099 Quality Control 120

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