home / pf

albums_labels

4 rows where label_id = 308

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
489 489 414 414 The Hip Hop Lab 308
29203 29203 26342 26342 The Hip Hop Lab 308
29679 29679 26752 26752 The Hip Hop Lab 308
29999 29999 27029 27029 The Hip Hop Lab 308

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