This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
13785 | 13785 | ec3ac | 868 868 |
13786 | 13786 | b668a | 868 868 |
13787 | 13787 | aaf5a | 868 868 |
13788 | 13788 | 5e075 | 868 868 |
13789 | 13789 | 59d75 | 868 868 |
13790 | 13790 | e6200 | 868 868 |
13791 | 13791 | b1201 | 868 868 |
13792 | 13792 | b42a4 | 868 868 |
13793 | 13793 | d679e | 868 868 |
13794 | 13794 | 17bc7 | 868 868 |
13795 | 13795 | aa04d | 868 868 |
13796 | 13796 | 95f91 | 868 868 |
13797 | 13797 | 7ce59 | 868 868 |
13798 | 13798 | a524c | 868 868 |
13799 | 13799 | 234f1 | 868 868 |
13800 | 13800 | 100b7 | 868 868 |
13801 | 13801 | 1518e | 868 868 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )