This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 7085 | 7085 | cc5ed | 2979 2979 |
| 7086 | 7086 | 685a3 | 2979 2979 |
| 7087 | 7087 | 5e075 | 2979 2979 |
| 7088 | 7088 | 59d75 | 2979 2979 |
| 7089 | 7089 | e6200 | 2979 2979 |
| 7090 | 7090 | b1201 | 2979 2979 |
| 7091 | 7091 | 902e5 | 2979 2979 |
| 7092 | 7092 | baefa | 2979 2979 |
| 7093 | 7093 | 455ad | 2979 2979 |
| 7094 | 7094 | 0e2cf | 2979 2979 |
| 7095 | 7095 | 662b5 | 2979 2979 |
| 7096 | 7096 | ee67e | 2979 2979 |
| 7097 | 7097 | 5d35f | 2979 2979 |
| 7098 | 7098 | 13e72 | 2979 2979 |
| 7099 | 7099 | 50b3d | 2979 2979 |
| 7100 | 7100 | 7658e | 2979 2979 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)