This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 25312 | 25312 | cc5ed | 2851 2851 |
| 25313 | 25313 | 3da9b | 2851 2851 |
| 25314 | 25314 | 7b150 | 2851 2851 |
| 25315 | 25315 | 5e075 | 2851 2851 |
| 25316 | 25316 | 59d75 | 2851 2851 |
| 25317 | 25317 | e6200 | 2851 2851 |
| 25318 | 25318 | b1201 | 2851 2851 |
| 25319 | 25319 | 8a7ee | 2851 2851 |
| 25320 | 25320 | 862ed | 2851 2851 |
| 25321 | 25321 | f788a | 2851 2851 |
| 25322 | 25322 | d2749 | 2851 2851 |
| 25323 | 25323 | a1307 | 2851 2851 |
| 25324 | 25324 | 8d2e9 | 2851 2851 |
| 25325 | 25325 | 27369 | 2851 2851 |
| 25326 | 25326 | e128e | 2851 2851 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)