home / pf

albums_labels

5 rows where label_id = 3677

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
18664 18664 16547 16547 Catsup Plate 3677
25463 25463 22880 22880 Catsup Plate 3677
26690 26690 24054 24054 Catsup Plate 3677
28325 28325 25564 25564 Catsup Plate 3677
28669 28669 25877 25877 Catsup Plate 3677

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