This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 27411 | 27411 | ebcbb | 3314 3314 |
| 27412 | 27412 | 371f0 | 3314 3314 |
| 27413 | 27413 | 5e075 | 3314 3314 |
| 27414 | 27414 | 59d75 | 3314 3314 |
| 27415 | 27415 | e6200 | 3314 3314 |
| 27416 | 27416 | b1201 | 3314 3314 |
| 27417 | 27417 | 8a7ee | 3314 3314 |
| 27418 | 27418 | 862ed | 3314 3314 |
| 27419 | 27419 | ebf60 | 3314 3314 |
| 27420 | 27420 | 18a64 | 3314 3314 |
| 27421 | 27421 | d5ec6 | 3314 3314 |
| 27422 | 27422 | 66f82 | 3314 3314 |
| 27423 | 27423 | f788a | 3314 3314 |
| 27424 | 27424 | 7c38f | 3314 3314 |
| 27425 | 27425 | a2d21 | 3314 3314 |
| 27426 | 27426 | a1307 | 3314 3314 |
| 27427 | 27427 | 809af | 3314 3314 |
| 27428 | 27428 | abb72 | 3314 3314 |
| 27429 | 27429 | 93975 | 3314 3314 |
| 27430 | 27430 | 27369 | 3314 3314 |
| 27431 | 27431 | 37724 | 3314 3314 |
| 27432 | 27432 | e128e | 3314 3314 |
| 27433 | 27433 | 80def | 3314 3314 |
| 27434 | 27434 | 9c206 | 3314 3314 |
| 27435 | 27435 | 7c580 | 3314 3314 |
| 27436 | 27436 | 724f8 | 3314 3314 |
| 27437 | 27437 | b6f60 | 3314 3314 |
| 27438 | 27438 | 06d39 | 3314 3314 |
| 27439 | 27439 | 2ab82 | 3314 3314 |
| 27440 | 27440 | 8b0bf | 3314 3314 |
| 27441 | 27441 | 01e8a | 3314 3314 |
| 27442 | 27442 | 2aa57 | 3314 3314 |
| 27443 | 27443 | 425d7 | 3314 3314 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)