This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 2163 | 2163 | ec3ac | 1153 1153 |
| 2164 | 2164 | 96bbd | 1153 1153 |
| 2165 | 2165 | 313af | 1153 1153 |
| 2166 | 2166 | ebe26 | 1153 1153 |
| 2167 | 2167 | 1073c | 1153 1153 |
| 2168 | 2168 | 4801f | 1153 1153 |
| 2169 | 2169 | 5e075 | 1153 1153 |
| 2170 | 2170 | 59d75 | 1153 1153 |
| 2171 | 2171 | e6200 | 1153 1153 |
| 2172 | 2172 | b1201 | 1153 1153 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)