This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 21037 | 21037 | ebcbb | 3355 3355 |
| 21038 | 21038 | 7b150 | 3355 3355 |
| 21039 | 21039 | 5e075 | 3355 3355 |
| 21040 | 21040 | 59d75 | 3355 3355 |
| 21041 | 21041 | e6200 | 3355 3355 |
| 21042 | 21042 | b1201 | 3355 3355 |
| 21043 | 21043 | 8a7ee | 3355 3355 |
| 21044 | 21044 | 862ed | 3355 3355 |
| 21045 | 21045 | ebf60 | 3355 3355 |
| 21046 | 21046 | 18a64 | 3355 3355 |
| 21047 | 21047 | d5ec6 | 3355 3355 |
| 21048 | 21048 | 66f82 | 3355 3355 |
| 21049 | 21049 | f788a | 3355 3355 |
| 21050 | 21050 | 7c38f | 3355 3355 |
| 21051 | 21051 | a2d21 | 3355 3355 |
| 21052 | 21052 | a1307 | 3355 3355 |
| 21053 | 21053 | 809af | 3355 3355 |
| 21054 | 21054 | abb72 | 3355 3355 |
| 21055 | 21055 | 93975 | 3355 3355 |
| 21056 | 21056 | 27369 | 3355 3355 |
| 21057 | 21057 | 37724 | 3355 3355 |
| 21058 | 21058 | e128e | 3355 3355 |
| 21059 | 21059 | 80def | 3355 3355 |
| 21060 | 21060 | 9c206 | 3355 3355 |
| 21061 | 21061 | 7c580 | 3355 3355 |
| 21062 | 21062 | 724f8 | 3355 3355 |
| 21063 | 21063 | b6f60 | 3355 3355 |
| 21064 | 21064 | 6d811 | 3355 3355 |
| 21065 | 21065 | 39ce1 | 3355 3355 |
| 21066 | 21066 | 8b0bf | 3355 3355 |
| 21067 | 21067 | 01e8a | 3355 3355 |
| 21068 | 21068 | 2aa57 | 3355 3355 |
| 21069 | 21069 | 425d7 | 3355 3355 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)