This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 2196 | 2196 | cc5ed | 2995 2995 |
| 2197 | 2197 | 40c27 | 2995 2995 |
| 2198 | 2198 | f4921 | 2995 2995 |
| 2199 | 2199 | 550f6 | 2995 2995 |
| 2200 | 2200 | c0f52 | 2995 2995 |
| 2201 | 2201 | aabe0 | 2995 2995 |
| 2202 | 2202 | a06cb | 2995 2995 |
| 2203 | 2203 | 87fac | 2995 2995 |
| 2204 | 2204 | cbcce | 2995 2995 |
| 2205 | 2205 | 7ceb1 | 2995 2995 |
| 2206 | 2206 | 7b150 | 2995 2995 |
| 2207 | 2207 | e6200 | 2995 2995 |
| 2208 | 2208 | b1201 | 2995 2995 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)