home / pf

albums_labels

10 rows where label_id = 3300

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
15727 15727 13885 13885 Lovepump United 3300
17180 17180 15186 15186 Lovepump United 3300
17370 17370 15346 15346 Lovepump United 3300
17774 17774 15712 15712 Lovepump United 3300
18287 18287 16195 16195 Lovepump United 3300
18345 18345 16251 16251 Lovepump United 3300
18691 18691 16573 16573 Lovepump United 3300
19936 19936 17767 17767 Lovepump United 3300
20705 20705 18448 18448 Lovepump United 3300
23086 23086 20622 20622 Lovepump United 3300

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