This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 19278 | 19278 | ec3ac | 954 954 |
| 19279 | 19279 | 4801f | 954 954 |
| 19280 | 19280 | 5e075 | 954 954 |
| 19281 | 19281 | 59d75 | 954 954 |
| 19282 | 19282 | e6200 | 954 954 |
| 19283 | 19283 | b1201 | 954 954 |
| 19284 | 19284 | d6347 | 954 954 |
| 19285 | 19285 | ebf60 | 954 954 |
| 19286 | 19286 | 9a8c6 | 954 954 |
| 19287 | 19287 | 91693 | 954 954 |
| 19288 | 19288 | 1d2ab | 954 954 |
| 19289 | 19289 | abb72 | 954 954 |
| 19290 | 19290 | 41b26 | 954 954 |
| 19291 | 19291 | 2db78 | 954 954 |
| 19292 | 19292 | 6a38c | 954 954 |
| 19293 | 19293 | e128e | 954 954 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)