albums_labels
19 rows where label_id = 702
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 1490 | 1490 | 1290 1290 | Neurot 702 |
| 8477 | 8477 | 7388 7388 | Neurot 702 |
| 9333 | 9333 | 8159 8159 | Neurot 702 |
| 9797 | 9797 | 8571 8571 | Neurot 702 |
| 9894 | 9894 | 8654 8654 | Neurot 702 |
| 11416 | 11416 | 9987 9987 | Neurot 702 |
| 11472 | 11472 | 10035 10035 | Neurot 702 |
| 13960 | 13960 | 12305 12305 | Neurot 702 |
| 14414 | 14414 | 12731 12731 | Neurot 702 |
| 16915 | 16915 | 14939 14939 | Neurot 702 |
| 17620 | 17620 | 15568 15568 | Neurot 702 |
| 19831 | 19831 | 17672 17672 | Neurot 702 |
| 19832 | 19832 | 17673 17673 | Neurot 702 |
| 21244 | 21244 | 18934 18934 | Neurot 702 |
| 23990 | 23990 | 21477 21477 | Neurot 702 |
| 25151 | 25151 | 22579 22579 | Neurot 702 |
| 27602 | 27602 | 24899 24899 | Neurot 702 |
| 27992 | 27992 | 25261 25261 | Neurot 702 |
| 28095 | 28095 | 25354 25354 | Neurot 702 |
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) );