This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 21681 | 21681 | cc5ed | 2900 2900 |
| 21682 | 21682 | c1190 | 2900 2900 |
| 21683 | 21683 | cb80d | 2900 2900 |
| 21684 | 21684 | 371f0 | 2900 2900 |
| 21685 | 21685 | bf1e7 | 2900 2900 |
| 21686 | 21686 | e6200 | 2900 2900 |
| 21687 | 21687 | b1201 | 2900 2900 |
| 21688 | 21688 | 902e5 | 2900 2900 |
| 21689 | 21689 | b918e | 2900 2900 |
| 21690 | 21690 | 46d55 | 2900 2900 |
| 21691 | 21691 | 597b7 | 2900 2900 |
| 21692 | 21692 | 0e9bf | 2900 2900 |
| 21693 | 21693 | edcd8 | 2900 2900 |
| 21694 | 21694 | 22093 | 2900 2900 |
| 21695 | 21695 | e0e2d | 2900 2900 |
| 21696 | 21696 | 561d9 | 2900 2900 |
| 21697 | 21697 | 1fd76 | 2900 2900 |
| 21698 | 21698 | f478a | 2900 2900 |
| 21699 | 21699 | 83826 | 2900 2900 |
| 21700 | 21700 | dbf07 | 2900 2900 |
| 21701 | 21701 | 56bb6 | 2900 2900 |
| 21702 | 21702 | 927de | 2900 2900 |
| 21703 | 21703 | 35c78 | 2900 2900 |
| 21704 | 21704 | fd049 | 2900 2900 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)