This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 2526 | 2526 | f3822 | 1467 1467 |
| 2816 | 2816 | f3822 | 1466 1466 |
| 2864 | 2864 | f3822 | 1468 1468 |
| 12671 | 12671 | f3822 | 1484 1484 |
| 13261 | 13261 | f3822 | 1503 1503 |
| 13290 | 13290 | f3822 | 1494 1494 |
| 14034 | 14034 | f3822 | 1497 1497 |
| 14161 | 14161 | f3822 | 1481 1481 |
| 14427 | 14427 | f3822 | 1455 1455 |
| 14498 | 14498 | f3822 | 1475 1475 |
| 14904 | 14904 | f3822 | 1513 1513 |
| 15502 | 15502 | f3822 | 1506 1506 |
| 19386 | 19386 | f3822 | 1478 1478 |
| 20108 | 20108 | f3822 | 1500 1500 |
| 31050 | 31050 | f3822 | 1873 1873 |
| 32254 | 32254 | f3822 | 1537 1537 |
| 32317 | 32317 | f3822 | 1552 1552 |
| 32537 | 32537 | f3822 | 1539 1539 |
| 33067 | 33067 | f3822 | 1538 1538 |
| 33160 | 33160 | f3822 | 1551 1551 |
| 33321 | 33321 | f3822 | 1540 1540 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)