This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 1463 | 1463 | ec3ac | 1070 1070 |
| 1464 | 1464 | 17183 | 1070 1070 |
| 1465 | 1465 | 96bbd | 1070 1070 |
| 1466 | 1466 | 550f6 | 1070 1070 |
| 1467 | 1467 | 343d8 | 1070 1070 |
| 1468 | 1468 | e0460 | 1070 1070 |
| 1469 | 1469 | 02db8 | 1070 1070 |
| 1470 | 1470 | aabe0 | 1070 1070 |
| 1471 | 1471 | 3e5f6 | 1070 1070 |
| 1472 | 1472 | 87fac | 1070 1070 |
| 1473 | 1473 | 1073c | 1070 1070 |
| 1474 | 1474 | 4801f | 1070 1070 |
| 1475 | 1475 | 5e075 | 1070 1070 |
| 1476 | 1476 | 59d75 | 1070 1070 |
| 1477 | 1477 | e6200 | 1070 1070 |
| 1478 | 1478 | b1201 | 1070 1070 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)