This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 27824 | 27824 | cc5ed | 2878 2878 |
| 27825 | 27825 | 3da9b | 2878 2878 |
| 27826 | 27826 | 371f0 | 2878 2878 |
| 27827 | 27827 | 5e075 | 2878 2878 |
| 27828 | 27828 | 59d75 | 2878 2878 |
| 27829 | 27829 | e6200 | 2878 2878 |
| 27830 | 27830 | b1201 | 2878 2878 |
| 27831 | 27831 | 8a7ee | 2878 2878 |
| 27832 | 27832 | 862ed | 2878 2878 |
| 27833 | 27833 | f788a | 2878 2878 |
| 27834 | 27834 | df1f0 | 2878 2878 |
| 27835 | 27835 | a1307 | 2878 2878 |
| 27836 | 27836 | 8d2e9 | 2878 2878 |
| 27837 | 27837 | 27369 | 2878 2878 |
| 27838 | 27838 | e128e | 2878 2878 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)