home / pf

albums_labels

5 rows where label_id = 3860

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
19730 19730 17575 17575 Hello Sir 3860
20558 20558 18317 18317 Hello Sir 3860
22187 22187 19798 19798 Hello Sir 3860
22861 22861 20412 20412 Hello Sir 3860
24461 24461 21922 21922 Hello Sir 3860

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