albums_labels
22 rows where label_id = 1059
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 2661 | 2661 | 2321 2321 | WEA 1059 |
| 11895 | 11895 | 10410 10410 | WEA 1059 |
| 18222 | 18222 | 16133 16133 | WEA 1059 |
| 19484 | 19484 | 17335 17335 | WEA 1059 |
| 20806 | 20806 | 18535 18535 | WEA 1059 |
| 20989 | 20989 | 18703 18703 | WEA 1059 |
| 21714 | 21714 | 19364 19364 | WEA 1059 |
| 21751 | 21751 | 19396 19396 | WEA 1059 |
| 21795 | 21795 | 19435 19435 | WEA 1059 |
| 21796 | 21796 | 19436 19436 | WEA 1059 |
| 21797 | 21797 | 19437 19437 | WEA 1059 |
| 22774 | 22774 | 20331 20331 | WEA 1059 |
| 22896 | 22896 | 20442 20442 | WEA 1059 |
| 23592 | 23592 | 21102 21102 | WEA 1059 |
| 23854 | 23854 | 21349 21349 | WEA 1059 |
| 24539 | 24539 | 21993 21993 | WEA 1059 |
| 24773 | 24773 | 22210 22210 | WEA 1059 |
| 25077 | 25077 | 22511 22511 | WEA 1059 |
| 25322 | 25322 | 22745 22745 | WEA 1059 |
| 25323 | 25323 | 22746 22746 | WEA 1059 |
| 25324 | 25324 | 22747 22747 | WEA 1059 |
| 28220 | 28220 | 25465 25465 | WEA 1059 |
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) );