This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 24142 | 24142 | cc5ed | 2909 2909 |
| 24143 | 24143 | c1190 | 2909 2909 |
| 24144 | 24144 | cb80d | 2909 2909 |
| 24145 | 24145 | 371f0 | 2909 2909 |
| 24146 | 24146 | bf1e7 | 2909 2909 |
| 24147 | 24147 | e6200 | 2909 2909 |
| 24148 | 24148 | b1201 | 2909 2909 |
| 24149 | 24149 | 902e5 | 2909 2909 |
| 24150 | 24150 | bc1ac | 2909 2909 |
| 24151 | 24151 | 6ec75 | 2909 2909 |
| 24152 | 24152 | 5b456 | 2909 2909 |
| 24153 | 24153 | 77d7e | 2909 2909 |
| 24154 | 24154 | c46d7 | 2909 2909 |
| 24155 | 24155 | e5437 | 2909 2909 |
| 24156 | 24156 | 469ba | 2909 2909 |
| 24157 | 24157 | feaa7 | 2909 2909 |
| 24158 | 24158 | 1aa29 | 2909 2909 |
| 24159 | 24159 | 87529 | 2909 2909 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)