This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 8859 | 8859 | 28463 | 1218 1218 |
| 8860 | 8860 | 24da8 | 1218 1218 |
| 8861 | 8861 | d5b86 | 1218 1218 |
| 8862 | 8862 | 36203 | 1218 1218 |
| 8863 | 8863 | 17a50 | 1218 1218 |
| 8864 | 8864 | 40ff5 | 1218 1218 |
| 8865 | 8865 | e95f6 | 1218 1218 |
| 8866 | 8866 | 371f0 | 1218 1218 |
| 8867 | 8867 | 5e075 | 1218 1218 |
| 8868 | 8868 | 59d75 | 1218 1218 |
| 8869 | 8869 | e6200 | 1218 1218 |
| 8870 | 8870 | b1201 | 1218 1218 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)