albums_labels
7 rows where label_id = 593
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 1139 | 1139 | 978 978 | Tapete 593 |
| 4901 | 4901 | 4284 4284 | Tapete 593 |
| 6787 | 6787 | 5915 5915 | Tapete 593 |
| 8053 | 8053 | 7011 7011 | Tapete 593 |
| 9290 | 9290 | 8124 8124 | Tapete 593 |
| 18445 | 18445 | 16346 16346 | Tapete 593 |
| 29264 | 29264 | 26392 26392 | Tapete 593 |
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) );