albums_labels
10 rows where label_id = 3300
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 15727 | 15727 | 13885 13885 | Lovepump United 3300 |
| 17180 | 17180 | 15186 15186 | Lovepump United 3300 |
| 17370 | 17370 | 15346 15346 | Lovepump United 3300 |
| 17774 | 17774 | 15712 15712 | Lovepump United 3300 |
| 18287 | 18287 | 16195 16195 | Lovepump United 3300 |
| 18345 | 18345 | 16251 16251 | Lovepump United 3300 |
| 18691 | 18691 | 16573 16573 | Lovepump United 3300 |
| 19936 | 19936 | 17767 17767 | Lovepump United 3300 |
| 20705 | 20705 | 18448 18448 | Lovepump United 3300 |
| 23086 | 23086 | 20622 20622 | Lovepump United 3300 |
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) );