This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
5849 | 5849 | 041e4 | 2888 2888 |
6521 | 6521 | 041e4 | 2887 2887 |
6550 | 6550 | 041e4 | 2893 2893 |
15679 | 15679 | 041e4 | 2885 2885 |
16020 | 16020 | 041e4 | 2884 2884 |
26571 | 26571 | 041e4 | 2886 2886 |
28521 | 28521 | 041e4 | 2889 2889 |
36060 | 36060 | 041e4 | 2890 2890 |
36143 | 36143 | 041e4 | 2894 2894 |
36285 | 36285 | 041e4 | 2891 2891 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )