This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 21335 | 21335 | cc5ed | 2898 2898 |
| 21336 | 21336 | cb80d | 2898 2898 |
| 21337 | 21337 | 371f0 | 2898 2898 |
| 21338 | 21338 | bf1e7 | 2898 2898 |
| 21339 | 21339 | e6200 | 2898 2898 |
| 21340 | 21340 | b1201 | 2898 2898 |
| 21341 | 21341 | 902e5 | 2898 2898 |
| 21342 | 21342 | bc1ac | 2898 2898 |
| 21343 | 21343 | 22955 | 2898 2898 |
| 21344 | 21344 | 6ec75 | 2898 2898 |
| 21345 | 21345 | 77d7e | 2898 2898 |
| 21346 | 21346 | c46d7 | 2898 2898 |
| 21347 | 21347 | feaa7 | 2898 2898 |
| 21348 | 21348 | a40b9 | 2898 2898 |
| 21349 | 21349 | b4bbb | 2898 2898 |
| 21350 | 21350 | 39305 | 2898 2898 |
| 21351 | 21351 | a7f5a | 2898 2898 |
| 21352 | 21352 | 4a7fd | 2898 2898 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)