home / pf

albums_labels

5 rows where label_id = 506

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
927 927 789 789 Feel It 506
29260 29260 26390 26390 Feel It 506
29649 29649 26726 26726 Feel It 506
29743 29743 26805 26805 Feel It 506
30241 30241 27251 27251 Feel It 506

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