This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 29779 | 29779 | cc5ed | 2646 2646 |
| 29780 | 29780 | 2ed33 | 2646 2646 |
| 29781 | 29781 | 4801f | 2646 2646 |
| 29782 | 29782 | d2747 | 2646 2646 |
| 29783 | 29783 | 5e075 | 2646 2646 |
| 29784 | 29784 | 59d75 | 2646 2646 |
| 29785 | 29785 | f9d07 | 2646 2646 |
| 29786 | 29786 | e6200 | 2646 2646 |
| 29787 | 29787 | b1201 | 2646 2646 |
| 29788 | 29788 | 902e5 | 2646 2646 |
| 29789 | 29789 | 4f89e | 2646 2646 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)