This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 13170 | 13170 | ec3ac | 856 856 |
| 13171 | 13171 | b668a | 856 856 |
| 13172 | 13172 | aaf5a | 856 856 |
| 13173 | 13173 | 5e075 | 856 856 |
| 13174 | 13174 | 59d75 | 856 856 |
| 13175 | 13175 | e6200 | 856 856 |
| 13176 | 13176 | b1201 | 856 856 |
| 13177 | 13177 | b42a4 | 856 856 |
| 13178 | 13178 | d679e | 856 856 |
| 13179 | 13179 | 17bc7 | 856 856 |
| 13180 | 13180 | aa04d | 856 856 |
| 13181 | 13181 | 95f91 | 856 856 |
| 13182 | 13182 | 7ce59 | 856 856 |
| 13183 | 13183 | a524c | 856 856 |
| 13184 | 13184 | 234f1 | 856 856 |
| 13185 | 13185 | 100b7 | 856 856 |
| 13186 | 13186 | 1518e | 856 856 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)