This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 5787 | 5787 | ad8b2 | 2324 2324 |
| 6977 | 6977 | ad8b2 | 2263 2263 |
| 7283 | 7283 | ad8b2 | 2305 2305 |
| 7363 | 7363 | ad8b2 | 2403 2403 |
| 7908 | 7908 | ad8b2 | 2283 2283 |
| 20969 | 20969 | ad8b2 | 1261 1261 |
| 30454 | 30454 | ad8b2 | 2227 2227 |
| 30472 | 30472 | ad8b2 | 2209 2209 |
| 30503 | 30503 | ad8b2 | 2383 2383 |
| 30534 | 30534 | ad8b2 | 2249 2249 |
| 30547 | 30547 | ad8b2 | 2236 2236 |
| 30760 | 30760 | ad8b2 | 2217 2217 |
| 30798 | 30798 | ad8b2 | 2308 2308 |
| 30854 | 30854 | ad8b2 | 2405 2405 |
| 30865 | 30865 | ad8b2 | 2350 2350 |
| 30878 | 30878 | ad8b2 | 2294 2294 |
| 30949 | 30949 | ad8b2 | 2200 2200 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)