This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 6510 | 6510 | ec3ac | 2887 2887 |
| 6511 | 6511 | 371f0 | 2887 2887 |
| 6512 | 6512 | 5e075 | 2887 2887 |
| 6513 | 6513 | 59d75 | 2887 2887 |
| 6514 | 6514 | 4accc | 2887 2887 |
| 6515 | 6515 | 3502d | 2887 2887 |
| 6516 | 6516 | b1201 | 2887 2887 |
| 6517 | 6517 | 902e5 | 2887 2887 |
| 6518 | 6518 | 2ec04 | 2887 2887 |
| 6519 | 6519 | 5a6bd | 2887 2887 |
| 6520 | 6520 | ef9c4 | 2887 2887 |
| 6521 | 6521 | 041e4 | 2887 2887 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)