This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 9043 | 9043 | ec3ac | 1285 1285 |
| 9044 | 9044 | 2951c | 1285 1285 |
| 9045 | 9045 | 680d4 | 1285 1285 |
| 9046 | 9046 | a4952 | 1285 1285 |
| 9047 | 9047 | 46ae3 | 1285 1285 |
| 9048 | 9048 | 1d015 | 1285 1285 |
| 9049 | 9049 | 12e44 | 1285 1285 |
| 9050 | 9050 | 371f0 | 1285 1285 |
| 9051 | 9051 | 5e075 | 1285 1285 |
| 9052 | 9052 | 59d75 | 1285 1285 |
| 9053 | 9053 | e6200 | 1285 1285 |
| 9054 | 9054 | b1201 | 1285 1285 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)