This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 163 | 163 | ec3ac | 1098 1098 |
| 164 | 164 | 17183 | 1098 1098 |
| 165 | 165 | 96bbd | 1098 1098 |
| 166 | 166 | 550f6 | 1098 1098 |
| 167 | 167 | 343d8 | 1098 1098 |
| 168 | 168 | 313af | 1098 1098 |
| 169 | 169 | f9cc2 | 1098 1098 |
| 170 | 170 | aabe0 | 1098 1098 |
| 171 | 171 | 3e5f6 | 1098 1098 |
| 172 | 172 | 87fac | 1098 1098 |
| 173 | 173 | 1073c | 1098 1098 |
| 174 | 174 | 4801f | 1098 1098 |
| 175 | 175 | 5e075 | 1098 1098 |
| 176 | 176 | 59d75 | 1098 1098 |
| 177 | 177 | e6200 | 1098 1098 |
| 178 | 178 | b1201 | 1098 1098 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)