This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 1540 | 1540 | ec3ac | 863 863 |
| 1541 | 1541 | d6ade | 863 863 |
| 1542 | 1542 | 8e7b3 | 863 863 |
| 1543 | 1543 | 40c27 | 863 863 |
| 1544 | 1544 | d4179 | 863 863 |
| 1545 | 1545 | 313af | 863 863 |
| 1546 | 1546 | ebe26 | 863 863 |
| 1547 | 1547 | a06cb | 863 863 |
| 1548 | 1548 | 87fac | 863 863 |
| 1549 | 1549 | a0f55 | 863 863 |
| 1550 | 1550 | 2f957 | 863 863 |
| 1551 | 1551 | 61c1a | 863 863 |
| 1552 | 1552 | e6200 | 863 863 |
| 1553 | 1553 | b1201 | 863 863 |
| 1554 | 1554 | 04629 | 863 863 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)