This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 17704 | 17704 | ec3ac | 1144 1144 |
| 17705 | 17705 | 4801f | 1144 1144 |
| 17706 | 17706 | 5e075 | 1144 1144 |
| 17707 | 17707 | 59d75 | 1144 1144 |
| 17708 | 17708 | e6200 | 1144 1144 |
| 17709 | 17709 | b1201 | 1144 1144 |
| 17710 | 17710 | ebf60 | 1144 1144 |
| 17711 | 17711 | a1307 | 1144 1144 |
| 17712 | 17712 | abb72 | 1144 1144 |
| 17713 | 17713 | e128e | 1144 1144 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)