This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 9460 | 9460 | 28463 | 1151 1151 |
| 9461 | 9461 | 24da8 | 1151 1151 |
| 9462 | 9462 | d5b86 | 1151 1151 |
| 9463 | 9463 | 36203 | 1151 1151 |
| 9464 | 9464 | 17a50 | 1151 1151 |
| 9465 | 9465 | 40ff5 | 1151 1151 |
| 9466 | 9466 | e95f6 | 1151 1151 |
| 9467 | 9467 | 371f0 | 1151 1151 |
| 9468 | 9468 | 5e075 | 1151 1151 |
| 9469 | 9469 | 59d75 | 1151 1151 |
| 9470 | 9470 | e6200 | 1151 1151 |
| 9471 | 9471 | b1201 | 1151 1151 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)