This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 17230 | 17230 | ec3ac | 3311 3311 |
| 17231 | 17231 | 75744 | 3311 3311 |
| 17232 | 17232 | 371f0 | 3311 3311 |
| 17233 | 17233 | 5e075 | 3311 3311 |
| 17234 | 17234 | 59d75 | 3311 3311 |
| 17235 | 17235 | e6200 | 3311 3311 |
| 17236 | 17236 | b1201 | 3311 3311 |
| 17237 | 17237 | 902e5 | 3311 3311 |
| 17238 | 17238 | f0b0e | 3311 3311 |
| 17239 | 17239 | c8407 | 3311 3311 |
| 17240 | 17240 | bd053 | 3311 3311 |
| 17241 | 17241 | 7f52f | 3311 3311 |
| 17242 | 17242 | bb729 | 3311 3311 |
| 17243 | 17243 | 90708 | 3311 3311 |
| 17244 | 17244 | 06ae5 | 3311 3311 |
| 17245 | 17245 | 710d1 | 3311 3311 |
| 17246 | 17246 | 5ae56 | 3311 3311 |
| 17247 | 17247 | 0b1a1 | 3311 3311 |
| 17248 | 17248 | e737a | 3311 3311 |
| 17249 | 17249 | e7176 | 3311 3311 |
| 17250 | 17250 | 3a582 | 3311 3311 |
| 17251 | 17251 | f872c | 3311 3311 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)