This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 668 | 668 | ebcbb | 2276 2276 |
| 669 | 669 | 4801f | 2276 2276 |
| 670 | 670 | 5e075 | 2276 2276 |
| 671 | 671 | 59d75 | 2276 2276 |
| 672 | 672 | e6200 | 2276 2276 |
| 673 | 673 | b1201 | 2276 2276 |
| 674 | 674 | 8a7ee | 2276 2276 |
| 675 | 675 | 862ed | 2276 2276 |
| 676 | 676 | 18a64 | 2276 2276 |
| 677 | 677 | 9848a | 2276 2276 |
| 678 | 678 | abb72 | 2276 2276 |
| 679 | 679 | 93975 | 2276 2276 |
| 680 | 680 | 27369 | 2276 2276 |
| 681 | 681 | 7ee91 | 2276 2276 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)