This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 8849 | 8849 | ec3ac | 1939 1939 |
| 8850 | 8850 | 6816d | 1939 1939 |
| 8851 | 8851 | 25178 | 1939 1939 |
| 8852 | 8852 | 88d03 | 1939 1939 |
| 8853 | 8853 | ccda0 | 1939 1939 |
| 8854 | 8854 | ddc84 | 1939 1939 |
| 8855 | 8855 | d1e7b | 1939 1939 |
| 8856 | 8856 | 5e075 | 1939 1939 |
| 8857 | 8857 | 59d75 | 1939 1939 |
| 8858 | 8858 | 3502d | 1939 1939 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)