This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 5831 | 5831 | c6b59 | 2231 2231 |
| 5832 | 5832 | 4801f | 2231 2231 |
| 5833 | 5833 | 5e075 | 2231 2231 |
| 5834 | 5834 | 59d75 | 2231 2231 |
| 5835 | 5835 | e6200 | 2231 2231 |
| 5836 | 5836 | b1201 | 2231 2231 |
| 5837 | 5837 | 18a64 | 2231 2231 |
| 5838 | 5838 | 9295b | 2231 2231 |
| 5839 | 5839 | 31177 | 2231 2231 |
| 5840 | 5840 | 7c38f | 2231 2231 |
| 5841 | 5841 | 7ee91 | 2231 2231 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)