This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 6442 | 6442 | ec3ac | 2845 2845 |
| 6443 | 6443 | 3da9b | 2845 2845 |
| 6444 | 6444 | 371f0 | 2845 2845 |
| 6445 | 6445 | e6200 | 2845 2845 |
| 6446 | 6446 | b1201 | 2845 2845 |
| 6447 | 6447 | 902e5 | 2845 2845 |
| 6448 | 6448 | 8a7ee | 2845 2845 |
| 6449 | 6449 | 862ed | 2845 2845 |
| 6450 | 6450 | a1307 | 2845 2845 |
| 6451 | 6451 | abb72 | 2845 2845 |
| 6452 | 6452 | 27369 | 2845 2845 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)