This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 5977 | 5977 | e38cb | 1093 1093 |
| 6213 | 6213 | e38cb | 1094 1094 |
| 6950 | 6950 | e38cb | 1066 1066 |
| 7193 | 7193 | e38cb | 1065 1065 |
| 7381 | 7381 | e38cb | 1165 1165 |
| 7534 | 7534 | e38cb | 1062 1062 |
| 8146 | 8146 | e38cb | 1063 1063 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)