This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 7918 | 7918 | cc5ed | 2517 2517 |
| 7919 | 7919 | d6ade | 2517 2517 |
| 7920 | 7920 | 8e7b3 | 2517 2517 |
| 7921 | 7921 | 40c27 | 2517 2517 |
| 7922 | 7922 | 550f6 | 2517 2517 |
| 7923 | 7923 | c4200 | 2517 2517 |
| 7924 | 7924 | e0460 | 2517 2517 |
| 7925 | 7925 | ebe26 | 2517 2517 |
| 7926 | 7926 | aabe0 | 2517 2517 |
| 7927 | 7927 | a06cb | 2517 2517 |
| 7928 | 7928 | 87fac | 2517 2517 |
| 7929 | 7929 | a0f55 | 2517 2517 |
| 7930 | 7930 | 1073c | 2517 2517 |
| 7931 | 7931 | 371f0 | 2517 2517 |
| 7932 | 7932 | e6200 | 2517 2517 |
| 7933 | 7933 | b1201 | 2517 2517 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)