This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 1632 | 1632 | cc5ed | 2409 2409 |
| 1633 | 1633 | 4698a | 2409 2409 |
| 1634 | 1634 | e6200 | 2409 2409 |
| 1635 | 1635 | b1201 | 2409 2409 |
| 1636 | 1636 | 66f82 | 2409 2409 |
| 1637 | 1637 | a2d21 | 2409 2409 |
| 1638 | 1638 | a1307 | 2409 2409 |
| 1639 | 1639 | 41b26 | 2409 2409 |
| 1640 | 1640 | 0deb1 | 2409 2409 |
| 1641 | 1641 | 6a38c | 2409 2409 |
| 1642 | 1642 | e128e | 2409 2409 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)