This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 153 | 153 | ec3ac | 1028 1028 |
| 154 | 154 | 96bbd | 1028 1028 |
| 155 | 155 | 313af | 1028 1028 |
| 156 | 156 | ebe26 | 1028 1028 |
| 157 | 157 | 1073c | 1028 1028 |
| 158 | 158 | 4801f | 1028 1028 |
| 159 | 159 | 5e075 | 1028 1028 |
| 160 | 160 | 59d75 | 1028 1028 |
| 161 | 161 | e6200 | 1028 1028 |
| 162 | 162 | b1201 | 1028 1028 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)