This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 28816 | 28816 | cc5ed | 3237 3237 |
| 28817 | 28817 | e4503 | 3237 3237 |
| 28818 | 28818 | 371f0 | 3237 3237 |
| 28819 | 28819 | 5e075 | 3237 3237 |
| 28820 | 28820 | 59d75 | 3237 3237 |
| 28821 | 28821 | e6200 | 3237 3237 |
| 28822 | 28822 | b1201 | 3237 3237 |
| 28823 | 28823 | 902e5 | 3237 3237 |
| 28824 | 28824 | ebf60 | 3237 3237 |
| 28825 | 28825 | bbdfd | 3237 3237 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)