This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 27077 | 27077 | ebcbb | 3364 3364 |
| 27078 | 27078 | 371f0 | 3364 3364 |
| 27079 | 27079 | 5e075 | 3364 3364 |
| 27080 | 27080 | 59d75 | 3364 3364 |
| 27081 | 27081 | e6200 | 3364 3364 |
| 27082 | 27082 | b1201 | 3364 3364 |
| 27083 | 27083 | 8a7ee | 3364 3364 |
| 27084 | 27084 | 862ed | 3364 3364 |
| 27085 | 27085 | ebf60 | 3364 3364 |
| 27086 | 27086 | 18a64 | 3364 3364 |
| 27087 | 27087 | d5ec6 | 3364 3364 |
| 27088 | 27088 | 66f82 | 3364 3364 |
| 27089 | 27089 | f788a | 3364 3364 |
| 27090 | 27090 | 7c38f | 3364 3364 |
| 27091 | 27091 | a2d21 | 3364 3364 |
| 27092 | 27092 | a1307 | 3364 3364 |
| 27093 | 27093 | 809af | 3364 3364 |
| 27094 | 27094 | abb72 | 3364 3364 |
| 27095 | 27095 | 93975 | 3364 3364 |
| 27096 | 27096 | 27369 | 3364 3364 |
| 27097 | 27097 | 37724 | 3364 3364 |
| 27098 | 27098 | e128e | 3364 3364 |
| 27099 | 27099 | 80def | 3364 3364 |
| 27100 | 27100 | 9c206 | 3364 3364 |
| 27101 | 27101 | 7c580 | 3364 3364 |
| 27102 | 27102 | 724f8 | 3364 3364 |
| 27103 | 27103 | b6f60 | 3364 3364 |
| 27104 | 27104 | 06d39 | 3364 3364 |
| 27105 | 27105 | 2ab82 | 3364 3364 |
| 27106 | 27106 | 8b0bf | 3364 3364 |
| 27107 | 27107 | 01e8a | 3364 3364 |
| 27108 | 27108 | 2aa57 | 3364 3364 |
| 27109 | 27109 | 425d7 | 3364 3364 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)