This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 28826 | 28826 | cc5ed | 3127 3127 |
| 28827 | 28827 | d6ade | 3127 3127 |
| 28828 | 28828 | 8e7b3 | 3127 3127 |
| 28829 | 28829 | d4179 | 3127 3127 |
| 28830 | 28830 | 313af | 3127 3127 |
| 28831 | 28831 | ebe26 | 3127 3127 |
| 28832 | 28832 | aabe0 | 3127 3127 |
| 28833 | 28833 | a0f55 | 3127 3127 |
| 28834 | 28834 | 371f0 | 3127 3127 |
| 28835 | 28835 | e6200 | 3127 3127 |
| 28836 | 28836 | b1201 | 3127 3127 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)