This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 18245 | 18245 | ec3ac | 2768 2768 |
| 18246 | 18246 | 3909d | 2768 2768 |
| 18247 | 18247 | 7b150 | 2768 2768 |
| 18248 | 18248 | 5e075 | 2768 2768 |
| 18249 | 18249 | 59d75 | 2768 2768 |
| 18250 | 18250 | e6200 | 2768 2768 |
| 18251 | 18251 | b1201 | 2768 2768 |
| 18252 | 18252 | 902e5 | 2768 2768 |
| 18253 | 18253 | e80cf | 2768 2768 |
| 18254 | 18254 | 3e75a | 2768 2768 |
| 18255 | 18255 | e086a | 2768 2768 |
| 18256 | 18256 | c48f9 | 2768 2768 |
| 18257 | 18257 | 90531 | 2768 2768 |
| 18258 | 18258 | d5d34 | 2768 2768 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)