This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 3338 | 3338 | ec3ac | 586 586 |
| 3339 | 3339 | 7d863 | 586 586 |
| 3340 | 3340 | cda75 | 586 586 |
| 3341 | 3341 | eed19 | 586 586 |
| 3342 | 3342 | bde08 | 586 586 |
| 3343 | 3343 | 97ed8 | 586 586 |
| 3344 | 3344 | 84f2d | 586 586 |
| 3345 | 3345 | 7a280 | 586 586 |
| 3346 | 3346 | 1aff9 | 586 586 |
| 3347 | 3347 | d7924 | 586 586 |
| 3348 | 3348 | 6816d | 586 586 |
| 3349 | 3349 | f7146 | 586 586 |
| 3350 | 3350 | b23d5 | 586 586 |
| 3351 | 3351 | 0b2ab | 586 586 |
| 3352 | 3352 | 371f0 | 586 586 |
| 3353 | 3353 | 5e075 | 586 586 |
| 3354 | 3354 | 59d75 | 586 586 |
| 3355 | 3355 | e6200 | 586 586 |
| 3356 | 3356 | b1201 | 586 586 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)