This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 10764 | 10764 | ec3ac | 807 807 |
| 10765 | 10765 | b668a | 807 807 |
| 10766 | 10766 | a14cf | 807 807 |
| 10767 | 10767 | 5e075 | 807 807 |
| 10768 | 10768 | 59d75 | 807 807 |
| 10769 | 10769 | e6200 | 807 807 |
| 10770 | 10770 | b1201 | 807 807 |
| 10771 | 10771 | e128e | 807 807 |
| 10772 | 10772 | 598d9 | 807 807 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)