This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 24647 | 24647 | cc5ed | 2929 2929 |
| 24648 | 24648 | c1190 | 2929 2929 |
| 24649 | 24649 | cb80d | 2929 2929 |
| 24650 | 24650 | 371f0 | 2929 2929 |
| 24651 | 24651 | bf1e7 | 2929 2929 |
| 24652 | 24652 | e6200 | 2929 2929 |
| 24653 | 24653 | b1201 | 2929 2929 |
| 24654 | 24654 | 902e5 | 2929 2929 |
| 24655 | 24655 | ee344 | 2929 2929 |
| 24656 | 24656 | 83826 | 2929 2929 |
| 24657 | 24657 | 927de | 2929 2929 |
| 24658 | 24658 | 25d0f | 2929 2929 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)