This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 7882 | 7882 | cc5ed | 2819 2819 |
| 7883 | 7883 | 27335 | 2819 2819 |
| 7884 | 7884 | 371f0 | 2819 2819 |
| 7885 | 7885 | e6200 | 2819 2819 |
| 7886 | 7886 | b1201 | 2819 2819 |
| 7887 | 7887 | 902e5 | 2819 2819 |
| 7888 | 7888 | 8a7ee | 2819 2819 |
| 7889 | 7889 | 862ed | 2819 2819 |
| 7890 | 7890 | f788a | 2819 2819 |
| 7891 | 7891 | 04e82 | 2819 2819 |
| 7892 | 7892 | c69e6 | 2819 2819 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)