albums_labels
6 rows where label_id = 3649
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 18402 | 18402 | 16306 16306 | Independiente 3649 |
| 22778 | 22778 | 20335 20335 | Independiente 3649 |
| 23980 | 23980 | 21467 21467 | Independiente 3649 |
| 24587 | 24587 | 22036 22036 | Independiente 3649 |
| 25637 | 25637 | 23044 23044 | Independiente 3649 |
| 28800 | 28800 | 25996 25996 | Independiente 3649 |
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) );