This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 11345 | 11345 | 57006 | 1678 1678 |
| 11346 | 11346 | 1e305 | 1678 1678 |
| 11347 | 11347 | 43d08 | 1678 1678 |
| 11348 | 11348 | 994de | 1678 1678 |
| 11349 | 11349 | ef97a | 1678 1678 |
| 11350 | 11350 | a14cf | 1678 1678 |
| 11351 | 11351 | 5e075 | 1678 1678 |
| 11352 | 11352 | a4abf | 1678 1678 |
| 11353 | 11353 | 59d75 | 1678 1678 |
| 11354 | 11354 | e6200 | 1678 1678 |
| 11355 | 11355 | b1201 | 1678 1678 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)