This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 29952 | 29952 | cc5ed | 2644 2644 |
| 29953 | 29953 | ef21b | 2644 2644 |
| 29954 | 29954 | dcc45 | 2644 2644 |
| 29955 | 29955 | ffb7e | 2644 2644 |
| 29956 | 29956 | 2d239 | 2644 2644 |
| 29957 | 29957 | 83f98 | 2644 2644 |
| 29958 | 29958 | 29a48 | 2644 2644 |
| 29959 | 29959 | 2ed33 | 2644 2644 |
| 29960 | 29960 | 4801f | 2644 2644 |
| 29961 | 29961 | d2747 | 2644 2644 |
| 29962 | 29962 | 5e075 | 2644 2644 |
| 29963 | 29963 | 59d75 | 2644 2644 |
| 29964 | 29964 | f9d07 | 2644 2644 |
| 29965 | 29965 | e6200 | 2644 2644 |
| 29966 | 29966 | b1201 | 2644 2644 |
| 29967 | 29967 | 902e5 | 2644 2644 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)