This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 16827 | 16827 | cc5ed | 2947 2947 |
| 16828 | 16828 | 371f0 | 2947 2947 |
| 16829 | 16829 | bf1e7 | 2947 2947 |
| 16830 | 16830 | e6200 | 2947 2947 |
| 16831 | 16831 | b1201 | 2947 2947 |
| 16832 | 16832 | 77d7e | 2947 2947 |
| 16833 | 16833 | a5efc | 2947 2947 |
| 16834 | 16834 | e5437 | 2947 2947 |
| 16835 | 16835 | 469ba | 2947 2947 |
| 16836 | 16836 | feaa7 | 2947 2947 |
| 16837 | 16837 | 71d36 | 2947 2947 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)