This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 334 | 334 | ebcbb | 2379 2379 |
| 335 | 335 | 4801f | 2379 2379 |
| 336 | 336 | 5e075 | 2379 2379 |
| 337 | 337 | 59d75 | 2379 2379 |
| 338 | 338 | e6200 | 2379 2379 |
| 339 | 339 | b1201 | 2379 2379 |
| 340 | 340 | 8a7ee | 2379 2379 |
| 341 | 341 | 862ed | 2379 2379 |
| 342 | 342 | 18a64 | 2379 2379 |
| 343 | 343 | 9848a | 2379 2379 |
| 344 | 344 | abb72 | 2379 2379 |
| 345 | 345 | 93975 | 2379 2379 |
| 346 | 346 | 27369 | 2379 2379 |
| 347 | 347 | 7ee91 | 2379 2379 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)