This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 20123 | 20123 | cc5ed | 2130 2130 |
| 20124 | 20124 | 371f0 | 2130 2130 |
| 20125 | 20125 | e6200 | 2130 2130 |
| 20126 | 20126 | b1201 | 2130 2130 |
| 20127 | 20127 | 8a7ee | 2130 2130 |
| 20128 | 20128 | 862ed | 2130 2130 |
| 20129 | 20129 | a1307 | 2130 2130 |
| 20130 | 20130 | abb72 | 2130 2130 |
| 20131 | 20131 | 27369 | 2130 2130 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)