This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 151 | 151 | c45c4 | 2827 2827 |
| 6012 | 6012 | c45c4 | 3006 3006 |
| 15702 | 15702 | c45c4 | 2365 2365 |
| 15952 | 15952 | c45c4 | 2372 2372 |
| 16134 | 16134 | c45c4 | 3329 3329 |
| 16736 | 16736 | c45c4 | 2385 2385 |
| 17862 | 17862 | c45c4 | 2367 2367 |
| 17958 | 17958 | c45c4 | 3342 3342 |
| 23251 | 23251 | c45c4 | 3351 3351 |
| 23328 | 23328 | c45c4 | 3331 3331 |
| 23460 | 23460 | c45c4 | 3325 3325 |
| 23544 | 23544 | c45c4 | 3319 3319 |
| 24616 | 24616 | c45c4 | 3332 3332 |
| 24735 | 24735 | c45c4 | 3352 3352 |
| 26989 | 26989 | c45c4 | 3327 3327 |
| 27513 | 27513 | c45c4 | 3341 3341 |
| 27685 | 27685 | c45c4 | 3347 3347 |
| 27887 | 27887 | c45c4 | 3320 3320 |
| 28319 | 28319 | c45c4 | 3182 3182 |
| 29248 | 29248 | c45c4 | 3185 3185 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)