albums_labels
11 rows where label_id = 3456
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 16934 | 16934 | 14958 14958 | Fonal 3456 |
| 16950 | 16950 | 14973 14973 | Fonal 3456 |
| 18363 | 18363 | 16269 16269 | Fonal 3456 |
| 18380 | 18380 | 16285 16285 | Fonal 3456 |
| 19863 | 19863 | 17704 17704 | Fonal 3456 |
| 19991 | 19991 | 17817 17817 | Fonal 3456 |
| 20810 | 20810 | 18539 18539 | Fonal 3456 |
| 20896 | 20896 | 18617 18617 | Fonal 3456 |
| 22705 | 22705 | 20266 20266 | Fonal 3456 |
| 23640 | 23640 | 21147 21147 | Fonal 3456 |
| 24006 | 24006 | 21493 21493 | Fonal 3456 |
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) );