home / pf

albums_labels

5 rows where label_id = 2408

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
9309 9309 8139 8139 RJ's Electrical Connections 2408
15382 15382 13591 13591 RJ's Electrical Connections 2408
16408 16408 14489 14489 RJ's Electrical Connections 2408
17823 17823 15758 15758 RJ's Electrical Connections 2408
17963 17963 15891 15891 RJ's Electrical Connections 2408

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