This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 34414 | 34414 | ec3ac | 796 796 |
| 34415 | 34415 | b668a | 796 796 |
| 34416 | 34416 | a14cf | 796 796 |
| 34417 | 34417 | 5e075 | 796 796 |
| 34418 | 34418 | 59d75 | 796 796 |
| 34419 | 34419 | e6200 | 796 796 |
| 34420 | 34420 | b1201 | 796 796 |
| 34421 | 34421 | b42a4 | 796 796 |
| 34422 | 34422 | d679e | 796 796 |
| 34423 | 34423 | 17bc7 | 796 796 |
| 34424 | 34424 | aa04d | 796 796 |
| 34425 | 34425 | 95f91 | 796 796 |
| 34426 | 34426 | 65a38 | 796 796 |
| 34427 | 34427 | e128e | 796 796 |
| 34428 | 34428 | d75c0 | 796 796 |
| 34429 | 34429 | 16071 | 796 796 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)