home / pf

albums_labels

7 rows where label_id = 4702

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
25798 25798 23202 23202 Instinct 4702
27119 27119 24448 24448 Instinct 4702
27241 27241 24558 24558 Instinct 4702
27480 27480 24784 24784 Instinct 4702
28617 28617 25830 25830 Instinct 4702
28792 28792 25989 25989 Instinct 4702
28863 28863 26052 26052 Instinct 4702

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