This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 21759 | 21759 | cc5ed | 2905 2905 |
| 21760 | 21760 | c1190 | 2905 2905 |
| 21761 | 21761 | cb80d | 2905 2905 |
| 21762 | 21762 | 371f0 | 2905 2905 |
| 21763 | 21763 | bf1e7 | 2905 2905 |
| 21764 | 21764 | e6200 | 2905 2905 |
| 21765 | 21765 | b1201 | 2905 2905 |
| 21766 | 21766 | 902e5 | 2905 2905 |
| 21767 | 21767 | b918e | 2905 2905 |
| 21768 | 21768 | 46d55 | 2905 2905 |
| 21769 | 21769 | 0e9bf | 2905 2905 |
| 21770 | 21770 | edcd8 | 2905 2905 |
| 21771 | 21771 | 22093 | 2905 2905 |
| 21772 | 21772 | e0e2d | 2905 2905 |
| 21773 | 21773 | 561d9 | 2905 2905 |
| 21774 | 21774 | 42fde | 2905 2905 |
| 21775 | 21775 | 927de | 2905 2905 |
| 21776 | 21776 | 25d0f | 2905 2905 |
| 21777 | 21777 | 04182 | 2905 2905 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)