This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 36075 | 36075 | 189ac | 2364 2364 |
| 36076 | 36076 | 371f0 | 2364 2364 |
| 36077 | 36077 | e6200 | 2364 2364 |
| 36078 | 36078 | b1201 | 2364 2364 |
| 36079 | 36079 | 8a7ee | 2364 2364 |
| 36080 | 36080 | 862ed | 2364 2364 |
| 36081 | 36081 | a1307 | 2364 2364 |
| 36082 | 36082 | abb72 | 2364 2364 |
| 36083 | 36083 | 27369 | 2364 2364 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)