albums_labels
23 rows where label_id = 2113
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 7577 | 7577 | 6594 6594 | R&S 2113 |
| 7807 | 7807 | 6796 6796 | R&S 2113 |
| 7953 | 7953 | 6922 6922 | R&S 2113 |
| 8998 | 8998 | 7859 7859 | R&S 2113 |
| 9506 | 9506 | 8312 8312 | R&S 2113 |
| 9515 | 9515 | 8320 8320 | R&S 2113 |
| 10326 | 10326 | 9035 9035 | R&S 2113 |
| 10493 | 10493 | 9183 9183 | R&S 2113 |
| 11611 | 11611 | 10160 10160 | R&S 2113 |
| 11739 | 11739 | 10274 10274 | R&S 2113 |
| 12899 | 12899 | 11329 11329 | R&S 2113 |
| 13053 | 13053 | 11469 11469 | R&S 2113 |
| 13414 | 13414 | 11807 11807 | R&S 2113 |
| 13948 | 13948 | 12293 12293 | R&S 2113 |
| 14613 | 14613 | 12910 12910 | R&S 2113 |
| 15133 | 15133 | 13367 13367 | R&S 2113 |
| 15297 | 15297 | 13510 13510 | R&S 2113 |
| 15719 | 15719 | 13877 13877 | R&S 2113 |
| 15908 | 15908 | 14044 14044 | R&S 2113 |
| 16232 | 16232 | 14333 14333 | R&S 2113 |
| 16835 | 16835 | 14867 14867 | R&S 2113 |
| 16839 | 16839 | 14871 14871 | R&S 2113 |
| 17304 | 17304 | 15294 15294 | R&S 2113 |
Advanced export
JSON shape: default, array, newline-delimited
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) );