This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 5735 | 5735 | 49b74 | 1670 1670 |
| 5808 | 5808 | 49b74 | 1664 1664 |
| 6026 | 6026 | 49b74 | 1634 1634 |
| 6221 | 6221 | 49b74 | 1633 1633 |
| 6407 | 6407 | 49b74 | 1671 1671 |
| 6471 | 6471 | 49b74 | 1663 1663 |
| 6618 | 6618 | 49b74 | 1619 1619 |
| 7319 | 7319 | 49b74 | 1618 1618 |
| 13503 | 13503 | 49b74 | 1945 1945 |
| 31548 | 31548 | 49b74 | 2444 2444 |
| 31845 | 31845 | 49b74 | 2440 2440 |
| 32169 | 32169 | 49b74 | 2443 2443 |
| 32450 | 32450 | 49b74 | 2439 2439 |
| 32639 | 32639 | 49b74 | 2441 2441 |
| 32983 | 32983 | 49b74 | 2442 2442 |
| 34608 | 34608 | 49b74 | 1910 1910 |
| 34940 | 34940 | 49b74 | 525 525 |
| 35292 | 35292 | 49b74 | 32 32 |
| 35408 | 35408 | 49b74 | 1911 1911 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)