This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 6385 | 6385 | ec3ac | 1136 1136 |
| 6386 | 6386 | 17183 | 1136 1136 |
| 6387 | 6387 | afc04 | 1136 1136 |
| 6388 | 6388 | c4200 | 1136 1136 |
| 6389 | 6389 | 313af | 1136 1136 |
| 6390 | 6390 | ebe26 | 1136 1136 |
| 6391 | 6391 | aabe0 | 1136 1136 |
| 6392 | 6392 | 9e07c | 1136 1136 |
| 6393 | 6393 | 1073c | 1136 1136 |
| 6394 | 6394 | 4801f | 1136 1136 |
| 6395 | 6395 | 5e075 | 1136 1136 |
| 6396 | 6396 | 59d75 | 1136 1136 |
| 6397 | 6397 | e6200 | 1136 1136 |
| 6398 | 6398 | b1201 | 1136 1136 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)