albums_labels
21 rows where label_id = 2497
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 9858 | 9858 | 8623 8623 | Fire 2497 |
| 10898 | 10898 | 9539 9539 | Fire 2497 |
| 10928 | 10928 | 9564 9564 | Fire 2497 |
| 10945 | 10945 | 9580 9580 | Fire 2497 |
| 10946 | 10946 | 9581 9581 | Fire 2497 |
| 10947 | 10947 | 9582 9582 | Fire 2497 |
| 11891 | 11891 | 10407 10407 | Fire 2497 |
| 11901 | 11901 | 10414 10414 | Fire 2497 |
| 11956 | 11956 | 10463 10463 | Fire 2497 |
| 12239 | 12239 | 10721 10721 | Fire 2497 |
| 12334 | 12334 | 10810 10810 | Fire 2497 |
| 12392 | 12392 | 10865 10865 | Fire 2497 |
| 12447 | 12447 | 10918 10918 | Fire 2497 |
| 12883 | 12883 | 11314 11314 | Fire 2497 |
| 12988 | 12988 | 11411 11411 | Fire 2497 |
| 13037 | 13037 | 11452 11452 | Fire 2497 |
| 13287 | 13287 | 11692 11692 | Fire 2497 |
| 13741 | 13741 | 12105 12105 | Fire 2497 |
| 13891 | 13891 | 12243 12243 | Fire 2497 |
| 14036 | 14036 | 12370 12370 | Fire 2497 |
| 15050 | 15050 | 13289 13289 | Fire 2497 |
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) );