This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 11596 | 11596 | ec3ac | 900 900 |
| 11597 | 11597 | 1c31d | 900 900 |
| 11598 | 11598 | 5e075 | 900 900 |
| 11599 | 11599 | 59d75 | 900 900 |
| 11600 | 11600 | e6200 | 900 900 |
| 11601 | 11601 | b1201 | 900 900 |
| 11602 | 11602 | b42a4 | 900 900 |
| 11603 | 11603 | d679e | 900 900 |
| 11604 | 11604 | 17bc7 | 900 900 |
| 11605 | 11605 | aa04d | 900 900 |
| 11606 | 11606 | 95f91 | 900 900 |
| 11607 | 11607 | 9faf6 | 900 900 |
| 11608 | 11608 | 26b5a | 900 900 |
| 11609 | 11609 | 13f83 | 900 900 |
| 11610 | 11610 | ecb59 | 900 900 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)