This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 28122 | 28122 | cc5ed | 2688 2688 |
| 28123 | 28123 | 371f0 | 2688 2688 |
| 28124 | 28124 | e6200 | 2688 2688 |
| 28125 | 28125 | b1201 | 2688 2688 |
| 28126 | 28126 | d9d8c | 2688 2688 |
| 28127 | 28127 | 5f10e | 2688 2688 |
| 28128 | 28128 | 5849a | 2688 2688 |
| 28129 | 28129 | eab5e | 2688 2688 |
| 28130 | 28130 | 8b401 | 2688 2688 |
| 28131 | 28131 | 007df | 2688 2688 |
| 28132 | 28132 | 5dcb2 | 2688 2688 |
| 28133 | 28133 | d3539 | 2688 2688 |
| 28134 | 28134 | 60626 | 2688 2688 |
| 28135 | 28135 | 4a957 | 2688 2688 |
| 28136 | 28136 | 839f9 | 2688 2688 |
| 28137 | 28137 | ffca2 | 2688 2688 |
| 28138 | 28138 | 4f89e | 2688 2688 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)