This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 28465 | 28465 | cc5ed | 3116 3116 |
| 28466 | 28466 | d6ade | 3116 3116 |
| 28467 | 28467 | 8e7b3 | 3116 3116 |
| 28468 | 28468 | d4179 | 3116 3116 |
| 28469 | 28469 | 313af | 3116 3116 |
| 28470 | 28470 | ebe26 | 3116 3116 |
| 28471 | 28471 | aabe0 | 3116 3116 |
| 28472 | 28472 | a0f55 | 3116 3116 |
| 28473 | 28473 | 371f0 | 3116 3116 |
| 28474 | 28474 | e6200 | 3116 3116 |
| 28475 | 28475 | b1201 | 3116 3116 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)