home / pf

albums_labels

12 rows where label_id = 2562

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
10308 10308 9020 9020 Sincerely Yours 2562
11524 11524 10081 10081 Sincerely Yours 2562
14394 14394 12713 12713 Sincerely Yours 2562
16509 16509 14579 14579 Sincerely Yours 2562
17153 17153 15161 15161 Sincerely Yours 2562
17875 17875 15808 15808 Sincerely Yours 2562
18171 18171 16086 16086 Sincerely Yours 2562
18426 18426 16329 16329 Sincerely Yours 2562
19804 19804 17646 17646 Sincerely Yours 2562
20510 20510 18271 18271 Sincerely Yours 2562
20775 20775 18508 18508 Sincerely Yours 2562
21143 21143 18846 18846 Sincerely Yours 2562

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