This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 34343 | 34343 | ec3ac | 882 882 |
| 34344 | 34344 | b668a | 882 882 |
| 34345 | 34345 | aaf5a | 882 882 |
| 34346 | 34346 | 5e075 | 882 882 |
| 34347 | 34347 | 59d75 | 882 882 |
| 34348 | 34348 | e6200 | 882 882 |
| 34349 | 34349 | b1201 | 882 882 |
| 34350 | 34350 | b42a4 | 882 882 |
| 34351 | 34351 | d679e | 882 882 |
| 34352 | 34352 | 17bc7 | 882 882 |
| 34353 | 34353 | aa04d | 882 882 |
| 34354 | 34354 | 95f91 | 882 882 |
| 34355 | 34355 | 7ce59 | 882 882 |
| 34356 | 34356 | a524c | 882 882 |
| 34357 | 34357 | 234f1 | 882 882 |
| 34358 | 34358 | 100b7 | 882 882 |
| 34359 | 34359 | 1518e | 882 882 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)