This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 28437 | 28437 | ec3ac | 3181 3181 |
| 28438 | 28438 | 13c3e | 3181 3181 |
| 28439 | 28439 | 371f0 | 3181 3181 |
| 28440 | 28440 | e6200 | 3181 3181 |
| 28441 | 28441 | b1201 | 3181 3181 |
| 28442 | 28442 | 902e5 | 3181 3181 |
| 28443 | 28443 | bc1ac | 3181 3181 |
| 28444 | 28444 | 6ec75 | 3181 3181 |
| 28445 | 28445 | 5b456 | 3181 3181 |
| 28446 | 28446 | a1307 | 3181 3181 |
| 28447 | 28447 | 77d7e | 3181 3181 |
| 28448 | 28448 | c46d7 | 3181 3181 |
| 28449 | 28449 | e5437 | 3181 3181 |
| 28450 | 28450 | b3b48 | 3181 3181 |
| 28451 | 28451 | 27369 | 3181 3181 |
| 28452 | 28452 | 469ba | 3181 3181 |
| 28453 | 28453 | feaa7 | 3181 3181 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)