This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 18221 | 18221 | ec3ac | 3305 3305 |
| 18222 | 18222 | 371f0 | 3305 3305 |
| 18223 | 18223 | 5e075 | 3305 3305 |
| 18224 | 18224 | 59d75 | 3305 3305 |
| 18225 | 18225 | e6200 | 3305 3305 |
| 18226 | 18226 | b1201 | 3305 3305 |
| 18227 | 18227 | 902e5 | 3305 3305 |
| 18228 | 18228 | ec5e3 | 3305 3305 |
| 18229 | 18229 | 372e7 | 3305 3305 |
| 18230 | 18230 | 2e713 | 3305 3305 |
| 18231 | 18231 | bbce5 | 3305 3305 |
| 18232 | 18232 | 934a1 | 3305 3305 |
| 18233 | 18233 | 386c6 | 3305 3305 |
| 18234 | 18234 | f7021 | 3305 3305 |
| 18235 | 18235 | 5e641 | 3305 3305 |
| 18236 | 18236 | cf71d | 3305 3305 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)