This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
11886 | 11886 | ec3ac | 793 793 |
11887 | 11887 | b668a | 793 793 |
11888 | 11888 | aaf5a | 793 793 |
11889 | 11889 | 5e075 | 793 793 |
11890 | 11890 | 59d75 | 793 793 |
11891 | 11891 | e6200 | 793 793 |
11892 | 11892 | b1201 | 793 793 |
11893 | 11893 | b42a4 | 793 793 |
11894 | 11894 | d679e | 793 793 |
11895 | 11895 | 17bc7 | 793 793 |
11896 | 11896 | aa04d | 793 793 |
11897 | 11897 | 95f91 | 793 793 |
11898 | 11898 | 7ce59 | 793 793 |
11899 | 11899 | a524c | 793 793 |
11900 | 11900 | 234f1 | 793 793 |
11901 | 11901 | 100b7 | 793 793 |
11902 | 11902 | 1518e | 793 793 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )