This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 16813 | 16813 | cc5ed | 2427 2427 |
| 16814 | 16814 | 5fc41 | 2427 2427 |
| 16815 | 16815 | e2dbf | 2427 2427 |
| 16816 | 16816 | 5e075 | 2427 2427 |
| 16817 | 16817 | 59d75 | 2427 2427 |
| 16818 | 16818 | e6200 | 2427 2427 |
| 16819 | 16819 | b1201 | 2427 2427 |
| 16820 | 16820 | 8ee70 | 2427 2427 |
| 16821 | 16821 | 4be0b | 2427 2427 |
| 16822 | 16822 | cbdd5 | 2427 2427 |
| 16823 | 16823 | c08cd | 2427 2427 |
| 16824 | 16824 | bf5f5 | 2427 2427 |
| 16825 | 16825 | ea908 | 2427 2427 |
| 16826 | 16826 | 5d467 | 2427 2427 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)