This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 1708 | 1708 | cc5ed | 2993 2993 |
| 1709 | 1709 | 40c27 | 2993 2993 |
| 1710 | 1710 | f4921 | 2993 2993 |
| 1711 | 1711 | 550f6 | 2993 2993 |
| 1712 | 1712 | c0f52 | 2993 2993 |
| 1713 | 1713 | aabe0 | 2993 2993 |
| 1714 | 1714 | a06cb | 2993 2993 |
| 1715 | 1715 | 87fac | 2993 2993 |
| 1716 | 1716 | cbcce | 2993 2993 |
| 1717 | 1717 | 7ceb1 | 2993 2993 |
| 1718 | 1718 | 371f0 | 2993 2993 |
| 1719 | 1719 | e6200 | 2993 2993 |
| 1720 | 1720 | b1201 | 2993 2993 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)