This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 2 | 2 | 13c3e | 3186 3186 |
| 513 | 513 | 13c3e | 3188 3188 |
| 837 | 837 | 13c3e | 3179 3179 |
| 871 | 871 | 13c3e | 3187 3187 |
| 1028 | 1028 | 13c3e | 3189 3189 |
| 1244 | 1244 | 13c3e | 3191 3191 |
| 1644 | 1644 | 13c3e | 3190 3190 |
| 16268 | 16268 | 13c3e | 3278 3278 |
| 28309 | 28309 | 13c3e | 3182 3182 |
| 28438 | 28438 | 13c3e | 3181 3181 |
| 28580 | 28580 | 13c3e | 3273 3273 |
| 28698 | 28698 | 13c3e | 3274 3274 |
| 28790 | 28790 | 13c3e | 3183 3183 |
| 28838 | 28838 | 13c3e | 3180 3180 |
| 28853 | 28853 | 13c3e | 3184 3184 |
| 28924 | 28924 | 13c3e | 3272 3272 |
| 29239 | 29239 | 13c3e | 3185 3185 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)