This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
10884 | 10884 | 6e2b2 | 1448 1448 |
10885 | 10885 | b60e9 | 1448 1448 |
10886 | 10886 | cc756 | 1448 1448 |
10887 | 10887 | 5e075 | 1448 1448 |
10888 | 10888 | 59d75 | 1448 1448 |
10889 | 10889 | e6200 | 1448 1448 |
10890 | 10890 | b1201 | 1448 1448 |
10891 | 10891 | 8b9b7 | 1448 1448 |
10892 | 10892 | 4dc48 | 1448 1448 |
10893 | 10893 | 8d4bc | 1448 1448 |
10894 | 10894 | 53703 | 1448 1448 |
10895 | 10895 | ec55d | 1448 1448 |
10896 | 10896 | d379e | 1448 1448 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )