This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 34327 | 34327 | ec3ac | 797 797 |
| 34328 | 34328 | b668a | 797 797 |
| 34329 | 34329 | a14cf | 797 797 |
| 34330 | 34330 | 5e075 | 797 797 |
| 34331 | 34331 | 59d75 | 797 797 |
| 34332 | 34332 | e6200 | 797 797 |
| 34333 | 34333 | b1201 | 797 797 |
| 34334 | 34334 | b42a4 | 797 797 |
| 34335 | 34335 | d679e | 797 797 |
| 34336 | 34336 | 17bc7 | 797 797 |
| 34337 | 34337 | aa04d | 797 797 |
| 34338 | 34338 | 95f91 | 797 797 |
| 34339 | 34339 | 65a38 | 797 797 |
| 34340 | 34340 | e128e | 797 797 |
| 34341 | 34341 | d75c0 | 797 797 |
| 34342 | 34342 | 16071 | 797 797 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)