This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 26672 | 26672 | ec3ac | 2773 2773 |
| 26673 | 26673 | 3909d | 2773 2773 |
| 26674 | 26674 | 371f0 | 2773 2773 |
| 26675 | 26675 | 5e075 | 2773 2773 |
| 26676 | 26676 | 59d75 | 2773 2773 |
| 26677 | 26677 | e6200 | 2773 2773 |
| 26678 | 26678 | b1201 | 2773 2773 |
| 26679 | 26679 | d745f | 2773 2773 |
| 26680 | 26680 | 27704 | 2773 2773 |
| 26681 | 26681 | ae91e | 2773 2773 |
| 26682 | 26682 | 0eea2 | 2773 2773 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)