This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 7659 | 7659 | cc5ed | 2965 2965 |
| 7660 | 7660 | cb80d | 2965 2965 |
| 7661 | 7661 | 371f0 | 2965 2965 |
| 7662 | 7662 | 5e075 | 2965 2965 |
| 7663 | 7663 | 59d75 | 2965 2965 |
| 7664 | 7664 | e6200 | 2965 2965 |
| 7665 | 7665 | b1201 | 2965 2965 |
| 7666 | 7666 | 902e5 | 2965 2965 |
| 7667 | 7667 | bc1ac | 2965 2965 |
| 7668 | 7668 | b918e | 2965 2965 |
| 7669 | 7669 | 5b456 | 2965 2965 |
| 7670 | 7670 | 72d8e | 2965 2965 |
| 7671 | 7671 | 77d7e | 2965 2965 |
| 7672 | 7672 | c46d7 | 2965 2965 |
| 7673 | 7673 | e5437 | 2965 2965 |
| 7674 | 7674 | 1fd76 | 2965 2965 |
| 7675 | 7675 | 469ba | 2965 2965 |
| 7676 | 7676 | 68170 | 2965 2965 |
| 7677 | 7677 | d1445 | 2965 2965 |
| 7678 | 7678 | 927de | 2965 2965 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)