This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 29510 | 29510 | cc5ed | 2984 2984 |
| 29511 | 29511 | a2b0d | 2984 2984 |
| 29512 | 29512 | 371f0 | 2984 2984 |
| 29513 | 29513 | 59d75 | 2984 2984 |
| 29514 | 29514 | e6200 | 2984 2984 |
| 29515 | 29515 | b1201 | 2984 2984 |
| 29516 | 29516 | 902e5 | 2984 2984 |
| 29517 | 29517 | d83f4 | 2984 2984 |
| 29518 | 29518 | 5b8a4 | 2984 2984 |
| 29519 | 29519 | 6b739 | 2984 2984 |
| 29520 | 29520 | e737a | 2984 2984 |
| 29521 | 29521 | 60bee | 2984 2984 |
| 29522 | 29522 | 4856c | 2984 2984 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)