albums_labels
26 rows where label_id = 3565
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 17747 | 17747 | 15688 15688 | Locust 3565 |
| 18205 | 18205 | 16117 16117 | Locust 3565 |
| 19080 | 19080 | 16933 16933 | Locust 3565 |
| 19669 | 19669 | 17514 17514 | Locust 3565 |
| 19839 | 19839 | 17680 17680 | Locust 3565 |
| 20456 | 20456 | 18220 18220 | Locust 3565 |
| 20562 | 20562 | 18321 18321 | Locust 3565 |
| 20582 | 20582 | 18337 18337 | Locust 3565 |
| 21079 | 21079 | 18786 18786 | Locust 3565 |
| 21458 | 21458 | 19131 19131 | Locust 3565 |
| 21881 | 21881 | 19511 19511 | Locust 3565 |
| 22775 | 22775 | 20332 20332 | Locust 3565 |
| 22855 | 22855 | 20407 20407 | Locust 3565 |
| 23265 | 23265 | 20794 20794 | Locust 3565 |
| 24076 | 24076 | 21559 21559 | Locust 3565 |
| 24168 | 24168 | 21641 21641 | Locust 3565 |
| 24812 | 24812 | 22249 22249 | Locust 3565 |
| 24828 | 24828 | 22265 22265 | Locust 3565 |
| 24867 | 24867 | 22303 22303 | Locust 3565 |
| 25321 | 25321 | 22744 22744 | Locust 3565 |
| 25433 | 25433 | 22851 22851 | Locust 3565 |
| 25569 | 25569 | 22976 22976 | Locust 3565 |
| 25667 | 25667 | 23073 23073 | Locust 3565 |
| 25691 | 25691 | 23096 23096 | Locust 3565 |
| 26740 | 26740 | 24103 24103 | Locust 3565 |
| 26743 | 26743 | 24105 24105 | Locust 3565 |
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) );