This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 148 | 148 | 943de | 2827 2827 |
| 5702 | 5702 | 943de | 2847 2847 |
| 7303 | 7303 | 943de | 2798 2798 |
| 15624 | 15624 | 943de | 2829 2829 |
| 16126 | 16126 | 943de | 3329 3329 |
| 16401 | 16401 | 943de | 3338 3338 |
| 17773 | 17773 | 943de | 3340 3340 |
| 17950 | 17950 | 943de | 3342 3342 |
| 23319 | 23319 | 943de | 3331 3331 |
| 23536 | 23536 | 943de | 3319 3319 |
| 24517 | 24517 | 943de | 3318 3318 |
| 24726 | 24726 | 943de | 3352 3352 |
| 25922 | 25922 | 943de | 2835 2835 |
| 25962 | 25962 | 943de | 3362 3362 |
| 26184 | 26184 | 943de | 3326 3326 |
| 26980 | 26980 | 943de | 3327 3327 |
| 27376 | 27376 | 943de | 3339 3339 |
| 27505 | 27505 | 943de | 3341 3341 |
| 27676 | 27676 | 943de | 3347 3347 |
| 27812 | 27812 | 943de | 3322 3322 |
| 27878 | 27878 | 943de | 3320 3320 |
| 27952 | 27952 | 943de | 3361 3361 |
| 28048 | 28048 | 943de | 3321 3321 |
| 36324 | 36324 | 943de | 2799 2799 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)