home / pf

albums_labels

6 rows where label_id = 4202

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
21818 21818 19455 19455 Playhouse 4202
21982 21982 19607 19607 Playhouse 4202
23078 23078 20615 20615 Playhouse 4202
23997 23997 21484 21484 Playhouse 4202
24690 24690 22134 22134 Playhouse 4202
26120 26120 23507 23507 Playhouse 4202

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