This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 1611 | 1611 | cc5ed | 2807 2807 |
| 1612 | 1612 | d6ade | 2807 2807 |
| 1613 | 1613 | 8e7b3 | 2807 2807 |
| 1614 | 1614 | 313af | 2807 2807 |
| 1615 | 1615 | 27176 | 2807 2807 |
| 1616 | 1616 | ebe26 | 2807 2807 |
| 1617 | 1617 | a0f55 | 2807 2807 |
| 1618 | 1618 | 371f0 | 2807 2807 |
| 1619 | 1619 | e6200 | 2807 2807 |
| 1620 | 1620 | 3502d | 2807 2807 |
| 1621 | 1621 | b1201 | 2807 2807 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)