This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 5781 | 5781 | 189ac | 2324 2324 |
| 5782 | 5782 | 4801f | 2324 2324 |
| 5783 | 5783 | 5e075 | 2324 2324 |
| 5784 | 5784 | 59d75 | 2324 2324 |
| 5785 | 5785 | e6200 | 2324 2324 |
| 5786 | 5786 | b1201 | 2324 2324 |
| 5787 | 5787 | ad8b2 | 2324 2324 |
| 5788 | 5788 | 8a7ee | 2324 2324 |
| 5789 | 5789 | 862ed | 2324 2324 |
| 5790 | 5790 | 15db9 | 2324 2324 |
| 5791 | 5791 | 18a64 | 2324 2324 |
| 5792 | 5792 | 7c38f | 2324 2324 |
| 5793 | 5793 | bd3d9 | 2324 2324 |
| 5794 | 5794 | 27369 | 2324 2324 |
| 5795 | 5795 | 38705 | 2324 2324 |
| 5796 | 5796 | 1518e | 2324 2324 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)