albums_labels
21 rows where label_id = 194
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 265 | 265 | 229 229 | Relapse 194 |
| 649 | 649 | 545 545 | Relapse 194 |
| 1119 | 1119 | 961 961 | Relapse 194 |
| 1160 | 1160 | 999 999 | Relapse 194 |
| 1481 | 1481 | 1283 1283 | Relapse 194 |
| 1647 | 1647 | 1432 1432 | Relapse 194 |
| 1723 | 1723 | 1501 1501 | Relapse 194 |
| 2505 | 2505 | 2184 2184 | Relapse 194 |
| 2536 | 2536 | 2208 2208 | Relapse 194 |
| 2976 | 2976 | 2602 2602 | Relapse 194 |
| 3580 | 3580 | 3122 3122 | Relapse 194 |
| 4201 | 4201 | 3675 3675 | Relapse 194 |
| 4395 | 4395 | 3836 3836 | Relapse 194 |
| 4530 | 4530 | 3954 3954 | Relapse 194 |
| 4757 | 4757 | 4152 4152 | Relapse 194 |
| 5482 | 5482 | 4771 4771 | Relapse 194 |
| 5646 | 5646 | 4913 4913 | Relapse 194 |
| 6883 | 6883 | 5998 5998 | Relapse 194 |
| 7343 | 7343 | 6385 6385 | Relapse 194 |
| 29499 | 29499 | 26595 26595 | Relapse 194 |
| 29794 | 29794 | 26850 26850 | Relapse 194 |
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) );