This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 23518 | 23518 | f678f | 3319 3319 |
| 23519 | 23519 | 7b150 | 3319 3319 |
| 23520 | 23520 | 5e075 | 3319 3319 |
| 23521 | 23521 | 59d75 | 3319 3319 |
| 23522 | 23522 | e6200 | 3319 3319 |
| 23523 | 23523 | b1201 | 3319 3319 |
| 23524 | 23524 | a50f7 | 3319 3319 |
| 23525 | 23525 | d5ec6 | 3319 3319 |
| 23526 | 23526 | d3559 | 3319 3319 |
| 23527 | 23527 | 649a5 | 3319 3319 |
| 23528 | 23528 | 8a7eb | 3319 3319 |
| 23529 | 23529 | 18a11 | 3319 3319 |
| 23530 | 23530 | 03778 | 3319 3319 |
| 23531 | 23531 | a1f8b | 3319 3319 |
| 23532 | 23532 | 37724 | 3319 3319 |
| 23533 | 23533 | 32bde | 3319 3319 |
| 23534 | 23534 | 06ae5 | 3319 3319 |
| 23535 | 23535 | 710d1 | 3319 3319 |
| 23536 | 23536 | 943de | 3319 3319 |
| 23537 | 23537 | 8d650 | 3319 3319 |
| 23538 | 23538 | fa448 | 3319 3319 |
| 23539 | 23539 | e1dcf | 3319 3319 |
| 23540 | 23540 | f58f7 | 3319 3319 |
| 23541 | 23541 | 6e6b8 | 3319 3319 |
| 23542 | 23542 | 5a70c | 3319 3319 |
| 23543 | 23543 | e7176 | 3319 3319 |
| 23544 | 23544 | c45c4 | 3319 3319 |
| 23545 | 23545 | 2ed38 | 3319 3319 |
| 23546 | 23546 | 60bee | 3319 3319 |
| 23547 | 23547 | 962c9 | 3319 3319 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)