This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 27297 | 27297 | ec3ac | 2770 2770 |
| 27298 | 27298 | 3909d | 2770 2770 |
| 27299 | 27299 | 371f0 | 2770 2770 |
| 27300 | 27300 | 5e075 | 2770 2770 |
| 27301 | 27301 | 59d75 | 2770 2770 |
| 27302 | 27302 | e6200 | 2770 2770 |
| 27303 | 27303 | b1201 | 2770 2770 |
| 27304 | 27304 | 902e5 | 2770 2770 |
| 27305 | 27305 | e80cf | 2770 2770 |
| 27306 | 27306 | 3e75a | 2770 2770 |
| 27307 | 27307 | e086a | 2770 2770 |
| 27308 | 27308 | c48f9 | 2770 2770 |
| 27309 | 27309 | 90531 | 2770 2770 |
| 27310 | 27310 | d5d34 | 2770 2770 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)