This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 16393 | 16393 | 8a7eb | 3338 3338 |
| 17765 | 17765 | 8a7eb | 3340 3340 |
| 17942 | 17942 | 8a7eb | 3342 3342 |
| 23235 | 23235 | 8a7eb | 3351 3351 |
| 23311 | 23311 | 8a7eb | 3331 3331 |
| 23444 | 23444 | 8a7eb | 3325 3325 |
| 23528 | 23528 | 8a7eb | 3319 3319 |
| 24509 | 24509 | 8a7eb | 3318 3318 |
| 24600 | 24600 | 8a7eb | 3332 3332 |
| 24718 | 24718 | 8a7eb | 3352 3352 |
| 25954 | 25954 | 8a7eb | 3362 3362 |
| 26176 | 26176 | 8a7eb | 3326 3326 |
| 27368 | 27368 | 8a7eb | 3339 3339 |
| 27497 | 27497 | 8a7eb | 3341 3341 |
| 27804 | 27804 | 8a7eb | 3322 3322 |
| 27944 | 27944 | 8a7eb | 3361 3361 |
| 28040 | 28040 | 8a7eb | 3321 3321 |
| 36360 | 36360 | 8a7eb | 2968 2968 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)