home / pf

albums_labels

11 rows where label_id = 391

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
646 646 542 542 Megaforce 391
4897 4897 4280 4280 Megaforce 391
10787 10787 9441 9441 Megaforce 391
13331 13331 11731 11731 Megaforce 391
13836 13836 12192 12192 Megaforce 391
16096 16096 14212 14212 Megaforce 391
18661 18661 16544 16544 Megaforce 391
20239 20239 18023 18023 Megaforce 391
21210 21210 18905 18905 Megaforce 391
22787 22787 20343 20343 Megaforce 391
30433 30433 27424 27424 Megaforce 391

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