albums_labels
20 rows where label_id = 544
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 1025 | 1025 | 877 877 | What's Your Rupture? 544 |
| 2575 | 2575 | 2244 2244 | What's Your Rupture? 544 |
| 6801 | 6801 | 5929 5929 | What's Your Rupture? 544 |
| 8406 | 8406 | 7322 7322 | What's Your Rupture? 544 |
| 10143 | 10143 | 8875 8875 | What's Your Rupture? 544 |
| 11173 | 11173 | 9778 9778 | What's Your Rupture? 544 |
| 11804 | 11804 | 10333 10333 | What's Your Rupture? 544 |
| 12004 | 12004 | 10506 10506 | What's Your Rupture? 544 |
| 12689 | 12689 | 11140 11140 | What's Your Rupture? 544 |
| 13719 | 13719 | 12085 12085 | What's Your Rupture? 544 |
| 14599 | 14599 | 12896 12896 | What's Your Rupture? 544 |
| 15662 | 15662 | 13827 13827 | What's Your Rupture? 544 |
| 15792 | 15792 | 13941 13941 | What's Your Rupture? 544 |
| 16751 | 16751 | 14791 14791 | What's Your Rupture? 544 |
| 18494 | 18494 | 16391 16391 | What's Your Rupture? 544 |
| 18724 | 18724 | 16605 16605 | What's Your Rupture? 544 |
| 19151 | 19151 | 17004 17004 | What's Your Rupture? 544 |
| 19296 | 19296 | 17148 17148 | What's Your Rupture? 544 |
| 21745 | 21745 | 19393 19393 | What's Your Rupture? 544 |
| 23327 | 23327 | 20854 20854 | What's Your Rupture? 544 |
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) );