This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 3947 | 3947 | 5bb13 | 559 559 |
| 10302 | 10302 | 5bb13 | 74 74 |
| 11771 | 11771 | 5bb13 | 71 71 |
| 12346 | 12346 | 5bb13 | 73 73 |
| 12425 | 12425 | 5bb13 | 72 72 |
| 12844 | 12844 | 5bb13 | 76 76 |
| 13222 | 13222 | 5bb13 | 75 75 |
| 13763 | 13763 | 5bb13 | 97 97 |
| 13845 | 13845 | 5bb13 | 1571 1571 |
| 31686 | 31686 | 5bb13 | 51 51 |
| 32287 | 32287 | 5bb13 | 50 50 |
| 32357 | 32357 | 5bb13 | 77 77 |
| 32491 | 32491 | 5bb13 | 98 98 |
| 32552 | 32552 | 5bb13 | 78 78 |
| 32692 | 32692 | 5bb13 | 63 63 |
| 32701 | 32701 | 5bb13 | 99 99 |
| 32785 | 32785 | 5bb13 | 109 109 |
| 33113 | 33113 | 5bb13 | 1426 1426 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)