This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 7678 | 7678 | 927de | 2965 2965 |
| 21374 | 21374 | 927de | 2951 2951 |
| 21428 | 21428 | 927de | 2906 2906 |
| 21525 | 21525 | 927de | 2903 2903 |
| 21634 | 21634 | 927de | 2938 2938 |
| 21702 | 21702 | 927de | 2900 2900 |
| 21775 | 21775 | 927de | 2905 2905 |
| 22280 | 22280 | 927de | 2902 2902 |
| 23044 | 23044 | 927de | 2901 2901 |
| 23392 | 23392 | 927de | 2926 2926 |
| 23476 | 23476 | 927de | 2928 2928 |
| 24342 | 24342 | 927de | 2925 2925 |
| 24394 | 24394 | 927de | 2927 2927 |
| 24657 | 24657 | 927de | 2929 2929 |
| 25060 | 25060 | 927de | 2931 2931 |
| 25406 | 25406 | 927de | 2930 2930 |
| 25584 | 25584 | 927de | 2918 2918 |
| 25678 | 25678 | 927de | 2904 2904 |
| 36218 | 36218 | 927de | 2969 2969 |
| 36369 | 36369 | 927de | 2968 2968 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)