This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 15872 | 15872 | cc5ed | 2786 2786 |
| 15873 | 15873 | cba3e | 2786 2786 |
| 15874 | 15874 | 371f0 | 2786 2786 |
| 15875 | 15875 | e6200 | 2786 2786 |
| 15876 | 15876 | b1201 | 2786 2786 |
| 15877 | 15877 | 902e5 | 2786 2786 |
| 15878 | 15878 | 7e7c6 | 2786 2786 |
| 15879 | 15879 | 4f54f | 2786 2786 |
| 15880 | 15880 | db9ea | 2786 2786 |
| 15881 | 15881 | 8751c | 2786 2786 |
| 15882 | 15882 | 12cf3 | 2786 2786 |
| 15883 | 15883 | 397c1 | 2786 2786 |
| 15884 | 15884 | 55a79 | 2786 2786 |
| 15885 | 15885 | ccbed | 2786 2786 |
| 15886 | 15886 | 2e370 | 2786 2786 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)