This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 10716 | 10716 | 6e2b2 | 1453 1453 |
| 10717 | 10717 | b60e9 | 1453 1453 |
| 10718 | 10718 | cc756 | 1453 1453 |
| 10719 | 10719 | 5e075 | 1453 1453 |
| 10720 | 10720 | 59d75 | 1453 1453 |
| 10721 | 10721 | e6200 | 1453 1453 |
| 10722 | 10722 | b1201 | 1453 1453 |
| 10723 | 10723 | 8b9b7 | 1453 1453 |
| 10724 | 10724 | 4dc48 | 1453 1453 |
| 10725 | 10725 | 8d4bc | 1453 1453 |
| 10726 | 10726 | 53703 | 1453 1453 |
| 10727 | 10727 | ec55d | 1453 1453 |
| 10728 | 10728 | d379e | 1453 1453 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)