This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 6725 | 6725 | a26ae | 1611 1611 |
| 7837 | 7837 | a26ae | 1654 1654 |
| 16612 | 16612 | a26ae | 2970 2970 |
| 17067 | 17067 | a26ae | 2961 2961 |
| 17198 | 17198 | a26ae | 2962 2962 |
| 17268 | 17268 | a26ae | 2960 2960 |
| 26041 | 26041 | a26ae | 2943 2943 |
| 26207 | 26207 | a26ae | 2944 2944 |
| 31679 | 31679 | a26ae | 51 51 |
| 32033 | 32033 | a26ae | 1567 1567 |
| 32194 | 32194 | a26ae | 445 445 |
| 32280 | 32280 | a26ae | 50 50 |
| 32484 | 32484 | a26ae | 98 98 |
| 32685 | 32685 | a26ae | 63 63 |
| 32694 | 32694 | a26ae | 99 99 |
| 32778 | 32778 | a26ae | 109 109 |
| 33294 | 33294 | a26ae | 304 304 |
| 34515 | 34515 | a26ae | 292 292 |
| 34527 | 34527 | a26ae | 296 296 |
| 34702 | 34702 | a26ae | 88 88 |
| 34729 | 34729 | a26ae | 300 300 |
| 34758 | 34758 | a26ae | 294 294 |
| 34879 | 34879 | a26ae | 89 89 |
| 35016 | 35016 | a26ae | 1569 1569 |
| 35095 | 35095 | a26ae | 293 293 |
| 35100 | 35100 | a26ae | 297 297 |
| 35135 | 35135 | a26ae | 301 301 |
| 35145 | 35145 | a26ae | 295 295 |
| 35220 | 35220 | a26ae | 291 291 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)