albums_labels
29 rows where label_id = 1683
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 5328 | 5328 | 4641 4641 | Tri Angle 1683 |
| 5822 | 5822 | 5074 5074 | Tri Angle 1683 |
| 5945 | 5945 | 5183 5183 | Tri Angle 1683 |
| 8421 | 8421 | 7335 7335 | Tri Angle 1683 |
| 8622 | 8622 | 7519 7519 | Tri Angle 1683 |
| 9048 | 9048 | 7904 7904 | Tri Angle 1683 |
| 9470 | 9470 | 8281 8281 | Tri Angle 1683 |
| 9563 | 9563 | 8362 8362 | Tri Angle 1683 |
| 9849 | 9849 | 8616 8616 | Tri Angle 1683 |
| 10775 | 10775 | 9430 9430 | Tri Angle 1683 |
| 11431 | 11431 | 9999 9999 | Tri Angle 1683 |
| 11773 | 11773 | 10305 10305 | Tri Angle 1683 |
| 11946 | 11946 | 10453 10453 | Tri Angle 1683 |
| 12114 | 12114 | 10607 10607 | Tri Angle 1683 |
| 12518 | 12518 | 10982 10982 | Tri Angle 1683 |
| 12836 | 12836 | 11273 11273 | Tri Angle 1683 |
| 13345 | 13345 | 11743 11743 | Tri Angle 1683 |
| 13942 | 13942 | 12287 12287 | Tri Angle 1683 |
| 14133 | 14133 | 12460 12460 | Tri Angle 1683 |
| 14673 | 14673 | 12958 12958 | Tri Angle 1683 |
| 14747 | 14747 | 13026 13026 | Tri Angle 1683 |
| 15360 | 15360 | 13570 13570 | Tri Angle 1683 |
| 15410 | 15410 | 13617 13617 | Tri Angle 1683 |
| 15581 | 15581 | 13761 13761 | Tri Angle 1683 |
| 15855 | 15855 | 13998 13998 | Tri Angle 1683 |
| 16000 | 16000 | 14125 14125 | Tri Angle 1683 |
| 16812 | 16812 | 14848 14848 | Tri Angle 1683 |
| 16993 | 16993 | 15013 15013 | Tri Angle 1683 |
| 17033 | 17033 | 15051 15051 | Tri Angle 1683 |
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) );