This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 31545 | 31545 | f6566 | 2444 2444 |
| 31546 | 31546 | 8657c | 2444 2444 |
| 31547 | 31547 | bffb8 | 2444 2444 |
| 31548 | 31548 | 49b74 | 2444 2444 |
| 31549 | 31549 | 384b9 | 2444 2444 |
| 31550 | 31550 | aa920 | 2444 2444 |
| 31551 | 31551 | b733d | 2444 2444 |
| 31552 | 31552 | 57006 | 2444 2444 |
| 31553 | 31553 | bfd83 | 2444 2444 |
| 31554 | 31554 | 9eadd | 2444 2444 |
| 31555 | 31555 | 0d4bc | 2444 2444 |
| 31556 | 31556 | 73122 | 2444 2444 |
| 31557 | 31557 | e35f3 | 2444 2444 |
| 31558 | 31558 | f38f6 | 2444 2444 |
| 31559 | 31559 | 8a526 | 2444 2444 |
| 31560 | 31560 | 1073c | 2444 2444 |
| 31561 | 31561 | 9e156 | 2444 2444 |
| 31562 | 31562 | e6200 | 2444 2444 |
| 31563 | 31563 | b1201 | 2444 2444 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)