This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 10089 | 10089 | d379e | 1451 1451 |
| 10517 | 10517 | d379e | 1437 1437 |
| 10549 | 10549 | d379e | 1436 1436 |
| 10601 | 10601 | d379e | 1447 1447 |
| 10614 | 10614 | d379e | 1454 1454 |
| 10658 | 10658 | d379e | 1445 1445 |
| 10687 | 10687 | d379e | 1438 1438 |
| 10715 | 10715 | d379e | 1446 1446 |
| 10728 | 10728 | d379e | 1453 1453 |
| 10877 | 10877 | d379e | 1444 1444 |
| 10896 | 10896 | d379e | 1448 1448 |
| 11157 | 11157 | d379e | 1452 1452 |
| 11176 | 11176 | d379e | 1450 1450 |
| 11240 | 11240 | d379e | 1441 1441 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)