This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 34271 | 34271 | ec3ac | 813 813 |
| 34272 | 34272 | b668a | 813 813 |
| 34273 | 34273 | a14cf | 813 813 |
| 34274 | 34274 | 5e075 | 813 813 |
| 34275 | 34275 | 59d75 | 813 813 |
| 34276 | 34276 | e6200 | 813 813 |
| 34277 | 34277 | b1201 | 813 813 |
| 34278 | 34278 | b42a4 | 813 813 |
| 34279 | 34279 | d679e | 813 813 |
| 34280 | 34280 | 17bc7 | 813 813 |
| 34281 | 34281 | aa04d | 813 813 |
| 34282 | 34282 | 95f91 | 813 813 |
| 34283 | 34283 | f0dcd | 813 813 |
| 34284 | 34284 | e128e | 813 813 |
| 34285 | 34285 | d75c0 | 813 813 |
| 34286 | 34286 | 16071 | 813 813 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)