This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 30215 | 30215 | cc5ed | 2881 2881 |
| 30216 | 30216 | 3da9b | 2881 2881 |
| 30217 | 30217 | 371f0 | 2881 2881 |
| 30218 | 30218 | 5e075 | 2881 2881 |
| 30219 | 30219 | 59d75 | 2881 2881 |
| 30220 | 30220 | e6200 | 2881 2881 |
| 30221 | 30221 | b1201 | 2881 2881 |
| 30222 | 30222 | 8a7ee | 2881 2881 |
| 30223 | 30223 | 862ed | 2881 2881 |
| 30224 | 30224 | f788a | 2881 2881 |
| 30225 | 30225 | 9848a | 2881 2881 |
| 30226 | 30226 | abb72 | 2881 2881 |
| 30227 | 30227 | 27369 | 2881 2881 |
| 30228 | 30228 | e128e | 2881 2881 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)