This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 6406 | 6406 | bffb8 | 1671 1671 |
| 6407 | 6407 | 49b74 | 1671 1671 |
| 6408 | 6408 | 169d2 | 1671 1671 |
| 6409 | 6409 | 70544 | 1671 1671 |
| 6410 | 6410 | 2a4ca | 1671 1671 |
| 6411 | 6411 | 57006 | 1671 1671 |
| 6412 | 6412 | 9eadd | 1671 1671 |
| 6413 | 6413 | 18d8d | 1671 1671 |
| 6414 | 6414 | 4de4f | 1671 1671 |
| 6415 | 6415 | a14cf | 1671 1671 |
| 6416 | 6416 | 5e075 | 1671 1671 |
| 6417 | 6417 | 59d75 | 1671 1671 |
| 6418 | 6418 | e6200 | 1671 1671 |
| 6419 | 6419 | b1201 | 1671 1671 |
| 6420 | 6420 | 902e5 | 1671 1671 |
| 6421 | 6421 | 03f36 | 1671 1671 |
| 6422 | 6422 | cf7f4 | 1671 1671 |
| 6423 | 6423 | a9066 | 1671 1671 |
| 6424 | 6424 | d976f | 1671 1671 |
| 6425 | 6425 | d7035 | 1671 1671 |
| 6426 | 6426 | e31e2 | 1671 1671 |
| 6427 | 6427 | a4c1d | 1671 1671 |
| 6428 | 6428 | 46194 | 1671 1671 |
| 6429 | 6429 | d8324 | 1671 1671 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)