home / pf

albums_labels

4 rows where label_id = 2463

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
9655 9655 8444 8444 Sonic Cathedral 2463
11679 11679 10224 10224 Sonic Cathedral 2463
12650 12650 11105 11105 Sonic Cathedral 2463
17401 17401 15373 15373 Sonic Cathedral 2463

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