This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 5190 | 5190 | e9db4 | 1092 1092 |
| 5494 | 5494 | e9db4 | 1064 1064 |
| 6276 | 6276 | e9db4 | 2533 2533 |
| 6305 | 6305 | e9db4 | 2540 2540 |
| 6557 | 6557 | e9db4 | 2504 2504 |
| 6646 | 6646 | e9db4 | 2480 2480 |
| 6915 | 6915 | e9db4 | 1061 1061 |
| 7076 | 7076 | e9db4 | 2528 2528 |
| 7309 | 7309 | e9db4 | 2479 2479 |
| 7428 | 7428 | e9db4 | 1090 1090 |
| 7467 | 7467 | e9db4 | 2487 2487 |
| 7641 | 7641 | e9db4 | 2520 2520 |
| 7863 | 7863 | e9db4 | 1164 1164 |
| 7941 | 7941 | e9db4 | 2488 2488 |
| 31069 | 31069 | e9db4 | 27 27 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)