This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 22540 | 22540 | cc5ed | 3251 3251 |
| 22541 | 22541 | 2ed33 | 3251 3251 |
| 22542 | 22542 | 371f0 | 3251 3251 |
| 22543 | 22543 | d2747 | 3251 3251 |
| 22544 | 22544 | 5e075 | 3251 3251 |
| 22545 | 22545 | 59d75 | 3251 3251 |
| 22546 | 22546 | f9d07 | 3251 3251 |
| 22547 | 22547 | e6200 | 3251 3251 |
| 22548 | 22548 | b1201 | 3251 3251 |
| 22549 | 22549 | 902e5 | 3251 3251 |
| 22550 | 22550 | 5f10e | 3251 3251 |
| 22551 | 22551 | 007df | 3251 3251 |
| 22552 | 22552 | d3539 | 3251 3251 |
| 22553 | 22553 | 60626 | 3251 3251 |
| 22554 | 22554 | 839f9 | 3251 3251 |
| 22555 | 22555 | ffca2 | 3251 3251 |
| 22556 | 22556 | a56e6 | 3251 3251 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)