This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 26041 | 26041 | a26ae | 2943 2943 |
| 26042 | 26042 | c3503 | 2943 2943 |
| 26043 | 26043 | ec3ac | 2943 2943 |
| 26044 | 26044 | cb80d | 2943 2943 |
| 26045 | 26045 | 371f0 | 2943 2943 |
| 26046 | 26046 | 5e075 | 2943 2943 |
| 26047 | 26047 | 59d75 | 2943 2943 |
| 26048 | 26048 | e6200 | 2943 2943 |
| 26049 | 26049 | b1201 | 2943 2943 |
| 26050 | 26050 | 902e5 | 2943 2943 |
| 26051 | 26051 | 77d7e | 2943 2943 |
| 26052 | 26052 | af0a7 | 2943 2943 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)