This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 30497 | 30497 | 5419e | 2383 2383 |
| 30498 | 30498 | 371f0 | 2383 2383 |
| 30499 | 30499 | 5e075 | 2383 2383 |
| 30500 | 30500 | 59d75 | 2383 2383 |
| 30501 | 30501 | e6200 | 2383 2383 |
| 30502 | 30502 | b1201 | 2383 2383 |
| 30503 | 30503 | ad8b2 | 2383 2383 |
| 30504 | 30504 | 84446 | 2383 2383 |
| 30505 | 30505 | 31177 | 2383 2383 |
| 30506 | 30506 | 730ad | 2383 2383 |
| 30507 | 30507 | c5048 | 2383 2383 |
| 30508 | 30508 | 78fb5 | 2383 2383 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)