This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 4903 | 4903 | ec3ac | 584 584 |
| 4904 | 4904 | 7d863 | 584 584 |
| 4905 | 4905 | cda75 | 584 584 |
| 4906 | 4906 | eed19 | 584 584 |
| 4907 | 4907 | bde08 | 584 584 |
| 4908 | 4908 | 84f2d | 584 584 |
| 4909 | 4909 | 7a280 | 584 584 |
| 4910 | 4910 | 1aff9 | 584 584 |
| 4911 | 4911 | 0b2ab | 584 584 |
| 4912 | 4912 | 371f0 | 584 584 |
| 4913 | 4913 | 5e075 | 584 584 |
| 4914 | 4914 | 59d75 | 584 584 |
| 4915 | 4915 | e6200 | 584 584 |
| 4916 | 4916 | b1201 | 584 584 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)