This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 35741 | 35741 | 28463 | 1148 1148 |
| 35742 | 35742 | 24da8 | 1148 1148 |
| 35743 | 35743 | d5b86 | 1148 1148 |
| 35744 | 35744 | 36203 | 1148 1148 |
| 35745 | 35745 | 17a50 | 1148 1148 |
| 35746 | 35746 | aa5af | 1148 1148 |
| 35747 | 35747 | 16102 | 1148 1148 |
| 35748 | 35748 | 59677 | 1148 1148 |
| 35749 | 35749 | 40ff5 | 1148 1148 |
| 35750 | 35750 | e95f6 | 1148 1148 |
| 35751 | 35751 | 371f0 | 1148 1148 |
| 35752 | 35752 | 5e075 | 1148 1148 |
| 35753 | 35753 | 59d75 | 1148 1148 |
| 35754 | 35754 | e6200 | 1148 1148 |
| 35755 | 35755 | b1201 | 1148 1148 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)