This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 19070 | 19070 | cc5ed | 2821 2821 |
| 19071 | 19071 | 371f0 | 2821 2821 |
| 19072 | 19072 | 5e075 | 2821 2821 |
| 19073 | 19073 | 59d75 | 2821 2821 |
| 19074 | 19074 | 4accc | 2821 2821 |
| 19075 | 19075 | 60170 | 2821 2821 |
| 19076 | 19076 | b1201 | 2821 2821 |
| 19077 | 19077 | 7a9b5 | 2821 2821 |
| 19078 | 19078 | 8a7ee | 2821 2821 |
| 19079 | 19079 | 862ed | 2821 2821 |
| 19080 | 19080 | ebf60 | 2821 2821 |
| 19081 | 19081 | bbdfd | 2821 2821 |
| 19082 | 19082 | 6f328 | 2821 2821 |
| 19083 | 19083 | a2d21 | 2821 2821 |
| 19084 | 19084 | a1307 | 2821 2821 |
| 19085 | 19085 | abb72 | 2821 2821 |
| 19086 | 19086 | c4c8c | 2821 2821 |
| 19087 | 19087 | 27369 | 2821 2821 |
| 19088 | 19088 | 42bf9 | 2821 2821 |
| 19089 | 19089 | f6c6f | 2821 2821 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)