This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 708 | 708 | ec3ac | 1095 1095 |
| 709 | 709 | 17183 | 1095 1095 |
| 710 | 710 | afc04 | 1095 1095 |
| 711 | 711 | 550f6 | 1095 1095 |
| 712 | 712 | e6034 | 1095 1095 |
| 713 | 713 | 313af | 1095 1095 |
| 714 | 714 | f9cc2 | 1095 1095 |
| 715 | 715 | aabe0 | 1095 1095 |
| 716 | 716 | 3e5f6 | 1095 1095 |
| 717 | 717 | 87fac | 1095 1095 |
| 718 | 718 | 1073c | 1095 1095 |
| 719 | 719 | c3b9b | 1095 1095 |
| 720 | 720 | 5e075 | 1095 1095 |
| 721 | 721 | 59d75 | 1095 1095 |
| 722 | 722 | e6200 | 1095 1095 |
| 723 | 723 | b1201 | 1095 1095 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)