albums_labels
23 rows where label_id = 3362
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 16240 | 16240 | 14340 14340 | Hip-O Select 3362 |
| 17025 | 17025 | 15043 15043 | Hip-O Select 3362 |
| 17874 | 17874 | 15807 15807 | Hip-O Select 3362 |
| 18120 | 18120 | 16040 16040 | Hip-O Select 3362 |
| 18595 | 18595 | 16485 16485 | Hip-O Select 3362 |
| 18728 | 18728 | 16609 16609 | Hip-O Select 3362 |
| 18729 | 18729 | 16610 16610 | Hip-O Select 3362 |
| 19082 | 19082 | 16935 16935 | Hip-O Select 3362 |
| 19998 | 19998 | 17822 17822 | Hip-O Select 3362 |
| 20139 | 20139 | 17942 17942 | Hip-O Select 3362 |
| 20308 | 20308 | 18086 18086 | Hip-O Select 3362 |
| 20543 | 20543 | 18302 18302 | Hip-O Select 3362 |
| 20548 | 20548 | 18307 18307 | Hip-O Select 3362 |
| 21026 | 21026 | 18737 18737 | Hip-O Select 3362 |
| 21144 | 21144 | 18847 18847 | Hip-O Select 3362 |
| 21185 | 21185 | 18884 18884 | Hip-O Select 3362 |
| 21432 | 21432 | 19110 19110 | Hip-O Select 3362 |
| 22055 | 22055 | 19675 19675 | Hip-O Select 3362 |
| 22666 | 22666 | 20231 20231 | Hip-O Select 3362 |
| 23308 | 23308 | 20835 20835 | Hip-O Select 3362 |
| 23931 | 23931 | 21421 21421 | Hip-O Select 3362 |
| 23932 | 23932 | 21422 21422 | Hip-O Select 3362 |
| 24372 | 24372 | 21835 21835 | Hip-O Select 3362 |
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) );