This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 9346 | 9346 | ec3ac | 1405 1405 |
| 9347 | 9347 | 2951c | 1405 1405 |
| 9348 | 9348 | 680d4 | 1405 1405 |
| 9349 | 9349 | a4952 | 1405 1405 |
| 9350 | 9350 | 46ae3 | 1405 1405 |
| 9351 | 9351 | 1d015 | 1405 1405 |
| 9352 | 9352 | 12e44 | 1405 1405 |
| 9353 | 9353 | 371f0 | 1405 1405 |
| 9354 | 9354 | 5e075 | 1405 1405 |
| 9355 | 9355 | 59d75 | 1405 1405 |
| 9356 | 9356 | e6200 | 1405 1405 |
| 9357 | 9357 | b1201 | 1405 1405 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)