This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 27612 | 27612 | ec3ac | 1180 1180 |
| 27613 | 27613 | 4801f | 1180 1180 |
| 27614 | 27614 | 5e075 | 1180 1180 |
| 27615 | 27615 | 59d75 | 1180 1180 |
| 27616 | 27616 | e6200 | 1180 1180 |
| 27617 | 27617 | b1201 | 1180 1180 |
| 27618 | 27618 | d6347 | 1180 1180 |
| 27619 | 27619 | ebf60 | 1180 1180 |
| 27620 | 27620 | 9a8c6 | 1180 1180 |
| 27621 | 27621 | a2d21 | 1180 1180 |
| 27622 | 27622 | a1307 | 1180 1180 |
| 27623 | 27623 | 4225c | 1180 1180 |
| 27624 | 27624 | 41b26 | 1180 1180 |
| 27625 | 27625 | 2db78 | 1180 1180 |
| 27626 | 27626 | 6a38c | 1180 1180 |
| 27627 | 27627 | e128e | 1180 1180 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)