This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 20132 | 20132 | cc5ed | 2167 2167 |
| 20133 | 20133 | 371f0 | 2167 2167 |
| 20134 | 20134 | e6200 | 2167 2167 |
| 20135 | 20135 | b1201 | 2167 2167 |
| 20136 | 20136 | 8a7ee | 2167 2167 |
| 20137 | 20137 | 862ed | 2167 2167 |
| 20138 | 20138 | a1307 | 2167 2167 |
| 20139 | 20139 | abb72 | 2167 2167 |
| 20140 | 20140 | 27369 | 2167 2167 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)