This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 5681 | 5681 | cc5ed | 2529 2529 |
| 5682 | 5682 | d6ade | 2529 2529 |
| 5683 | 5683 | 8e7b3 | 2529 2529 |
| 5684 | 5684 | 313af | 2529 2529 |
| 5685 | 5685 | ebe26 | 2529 2529 |
| 5686 | 5686 | a0f55 | 2529 2529 |
| 5687 | 5687 | cbcce | 2529 2529 |
| 5688 | 5688 | 1073c | 2529 2529 |
| 5689 | 5689 | 371f0 | 2529 2529 |
| 5690 | 5690 | e6200 | 2529 2529 |
| 5691 | 5691 | b1201 | 2529 2529 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)