This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 27018 | 27018 | ebcbb | 3337 3337 |
| 27019 | 27019 | 371f0 | 3337 3337 |
| 27020 | 27020 | 5e075 | 3337 3337 |
| 27021 | 27021 | 59d75 | 3337 3337 |
| 27022 | 27022 | e6200 | 3337 3337 |
| 27023 | 27023 | b1201 | 3337 3337 |
| 27024 | 27024 | 8a7ee | 3337 3337 |
| 27025 | 27025 | 862ed | 3337 3337 |
| 27026 | 27026 | ebf60 | 3337 3337 |
| 27027 | 27027 | 18a64 | 3337 3337 |
| 27028 | 27028 | d5ec6 | 3337 3337 |
| 27029 | 27029 | 66f82 | 3337 3337 |
| 27030 | 27030 | f788a | 3337 3337 |
| 27031 | 27031 | 7c38f | 3337 3337 |
| 27032 | 27032 | a2d21 | 3337 3337 |
| 27033 | 27033 | a1307 | 3337 3337 |
| 27034 | 27034 | 809af | 3337 3337 |
| 27035 | 27035 | abb72 | 3337 3337 |
| 27036 | 27036 | 93975 | 3337 3337 |
| 27037 | 27037 | 27369 | 3337 3337 |
| 27038 | 27038 | 37724 | 3337 3337 |
| 27039 | 27039 | e128e | 3337 3337 |
| 27040 | 27040 | 80def | 3337 3337 |
| 27041 | 27041 | 9c206 | 3337 3337 |
| 27042 | 27042 | 7c580 | 3337 3337 |
| 27043 | 27043 | 724f8 | 3337 3337 |
| 27044 | 27044 | b6f60 | 3337 3337 |
| 27045 | 27045 | 06d39 | 3337 3337 |
| 27046 | 27046 | 2ab82 | 3337 3337 |
| 27047 | 27047 | 8b0bf | 3337 3337 |
| 27048 | 27048 | 01e8a | 3337 3337 |
| 27049 | 27049 | 2aa57 | 3337 3337 |
| 27050 | 27050 | 425d7 | 3337 3337 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)