This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
5177 | 5177 | 85029 | 692 692 |
5607 | 5607 | 85029 | 693 693 |
6054 | 6054 | 85029 | 691 691 |
6790 | 6790 | 85029 | 687 687 |
7126 | 7126 | 85029 | 688 688 |
7607 | 7607 | 85029 | 686 686 |
7629 | 7629 | 85029 | 680 680 |
8073 | 8073 | 85029 | 679 679 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )