This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 20006 | 20006 | ec3ac | 947 947 |
| 20007 | 20007 | 4801f | 947 947 |
| 20008 | 20008 | 5e075 | 947 947 |
| 20009 | 20009 | 59d75 | 947 947 |
| 20010 | 20010 | e6200 | 947 947 |
| 20011 | 20011 | b1201 | 947 947 |
| 20012 | 20012 | d6347 | 947 947 |
| 20013 | 20013 | ebf60 | 947 947 |
| 20014 | 20014 | 9a8c6 | 947 947 |
| 20015 | 20015 | a2d21 | 947 947 |
| 20016 | 20016 | a1307 | 947 947 |
| 20017 | 20017 | abb72 | 947 947 |
| 20018 | 20018 | 41b26 | 947 947 |
| 20019 | 20019 | 2db78 | 947 947 |
| 20020 | 20020 | 6a38c | 947 947 |
| 20021 | 20021 | e128e | 947 947 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)