This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 167 | 167 | 343d8 | 1098 1098 |
| 592 | 592 | 343d8 | 3043 3043 |
| 1231 | 1231 | 343d8 | 1045 1045 |
| 1404 | 1404 | 343d8 | 1179 1179 |
| 1451 | 1451 | 343d8 | 1057 1057 |
| 1467 | 1467 | 343d8 | 1070 1070 |
| 1796 | 1796 | 343d8 | 1074 1074 |
| 2040 | 2040 | 343d8 | 1041 1041 |
| 2137 | 2137 | 343d8 | 1021 1021 |
| 7059 | 7059 | 343d8 | 1072 1072 |
| 8085 | 8085 | 343d8 | 1052 1052 |
| 8229 | 8229 | 343d8 | 0 0 |
| 29538 | 29538 | 343d8 | 3068 3068 |
| 30381 | 30381 | 343d8 | 3060 3060 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)