This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 6895 | 6895 | cc5ed | 2976 2976 |
| 6896 | 6896 | d0f15 | 2976 2976 |
| 6897 | 6897 | e6200 | 2976 2976 |
| 6898 | 6898 | b1201 | 2976 2976 |
| 6899 | 6899 | 902e5 | 2976 2976 |
| 6900 | 6900 | baefa | 2976 2976 |
| 6901 | 6901 | 0e2cf | 2976 2976 |
| 6902 | 6902 | 662b5 | 2976 2976 |
| 6903 | 6903 | ee67e | 2976 2976 |
| 6904 | 6904 | 5d35f | 2976 2976 |
| 6905 | 6905 | 13e72 | 2976 2976 |
| 6906 | 6906 | f22ef | 2976 2976 |
| 6907 | 6907 | 7658e | 2976 2976 |
| 6908 | 6908 | 298ca | 2976 2976 |
| 6909 | 6909 | b3570 | 2976 2976 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)