home / pf

albums_labels

4 rows where label_id = 1213

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
3280 3280 2869 2869 Upset the Rhythm  1213
4056 4056 3553 3553 Upset the Rhythm  1213
5640 5640 4907 4907 Upset the Rhythm  1213
5747 5747 5002 5002 Upset the Rhythm  1213

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.044ms