home / pf

albums_labels

8 rows where label_id = 1574

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
4851 4851 4238 4238 Top Dawg Entertainment 1574
7683 7683 6691 6691 Top Dawg Entertainment 1574
7930 7930 6900 6900 Top Dawg Entertainment 1574
8150 8150 7100 7100 Top Dawg Entertainment 1574
9394 9394 8213 8213 Top Dawg Entertainment 1574
9958 9958 8707 8707 Top Dawg Entertainment 1574
11707 11707 10249 10249 Top Dawg Entertainment 1574
12001 12001 10504 10504 Top Dawg Entertainment 1574

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