This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
645 | 645 | cc5ed | 2870 2870 |
646 | 646 | 3da9b | 2870 2870 |
647 | 647 | 371f0 | 2870 2870 |
648 | 648 | 5e075 | 2870 2870 |
649 | 649 | 59d75 | 2870 2870 |
650 | 650 | e6200 | 2870 2870 |
651 | 651 | b1201 | 2870 2870 |
652 | 652 | 8a7ee | 2870 2870 |
653 | 653 | 862ed | 2870 2870 |
654 | 654 | f788a | 2870 2870 |
655 | 655 | 9848a | 2870 2870 |
656 | 656 | abb72 | 2870 2870 |
657 | 657 | 27369 | 2870 2870 |
658 | 658 | e128e | 2870 2870 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )