This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 23434 | 23434 | f678f | 3325 3325 |
| 23435 | 23435 | 371f0 | 3325 3325 |
| 23436 | 23436 | 5e075 | 3325 3325 |
| 23437 | 23437 | 59d75 | 3325 3325 |
| 23438 | 23438 | e6200 | 3325 3325 |
| 23439 | 23439 | b1201 | 3325 3325 |
| 23440 | 23440 | a50f7 | 3325 3325 |
| 23441 | 23441 | d5ec6 | 3325 3325 |
| 23442 | 23442 | d3559 | 3325 3325 |
| 23443 | 23443 | 649a5 | 3325 3325 |
| 23444 | 23444 | 8a7eb | 3325 3325 |
| 23445 | 23445 | 18a11 | 3325 3325 |
| 23446 | 23446 | 03778 | 3325 3325 |
| 23447 | 23447 | a1f8b | 3325 3325 |
| 23448 | 23448 | 37724 | 3325 3325 |
| 23449 | 23449 | 32bde | 3325 3325 |
| 23450 | 23450 | 06ae5 | 3325 3325 |
| 23451 | 23451 | 710d1 | 3325 3325 |
| 23452 | 23452 | b15dd | 3325 3325 |
| 23453 | 23453 | 8d650 | 3325 3325 |
| 23454 | 23454 | fa448 | 3325 3325 |
| 23455 | 23455 | e1dcf | 3325 3325 |
| 23456 | 23456 | f58f7 | 3325 3325 |
| 23457 | 23457 | 55c1c | 3325 3325 |
| 23458 | 23458 | e737a | 3325 3325 |
| 23459 | 23459 | e7176 | 3325 3325 |
| 23460 | 23460 | c45c4 | 3325 3325 |
| 23461 | 23461 | 2ed38 | 3325 3325 |
| 23462 | 23462 | 60bee | 3325 3325 |
| 23463 | 23463 | 962c9 | 3325 3325 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)