home / pf

albums_labels

11 rows where label_id = 579

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
1106 1106 950 950 IRS 579
2635 2635 2298 2298 IRS 579
4009 4009 3507 3507 IRS 579
5135 5135 4491 4491 IRS 579
15263 15263 13483 13483 IRS 579
15739 15739 13896 13896 IRS 579
17102 17102 15114 15114 IRS 579
18483 18483 16380 16380 IRS 579
19261 19261 17113 17113 IRS 579
23419 23419 20937 20937 IRS 579
24021 24021 21508 21508 IRS 579

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