This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 5899 | 5899 | ec3ac | 2946 2946 |
| 5900 | 5900 | 13800 | 2946 2946 |
| 5901 | 5901 | 5e075 | 2946 2946 |
| 5902 | 5902 | 59d75 | 2946 2946 |
| 5903 | 5903 | 4accc | 2946 2946 |
| 5904 | 5904 | 3502d | 2946 2946 |
| 5905 | 5905 | b1201 | 2946 2946 |
| 5906 | 5906 | 902e5 | 2946 2946 |
| 5907 | 5907 | 5d37b | 2946 2946 |
| 5908 | 5908 | 58753 | 2946 2946 |
| 5909 | 5909 | 46c5b | 2946 2946 |
| 5910 | 5910 | b4886 | 2946 2946 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)