This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 7996 | 7996 | ec3ac | 864 864 |
| 7997 | 7997 | d6ade | 864 864 |
| 7998 | 7998 | 8e7b3 | 864 864 |
| 7999 | 7999 | 40c27 | 864 864 |
| 8000 | 8000 | d4179 | 864 864 |
| 8001 | 8001 | 313af | 864 864 |
| 8002 | 8002 | ebe26 | 864 864 |
| 8003 | 8003 | a06cb | 864 864 |
| 8004 | 8004 | 87fac | 864 864 |
| 8005 | 8005 | a0f55 | 864 864 |
| 8006 | 8006 | 2f957 | 864 864 |
| 8007 | 8007 | 61c1a | 864 864 |
| 8008 | 8008 | e6200 | 864 864 |
| 8009 | 8009 | b1201 | 864 864 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)