This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 6220 | 6220 | bffb8 | 1633 1633 |
| 6221 | 6221 | 49b74 | 1633 1633 |
| 6222 | 6222 | 169d2 | 1633 1633 |
| 6223 | 6223 | 70544 | 1633 1633 |
| 6224 | 6224 | 2a4ca | 1633 1633 |
| 6225 | 6225 | 57006 | 1633 1633 |
| 6226 | 6226 | 9eadd | 1633 1633 |
| 6227 | 6227 | 18d8d | 1633 1633 |
| 6228 | 6228 | 4de4f | 1633 1633 |
| 6229 | 6229 | a14cf | 1633 1633 |
| 6230 | 6230 | 5e075 | 1633 1633 |
| 6231 | 6231 | 59d75 | 1633 1633 |
| 6232 | 6232 | b1201 | 1633 1633 |
| 6233 | 6233 | 03f36 | 1633 1633 |
| 6234 | 6234 | cf7f4 | 1633 1633 |
| 6235 | 6235 | a9066 | 1633 1633 |
| 6236 | 6236 | d976f | 1633 1633 |
| 6237 | 6237 | d7035 | 1633 1633 |
| 6238 | 6238 | e31e2 | 1633 1633 |
| 6239 | 6239 | a4c1d | 1633 1633 |
| 6240 | 6240 | 46194 | 1633 1633 |
| 6241 | 6241 | d8324 | 1633 1633 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)