This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 15455 | 15455 | e80cf | 1885 1885 |
| 16581 | 16581 | e80cf | 2763 2763 |
| 17097 | 17097 | e80cf | 2778 2778 |
| 17621 | 17621 | e80cf | 2765 2765 |
| 17635 | 17635 | e80cf | 2767 2767 |
| 18139 | 18139 | e80cf | 2766 2766 |
| 18253 | 18253 | e80cf | 2768 2768 |
| 27305 | 27305 | e80cf | 2770 2770 |
| 27747 | 27747 | e80cf | 2769 2769 |
| 35305 | 35305 | e80cf | 32 32 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)