This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 24328 | 24328 | cc5ed | 2925 2925 |
| 24329 | 24329 | c1190 | 2925 2925 |
| 24330 | 24330 | cb80d | 2925 2925 |
| 24331 | 24331 | 371f0 | 2925 2925 |
| 24332 | 24332 | bf1e7 | 2925 2925 |
| 24333 | 24333 | e6200 | 2925 2925 |
| 24334 | 24334 | b1201 | 2925 2925 |
| 24335 | 24335 | 902e5 | 2925 2925 |
| 24336 | 24336 | b918e | 2925 2925 |
| 24337 | 24337 | 597b7 | 2925 2925 |
| 24338 | 24338 | 48ab1 | 2925 2925 |
| 24339 | 24339 | 83826 | 2925 2925 |
| 24340 | 24340 | dbf07 | 2925 2925 |
| 24341 | 24341 | 56bb6 | 2925 2925 |
| 24342 | 24342 | 927de | 2925 2925 |
| 24343 | 24343 | 35c78 | 2925 2925 |
| 24344 | 24344 | fd049 | 2925 2925 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)