This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 65 | 65 | cc5ed | 3169 3169 |
| 66 | 66 | d6ade | 3169 3169 |
| 67 | 67 | 8e7b3 | 3169 3169 |
| 68 | 68 | d4179 | 3169 3169 |
| 69 | 69 | 313af | 3169 3169 |
| 70 | 70 | ebe26 | 3169 3169 |
| 71 | 71 | aabe0 | 3169 3169 |
| 72 | 72 | a0f55 | 3169 3169 |
| 73 | 73 | 371f0 | 3169 3169 |
| 74 | 74 | e6200 | 3169 3169 |
| 75 | 75 | b1201 | 3169 3169 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)