This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
5851 | 5851 | cba3e | 2783 2783 |
15799 | 15799 | cba3e | 2794 2794 |
15836 | 15836 | cba3e | 2788 2788 |
15873 | 15873 | cba3e | 2786 2786 |
16022 | 16022 | cba3e | 2795 2795 |
16056 | 16056 | cba3e | 2787 2787 |
16094 | 16094 | cba3e | 2793 2793 |
16252 | 16252 | cba3e | 2791 2791 |
16294 | 16294 | cba3e | 2785 2785 |
16339 | 16339 | cba3e | 2781 2781 |
16647 | 16647 | cba3e | 2784 2784 |
16705 | 16705 | cba3e | 2792 2792 |
16799 | 16799 | cba3e | 2782 2782 |
20984 | 20984 | cba3e | 2780 2780 |
24928 | 24928 | cba3e | 2779 2779 |
25928 | 25928 | cba3e | 3390 3390 |
26451 | 26451 | cba3e | 3391 3391 |
26810 | 26810 | cba3e | 3392 3392 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )