This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 811 | 811 | cc5ed | 2811 2811 |
| 812 | 812 | d6ade | 2811 2811 |
| 813 | 813 | 8e7b3 | 2811 2811 |
| 814 | 814 | 5ad28 | 2811 2811 |
| 815 | 815 | d4179 | 2811 2811 |
| 816 | 816 | 313af | 2811 2811 |
| 817 | 817 | 27176 | 2811 2811 |
| 818 | 818 | 94840 | 2811 2811 |
| 819 | 819 | ebe26 | 2811 2811 |
| 820 | 820 | aabe0 | 2811 2811 |
| 821 | 821 | a0f55 | 2811 2811 |
| 822 | 822 | 371f0 | 2811 2811 |
| 823 | 823 | e6200 | 2811 2811 |
| 824 | 824 | 3502d | 2811 2811 |
| 825 | 825 | b1201 | 2811 2811 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)