This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 26207 | 26207 | a26ae | 2944 2944 |
| 26208 | 26208 | c3503 | 2944 2944 |
| 26209 | 26209 | ec3ac | 2944 2944 |
| 26210 | 26210 | cb80d | 2944 2944 |
| 26211 | 26211 | 371f0 | 2944 2944 |
| 26212 | 26212 | 5e075 | 2944 2944 |
| 26213 | 26213 | 59d75 | 2944 2944 |
| 26214 | 26214 | e6200 | 2944 2944 |
| 26215 | 26215 | b1201 | 2944 2944 |
| 26216 | 26216 | 902e5 | 2944 2944 |
| 26217 | 26217 | 77d7e | 2944 2944 |
| 26218 | 26218 | af0a7 | 2944 2944 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)