This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 28923 | 28923 | 1233d | 3272 3272 |
| 28924 | 28924 | 13c3e | 3272 3272 |
| 28925 | 28925 | 371f0 | 3272 3272 |
| 28926 | 28926 | 5e075 | 3272 3272 |
| 28927 | 28927 | 59d75 | 3272 3272 |
| 28928 | 28928 | e6200 | 3272 3272 |
| 28929 | 28929 | b1201 | 3272 3272 |
| 28930 | 28930 | 902e5 | 3272 3272 |
| 28931 | 28931 | 77d7e | 3272 3272 |
| 28932 | 28932 | e5437 | 3272 3272 |
| 28933 | 28933 | 1fd76 | 3272 3272 |
| 28934 | 28934 | 5a70c | 3272 3272 |
| 28935 | 28935 | b3fcc | 3272 3272 |
| 28936 | 28936 | 63250 | 3272 3272 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)