This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 25497 | 25497 | cc5ed | 3106 3106 |
| 25498 | 25498 | d6ade | 3106 3106 |
| 25499 | 25499 | 8e7b3 | 3106 3106 |
| 25500 | 25500 | d4179 | 3106 3106 |
| 25501 | 25501 | 313af | 3106 3106 |
| 25502 | 25502 | 6e219 | 3106 3106 |
| 25503 | 25503 | aabe0 | 3106 3106 |
| 25504 | 25504 | a0f55 | 3106 3106 |
| 25505 | 25505 | 371f0 | 3106 3106 |
| 25506 | 25506 | e6200 | 3106 3106 |
| 25507 | 25507 | b1201 | 3106 3106 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)