This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 36549 | 36549 | cc5ed | 1258 1258 |
| 36550 | 36550 | 371f0 | 1258 1258 |
| 36551 | 36551 | e6200 | 1258 1258 |
| 36552 | 36552 | b1201 | 1258 1258 |
| 36553 | 36553 | 8123a | 1258 1258 |
| 36554 | 36554 | 172e0 | 1258 1258 |
| 36555 | 36555 | 45a71 | 1258 1258 |
| 36556 | 36556 | 5d37b | 1258 1258 |
| 36557 | 36557 | 70fc3 | 1258 1258 |
| 36558 | 36558 | 58753 | 1258 1258 |
| 36559 | 36559 | cf4f6 | 1258 1258 |
| 36560 | 36560 | e5c05 | 1258 1258 |
| 36561 | 36561 | c85cd | 1258 1258 |
| 36562 | 36562 | f5d72 | 1258 1258 |
| 36563 | 36563 | a0884 | 1258 1258 |
| 36564 | 36564 | 9eb05 | 1258 1258 |
| 36565 | 36565 | b8e89 | 1258 1258 |
| 36566 | 36566 | 37b83 | 1258 1258 |
| 36567 | 36567 | ff90c | 1258 1258 |
| 36568 | 36568 | 0335c | 1258 1258 |
| 36569 | 36569 | e1707 | 1258 1258 |
| 36570 | 36570 | e58e0 | 1258 1258 |
| 36571 | 36571 | 87070 | 1258 1258 |
| 36572 | 36572 | 79cab | 1258 1258 |
| 36573 | 36573 | 8152e | 1258 1258 |
| 36574 | 36574 | 2a1b9 | 1258 1258 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)