This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 404 | 404 | cc5ed | 2868 2868 |
| 405 | 405 | 3da9b | 2868 2868 |
| 406 | 406 | 371f0 | 2868 2868 |
| 407 | 407 | 5e075 | 2868 2868 |
| 408 | 408 | 59d75 | 2868 2868 |
| 409 | 409 | e6200 | 2868 2868 |
| 410 | 410 | b1201 | 2868 2868 |
| 411 | 411 | 902e5 | 2868 2868 |
| 412 | 412 | 8a7ee | 2868 2868 |
| 413 | 413 | 862ed | 2868 2868 |
| 414 | 414 | f788a | 2868 2868 |
| 415 | 415 | 9848a | 2868 2868 |
| 416 | 416 | abb72 | 2868 2868 |
| 417 | 417 | 27369 | 2868 2868 |
| 418 | 418 | e128e | 2868 2868 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)