home / pf

albums_labels

5 rows where label_id = 2021

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
7068 7068 6155 6155 OWSLA 2021
10811 10811 9461 9461 OWSLA 2021
10894 10894 9536 9536 OWSLA 2021
11830 11830 10353 10353 OWSLA 2021
12117 12117 10608 10608 OWSLA 2021

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