This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 7318 | 7318 | bffb8 | 1618 1618 |
| 7319 | 7319 | 49b74 | 1618 1618 |
| 7320 | 7320 | 169d2 | 1618 1618 |
| 7321 | 7321 | 70544 | 1618 1618 |
| 7322 | 7322 | 2a4ca | 1618 1618 |
| 7323 | 7323 | 57006 | 1618 1618 |
| 7324 | 7324 | 9eadd | 1618 1618 |
| 7325 | 7325 | 18d8d | 1618 1618 |
| 7326 | 7326 | 4de4f | 1618 1618 |
| 7327 | 7327 | a14cf | 1618 1618 |
| 7328 | 7328 | 5e075 | 1618 1618 |
| 7329 | 7329 | 59d75 | 1618 1618 |
| 7330 | 7330 | b1201 | 1618 1618 |
| 7331 | 7331 | 03f36 | 1618 1618 |
| 7332 | 7332 | cf7f4 | 1618 1618 |
| 7333 | 7333 | a9066 | 1618 1618 |
| 7334 | 7334 | d976f | 1618 1618 |
| 7335 | 7335 | d7035 | 1618 1618 |
| 7336 | 7336 | e31e2 | 1618 1618 |
| 7337 | 7337 | a4c1d | 1618 1618 |
| 7338 | 7338 | 46194 | 1618 1618 |
| 7339 | 7339 | d8324 | 1618 1618 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)