This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 31067 | 31067 | ec3ac | 27 27 |
| 31068 | 31068 | 2951c | 27 27 |
| 31069 | 31069 | e9db4 | 27 27 |
| 31070 | 31070 | 371f0 | 27 27 |
| 31071 | 31071 | 59d75 | 27 27 |
| 31072 | 31072 | 3502d | 27 27 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)