This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 16381 | 16381 | a40b9 | 2942 2942 |
| 18243 | 18243 | a40b9 | 2963 2963 |
| 21348 | 21348 | a40b9 | 2898 2898 |
| 21371 | 21371 | a40b9 | 2951 2951 |
| 21632 | 21632 | a40b9 | 2938 2938 |
| 21922 | 21922 | a40b9 | 2950 2950 |
| 23624 | 23624 | a40b9 | 2911 2911 |
| 23677 | 23677 | a40b9 | 2917 2917 |
| 24021 | 24021 | a40b9 | 2912 2912 |
| 24188 | 24188 | a40b9 | 2899 2899 |
| 25007 | 25007 | a40b9 | 2937 2937 |
| 25307 | 25307 | a40b9 | 2936 2936 |
| 25582 | 25582 | a40b9 | 2918 2918 |
| 26094 | 26094 | a40b9 | 2957 2957 |
| 29583 | 29583 | a40b9 | 2966 2966 |
| 29686 | 29686 | a40b9 | 2967 2967 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)