home / pf

albums_labels

11 rows where label_id = 2334

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
8847 8847 7722 7722 Fortuna Pop! 2334
9673 9673 8459 8459 Fortuna Pop! 2334
10500 10500 9188 9188 Fortuna Pop! 2334
11294 11294 9877 9877 Fortuna Pop! 2334
11670 11670 10215 10215 Fortuna Pop! 2334
14715 14715 12995 12995 Fortuna Pop! 2334
15663 15663 13827 13827 Fortuna Pop! 2334
16103 16103 14218 14218 Fortuna Pop! 2334
17150 17150 15159 15159 Fortuna Pop! 2334
17178 17178 15184 15184 Fortuna Pop! 2334
24114 24114 21592 21592 Fortuna Pop! 2334

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