This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 16724 | 16724 | 189ac | 2385 2385 |
| 16725 | 16725 | 371f0 | 2385 2385 |
| 16726 | 16726 | e6200 | 2385 2385 |
| 16727 | 16727 | b1201 | 2385 2385 |
| 16728 | 16728 | 5e6f8 | 2385 2385 |
| 16729 | 16729 | 463ae | 2385 2385 |
| 16730 | 16730 | 93324 | 2385 2385 |
| 16731 | 16731 | f9b79 | 2385 2385 |
| 16732 | 16732 | 06ae5 | 2385 2385 |
| 16733 | 16733 | 710d1 | 2385 2385 |
| 16734 | 16734 | 7c76f | 2385 2385 |
| 16735 | 16735 | e737a | 2385 2385 |
| 16736 | 16736 | c45c4 | 2385 2385 |
| 16737 | 16737 | 60bee | 2385 2385 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)