This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 26695 | 26695 | ebcbb | 3366 3366 |
| 26696 | 26696 | 371f0 | 3366 3366 |
| 26697 | 26697 | 5e075 | 3366 3366 |
| 26698 | 26698 | 59d75 | 3366 3366 |
| 26699 | 26699 | e6200 | 3366 3366 |
| 26700 | 26700 | b1201 | 3366 3366 |
| 26701 | 26701 | 8a7ee | 3366 3366 |
| 26702 | 26702 | 862ed | 3366 3366 |
| 26703 | 26703 | ebf60 | 3366 3366 |
| 26704 | 26704 | 18a64 | 3366 3366 |
| 26705 | 26705 | d5ec6 | 3366 3366 |
| 26706 | 26706 | 66f82 | 3366 3366 |
| 26707 | 26707 | f788a | 3366 3366 |
| 26708 | 26708 | 7c38f | 3366 3366 |
| 26709 | 26709 | a2d21 | 3366 3366 |
| 26710 | 26710 | a1307 | 3366 3366 |
| 26711 | 26711 | 809af | 3366 3366 |
| 26712 | 26712 | abb72 | 3366 3366 |
| 26713 | 26713 | 93975 | 3366 3366 |
| 26714 | 26714 | 27369 | 3366 3366 |
| 26715 | 26715 | 37724 | 3366 3366 |
| 26716 | 26716 | e128e | 3366 3366 |
| 26717 | 26717 | 80def | 3366 3366 |
| 26718 | 26718 | 9c206 | 3366 3366 |
| 26719 | 26719 | 7c580 | 3366 3366 |
| 26720 | 26720 | 724f8 | 3366 3366 |
| 26721 | 26721 | b6f60 | 3366 3366 |
| 26722 | 26722 | 06d39 | 3366 3366 |
| 26723 | 26723 | 2ab82 | 3366 3366 |
| 26724 | 26724 | 8b0bf | 3366 3366 |
| 26725 | 26725 | 01e8a | 3366 3366 |
| 26726 | 26726 | 2aa57 | 3366 3366 |
| 26727 | 26727 | 425d7 | 3366 3366 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)