This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 6011 | 6011 | e737a | 3006 3006 |
| 15701 | 15701 | e737a | 2365 2365 |
| 15951 | 15951 | e737a | 2372 2372 |
| 16132 | 16132 | e737a | 3329 3329 |
| 16279 | 16279 | e737a | 3278 3278 |
| 16407 | 16407 | e737a | 3338 3338 |
| 16735 | 16735 | e737a | 2385 2385 |
| 17248 | 17248 | e737a | 3311 3311 |
| 17779 | 17779 | e737a | 3340 3340 |
| 17861 | 17861 | e737a | 2367 2367 |
| 17956 | 17956 | e737a | 3342 3342 |
| 23249 | 23249 | e737a | 3351 3351 |
| 23458 | 23458 | e737a | 3325 3325 |
| 24523 | 24523 | e737a | 3318 3318 |
| 24614 | 24614 | e737a | 3332 3332 |
| 25968 | 25968 | e737a | 3362 3362 |
| 26190 | 26190 | e737a | 3326 3326 |
| 26987 | 26987 | e737a | 3327 3327 |
| 27382 | 27382 | e737a | 3339 3339 |
| 27683 | 27683 | e737a | 3347 3347 |
| 27818 | 27818 | e737a | 3322 3322 |
| 27885 | 27885 | e737a | 3320 3320 |
| 27958 | 27958 | e737a | 3361 3361 |
| 28054 | 28054 | e737a | 3321 3321 |
| 28318 | 28318 | e737a | 3182 3182 |
| 29520 | 29520 | e737a | 2984 2984 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)