This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 26509 | 26509 | cc5ed | 2857 2857 |
| 26510 | 26510 | 3da9b | 2857 2857 |
| 26511 | 26511 | 371f0 | 2857 2857 |
| 26512 | 26512 | 5e075 | 2857 2857 |
| 26513 | 26513 | 59d75 | 2857 2857 |
| 26514 | 26514 | e6200 | 2857 2857 |
| 26515 | 26515 | b1201 | 2857 2857 |
| 26516 | 26516 | 8a7ee | 2857 2857 |
| 26517 | 26517 | 862ed | 2857 2857 |
| 26518 | 26518 | f788a | 2857 2857 |
| 26519 | 26519 | 9848a | 2857 2857 |
| 26520 | 26520 | abb72 | 2857 2857 |
| 26521 | 26521 | 27369 | 2857 2857 |
| 26522 | 26522 | e128e | 2857 2857 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)