This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 28349 | 28349 | ec3ac | 3009 3009 |
| 28350 | 28350 | 6060b | 3009 3009 |
| 28351 | 28351 | 371f0 | 3009 3009 |
| 28352 | 28352 | 59d75 | 3009 3009 |
| 28353 | 28353 | e6200 | 3009 3009 |
| 28354 | 28354 | b1201 | 3009 3009 |
| 28355 | 28355 | 902e5 | 3009 3009 |
| 28356 | 28356 | 8a7ee | 3009 3009 |
| 28357 | 28357 | 862ed | 3009 3009 |
| 28358 | 28358 | 225c8 | 3009 3009 |
| 28359 | 28359 | 8d2e9 | 3009 3009 |
| 28360 | 28360 | e4b8e | 3009 3009 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)