home / pf

albums_labels

6 rows where label_id = 4508

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
24390 24390 21852 21852 Konkurrent 4508
25568 25568 22975 22975 Konkurrent 4508
25916 25916 23313 23313 Konkurrent 4508
27368 27368 24680 24680 Konkurrent 4508
28328 28328 25567 25567 Konkurrent 4508
29066 29066 26226 26226 Konkurrent 4508

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