This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 23498 | 23498 | cc5ed | 3110 3110 |
| 23499 | 23499 | d6ade | 3110 3110 |
| 23500 | 23500 | 8e7b3 | 3110 3110 |
| 23501 | 23501 | d4179 | 3110 3110 |
| 23502 | 23502 | 313af | 3110 3110 |
| 23503 | 23503 | ebe26 | 3110 3110 |
| 23504 | 23504 | aabe0 | 3110 3110 |
| 23505 | 23505 | a0f55 | 3110 3110 |
| 23506 | 23506 | 371f0 | 3110 3110 |
| 23507 | 23507 | e6200 | 3110 3110 |
| 23508 | 23508 | b1201 | 3110 3110 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)