This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 15626 | 15626 | e1dcf | 2829 2829 |
| 16129 | 16129 | e1dcf | 3329 3329 |
| 16404 | 16404 | e1dcf | 3338 3338 |
| 17776 | 17776 | e1dcf | 3340 3340 |
| 17953 | 17953 | e1dcf | 3342 3342 |
| 23246 | 23246 | e1dcf | 3351 3351 |
| 23323 | 23323 | e1dcf | 3331 3331 |
| 23455 | 23455 | e1dcf | 3325 3325 |
| 23539 | 23539 | e1dcf | 3319 3319 |
| 24520 | 24520 | e1dcf | 3318 3318 |
| 24611 | 24611 | e1dcf | 3332 3332 |
| 24730 | 24730 | e1dcf | 3352 3352 |
| 25924 | 25924 | e1dcf | 2835 2835 |
| 25965 | 25965 | e1dcf | 3362 3362 |
| 26187 | 26187 | e1dcf | 3326 3326 |
| 26984 | 26984 | e1dcf | 3327 3327 |
| 27379 | 27379 | e1dcf | 3339 3339 |
| 27508 | 27508 | e1dcf | 3341 3341 |
| 27680 | 27680 | e1dcf | 3347 3347 |
| 27815 | 27815 | e1dcf | 3322 3322 |
| 27882 | 27882 | e1dcf | 3320 3320 |
| 27955 | 27955 | e1dcf | 3361 3361 |
| 28051 | 28051 | e1dcf | 3321 3321 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)