This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 29611 | 29611 | cc5ed | 2647 2647 |
| 29612 | 29612 | 2ed33 | 2647 2647 |
| 29613 | 29613 | 4801f | 2647 2647 |
| 29614 | 29614 | d2747 | 2647 2647 |
| 29615 | 29615 | 5e075 | 2647 2647 |
| 29616 | 29616 | 59d75 | 2647 2647 |
| 29617 | 29617 | f9d07 | 2647 2647 |
| 29618 | 29618 | e6200 | 2647 2647 |
| 29619 | 29619 | b1201 | 2647 2647 |
| 29620 | 29620 | 902e5 | 2647 2647 |
| 29621 | 29621 | 5f10e | 2647 2647 |
| 29622 | 29622 | 007df | 2647 2647 |
| 29623 | 29623 | d3539 | 2647 2647 |
| 29624 | 29624 | 60626 | 2647 2647 |
| 29625 | 29625 | 839f9 | 2647 2647 |
| 29626 | 29626 | ffca2 | 2647 2647 |
| 29627 | 29627 | a56e6 | 2647 2647 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)