This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 18583 | 18583 | cc5ed | 3515 3515 |
| 18584 | 18584 | 371f0 | 3515 3515 |
| 18585 | 18585 | e6200 | 3515 3515 |
| 18586 | 18586 | b1201 | 3515 3515 |
| 18587 | 18587 | 8a7ee | 3515 3515 |
| 18588 | 18588 | 862ed | 3515 3515 |
| 18589 | 18589 | 91693 | 3515 3515 |
| 18590 | 18590 | a1307 | 3515 3515 |
| 18591 | 18591 | e45dc | 3515 3515 |
| 18592 | 18592 | c69e6 | 3515 3515 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)