This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 25049 | 25049 | cc5ed | 2931 2931 |
| 25050 | 25050 | c1190 | 2931 2931 |
| 25051 | 25051 | cb80d | 2931 2931 |
| 25052 | 25052 | 371f0 | 2931 2931 |
| 25053 | 25053 | bf1e7 | 2931 2931 |
| 25054 | 25054 | e6200 | 2931 2931 |
| 25055 | 25055 | b1201 | 2931 2931 |
| 25056 | 25056 | 902e5 | 2931 2931 |
| 25057 | 25057 | b918e | 2931 2931 |
| 25058 | 25058 | 42fde | 2931 2931 |
| 25059 | 25059 | dbf07 | 2931 2931 |
| 25060 | 25060 | 927de | 2931 2931 |
| 25061 | 25061 | 25d0f | 2931 2931 |
| 25062 | 25062 | 35c78 | 2931 2931 |
| 25063 | 25063 | af0a7 | 2931 2931 |
| 25064 | 25064 | 09b01 | 2931 2931 |
| 25065 | 25065 | 04182 | 2931 2931 |
| 25066 | 25066 | fd049 | 2931 2931 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)