This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 33486 | 33486 | ec3ac | 836 836 |
| 33487 | 33487 | b668a | 836 836 |
| 33488 | 33488 | a14cf | 836 836 |
| 33489 | 33489 | 5e075 | 836 836 |
| 33490 | 33490 | 59d75 | 836 836 |
| 33491 | 33491 | e6200 | 836 836 |
| 33492 | 33492 | b1201 | 836 836 |
| 33493 | 33493 | b42a4 | 836 836 |
| 33494 | 33494 | d679e | 836 836 |
| 33495 | 33495 | 17bc7 | 836 836 |
| 33496 | 33496 | aa04d | 836 836 |
| 33497 | 33497 | 95f91 | 836 836 |
| 33498 | 33498 | 65a38 | 836 836 |
| 33499 | 33499 | e128e | 836 836 |
| 33500 | 33500 | d75c0 | 836 836 |
| 33501 | 33501 | 16071 | 836 836 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)