This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 33848 | 33848 | ec3ac | 779 779 |
| 33849 | 33849 | b668a | 779 779 |
| 33850 | 33850 | a14cf | 779 779 |
| 33851 | 33851 | 5e075 | 779 779 |
| 33852 | 33852 | 59d75 | 779 779 |
| 33853 | 33853 | e6200 | 779 779 |
| 33854 | 33854 | b1201 | 779 779 |
| 33855 | 33855 | b42a4 | 779 779 |
| 33856 | 33856 | d679e | 779 779 |
| 33857 | 33857 | 17bc7 | 779 779 |
| 33858 | 33858 | aa04d | 779 779 |
| 33859 | 33859 | 95f91 | 779 779 |
| 33860 | 33860 | 65a38 | 779 779 |
| 33861 | 33861 | e128e | 779 779 |
| 33862 | 33862 | d75c0 | 779 779 |
| 33863 | 33863 | 16071 | 779 779 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)