This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 16641 | 16641 | cc5ed | 2784 2784 |
| 16642 | 16642 | 7d732 | 2784 2784 |
| 16643 | 16643 | 315e1 | 2784 2784 |
| 16644 | 16644 | 8e041 | 2784 2784 |
| 16645 | 16645 | 8b269 | 2784 2784 |
| 16646 | 16646 | 3e397 | 2784 2784 |
| 16647 | 16647 | cba3e | 2784 2784 |
| 16648 | 16648 | 7b72e | 2784 2784 |
| 16649 | 16649 | e6200 | 2784 2784 |
| 16650 | 16650 | b1201 | 2784 2784 |
| 16651 | 16651 | 902e5 | 2784 2784 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)