This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 15284 | 15284 | ec3ac | 869 869 |
| 15285 | 15285 | 59b7b | 869 869 |
| 15286 | 15286 | aaf5a | 869 869 |
| 15287 | 15287 | 5e075 | 869 869 |
| 15288 | 15288 | 59d75 | 869 869 |
| 15289 | 15289 | e6200 | 869 869 |
| 15290 | 15290 | b1201 | 869 869 |
| 15291 | 15291 | 5ce50 | 869 869 |
| 15292 | 15292 | 3803a | 869 869 |
| 15293 | 15293 | 7a351 | 869 869 |
| 15294 | 15294 | 0593a | 869 869 |
| 15295 | 15295 | eecd9 | 869 869 |
| 15296 | 15296 | 7ce59 | 869 869 |
| 15297 | 15297 | b8d0a | 869 869 |
| 15298 | 15298 | 3896c | 869 869 |
| 15299 | 15299 | a524c | 869 869 |
| 15300 | 15300 | 41ee7 | 869 869 |
| 15301 | 15301 | ed356 | 869 869 |
| 15302 | 15302 | 94bdc | 869 869 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)