This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 11339 | 11339 | e8dc0 | 197 197 |
| 11397 | 11397 | e8dc0 | 199 199 |
| 11403 | 11403 | e8dc0 | 207 207 |
| 11470 | 11470 | e8dc0 | 203 203 |
| 11547 | 11547 | e8dc0 | 194 194 |
| 11590 | 11590 | e8dc0 | 201 201 |
| 11617 | 11617 | e8dc0 | 205 205 |
| 11727 | 11727 | e8dc0 | 196 196 |
| 11733 | 11733 | e8dc0 | 309 309 |
| 11782 | 11782 | e8dc0 | 198 198 |
| 11803 | 11803 | e8dc0 | 206 206 |
| 11863 | 11863 | e8dc0 | 0 0 |
| 11869 | 11869 | e8dc0 | 195 195 |
| 11929 | 11929 | e8dc0 | 202 202 |
| 11939 | 11939 | e8dc0 | 310 310 |
| 11980 | 11980 | e8dc0 | 200 200 |
| 11986 | 11986 | e8dc0 | 204 204 |
| 12020 | 12020 | e8dc0 | 193 193 |
| 12153 | 12153 | e8dc0 | 185 185 |
| 12159 | 12159 | e8dc0 | 183 183 |
| 12165 | 12165 | e8dc0 | 311 311 |
| 12396 | 12396 | e8dc0 | 186 186 |
| 12518 | 12518 | e8dc0 | 188 188 |
| 12597 | 12597 | e8dc0 | 184 184 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)