This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 5536 | 5536 | ec3ac | 2846 2846 |
| 5537 | 5537 | 3da9b | 2846 2846 |
| 5538 | 5538 | 371f0 | 2846 2846 |
| 5539 | 5539 | e6200 | 2846 2846 |
| 5540 | 5540 | b1201 | 2846 2846 |
| 5541 | 5541 | 902e5 | 2846 2846 |
| 5542 | 5542 | 8a7ee | 2846 2846 |
| 5543 | 5543 | 862ed | 2846 2846 |
| 5544 | 5544 | ebf60 | 2846 2846 |
| 5545 | 5545 | 9848a | 2846 2846 |
| 5546 | 5546 | abb72 | 2846 2846 |
| 5547 | 5547 | 5a04b | 2846 2846 |
| 5548 | 5548 | 27369 | 2846 2846 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)