This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 25327 | 25327 | cc5ed | 2932 2932 |
| 25328 | 25328 | c1190 | 2932 2932 |
| 25329 | 25329 | cb80d | 2932 2932 |
| 25330 | 25330 | 371f0 | 2932 2932 |
| 25331 | 25331 | bf1e7 | 2932 2932 |
| 25332 | 25332 | e6200 | 2932 2932 |
| 25333 | 25333 | b1201 | 2932 2932 |
| 25334 | 25334 | 902e5 | 2932 2932 |
| 25335 | 25335 | bc1ac | 2932 2932 |
| 25336 | 25336 | 6ec75 | 2932 2932 |
| 25337 | 25337 | 5b456 | 2932 2932 |
| 25338 | 25338 | 77d7e | 2932 2932 |
| 25339 | 25339 | c46d7 | 2932 2932 |
| 25340 | 25340 | e5437 | 2932 2932 |
| 25341 | 25341 | 469ba | 2932 2932 |
| 25342 | 25342 | feaa7 | 2932 2932 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)