This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 7974 | 7974 | ec3ac | 800 800 |
| 7975 | 7975 | d6ade | 800 800 |
| 7976 | 7976 | 8e7b3 | 800 800 |
| 7977 | 7977 | 2dfbd | 800 800 |
| 7978 | 7978 | ebe26 | 800 800 |
| 7979 | 7979 | a0f55 | 800 800 |
| 7980 | 7980 | 371f0 | 800 800 |
| 7981 | 7981 | 4accc | 800 800 |
| 7982 | 7982 | b1201 | 800 800 |
| 7983 | 7983 | d003e | 800 800 |
| 7984 | 7984 | a340a | 800 800 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)