This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 317 | 317 | a06cb | 857 857 |
| 923 | 923 | a06cb | 853 853 |
| 1092 | 1092 | a06cb | 775 775 |
| 1357 | 1357 | a06cb | 2987 2987 |
| 1495 | 1495 | a06cb | 2986 2986 |
| 1547 | 1547 | a06cb | 863 863 |
| 1578 | 1578 | a06cb | 786 786 |
| 1701 | 1701 | a06cb | 2989 2989 |
| 1714 | 1714 | a06cb | 2993 2993 |
| 2179 | 2179 | a06cb | 2985 2985 |
| 2202 | 2202 | a06cb | 2995 2995 |
| 2242 | 2242 | a06cb | 2990 2990 |
| 5306 | 5306 | a06cb | 2510 2510 |
| 7253 | 7253 | a06cb | 803 803 |
| 7397 | 7397 | a06cb | 2537 2537 |
| 7927 | 7927 | a06cb | 2517 2517 |
| 8003 | 8003 | a06cb | 864 864 |
| 14798 | 14798 | a06cb | 1232 1232 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)