home / pf

albums_labels

4 rows where label_id = 3544

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
17556 17556 15513 15513 Traffic Entertainment 3544
17931 17931 15862 15862 Traffic Entertainment 3544
18730 18730 16611 16611 Traffic Entertainment 3544
20651 20651 18399 18399 Traffic Entertainment 3544

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