This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 16021 | 16021 | cc5ed | 2795 2795 |
| 16022 | 16022 | cba3e | 2795 2795 |
| 16023 | 16023 | 1c31d | 2795 2795 |
| 16024 | 16024 | e6200 | 2795 2795 |
| 16025 | 16025 | b1201 | 2795 2795 |
| 16026 | 16026 | 902e5 | 2795 2795 |
| 16027 | 16027 | 7e7c6 | 2795 2795 |
| 16028 | 16028 | 4f54f | 2795 2795 |
| 16029 | 16029 | 20a66 | 2795 2795 |
| 16030 | 16030 | 99241 | 2795 2795 |
| 16031 | 16031 | 02a85 | 2795 2795 |
| 16032 | 16032 | be0e2 | 2795 2795 |
| 16033 | 16033 | 12cf3 | 2795 2795 |
| 16034 | 16034 | 397c1 | 2795 2795 |
| 16035 | 16035 | 55a79 | 2795 2795 |
| 16036 | 16036 | ccbed | 2795 2795 |
| 16037 | 16037 | 2e370 | 2795 2795 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)