This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 7293 | 7293 | ec3ac | 2798 2798 |
| 7294 | 7294 | e4503 | 2798 2798 |
| 7295 | 7295 | 371f0 | 2798 2798 |
| 7296 | 7296 | 5e075 | 2798 2798 |
| 7297 | 7297 | 59d75 | 2798 2798 |
| 7298 | 7298 | e6200 | 2798 2798 |
| 7299 | 7299 | b1201 | 2798 2798 |
| 7300 | 7300 | 902e5 | 2798 2798 |
| 7301 | 7301 | f788a | 2798 2798 |
| 7302 | 7302 | e128e | 2798 2798 |
| 7303 | 7303 | 943de | 2798 2798 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)