This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 974 | 974 | cc5ed | 3138 3138 |
| 975 | 975 | d6ade | 3138 3138 |
| 976 | 976 | 8e7b3 | 3138 3138 |
| 977 | 977 | d4179 | 3138 3138 |
| 978 | 978 | 313af | 3138 3138 |
| 979 | 979 | ebe26 | 3138 3138 |
| 980 | 980 | aabe0 | 3138 3138 |
| 981 | 981 | a0f55 | 3138 3138 |
| 982 | 982 | 371f0 | 3138 3138 |
| 983 | 983 | e6200 | 3138 3138 |
| 984 | 984 | b1201 | 3138 3138 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)