home / pf

albums_labels

4 rows where label_id = 476

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
853 853 724 724 RCA Records Nashville 476
2015 2015 1756 1756 RCA Records Nashville 476
3963 3963 3463 3463 RCA Records Nashville 476
5347 5347 4656 4656 RCA Records Nashville 476

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