This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 8139 | 8139 | ec3ac | 1063 1063 |
| 8140 | 8140 | 17183 | 1063 1063 |
| 8141 | 8141 | 96bbd | 1063 1063 |
| 8142 | 8142 | d4179 | 1063 1063 |
| 8143 | 8143 | 313af | 1063 1063 |
| 8144 | 8144 | ebe26 | 1063 1063 |
| 8145 | 8145 | aabe0 | 1063 1063 |
| 8146 | 8146 | e38cb | 1063 1063 |
| 8147 | 8147 | 1073c | 1063 1063 |
| 8148 | 8148 | 4801f | 1063 1063 |
| 8149 | 8149 | 5e075 | 1063 1063 |
| 8150 | 8150 | 59d75 | 1063 1063 |
| 8151 | 8151 | e6200 | 1063 1063 |
| 8152 | 8152 | b1201 | 1063 1063 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)