This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
1928 | 1928 | ec3ac | 798 798 |
1929 | 1929 | d6ade | 798 798 |
1930 | 1930 | 8e7b3 | 798 798 |
1931 | 1931 | 2dfbd | 798 798 |
1932 | 1932 | 4e7f1 | 798 798 |
1933 | 1933 | a0f55 | 798 798 |
1934 | 1934 | 61c1a | 798 798 |
1935 | 1935 | e6200 | 798 798 |
1936 | 1936 | b1201 | 798 798 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )