This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
784 | 784 | 6a7d5 | 726 726 |
785 | 785 | c9109 | 726 726 |
786 | 786 | ff144 | 726 726 |
787 | 787 | fb7e7 | 726 726 |
788 | 788 | c7490 | 726 726 |
789 | 789 | 7b958 | 726 726 |
790 | 790 | 9590d | 726 726 |
791 | 791 | c803f | 726 726 |
792 | 792 | 660a5 | 726 726 |
793 | 793 | d7bec | 726 726 |
794 | 794 | 669e2 | 726 726 |
795 | 795 | b023d | 726 726 |
796 | 796 | f5d04 | 726 726 |
797 | 797 | 814aa | 726 726 |
798 | 798 | 7fc32 | 726 726 |
799 | 799 | 8f694 | 726 726 |
800 | 800 | 2482b | 726 726 |
801 | 801 | 9d6fe | 726 726 |
802 | 802 | c552d | 726 726 |
803 | 803 | 073d4 | 726 726 |
804 | 804 | ed665 | 726 726 |
805 | 805 | b6fd0 | 726 726 |
806 | 806 | 7b150 | 726 726 |
807 | 807 | bf1e7 | 726 726 |
808 | 808 | e6200 | 726 726 |
809 | 809 | b1201 | 726 726 |
810 | 810 | 902e5 | 726 726 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )