This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
29929 | 29929 | cc5ed | 3210 3210 |
29930 | 29930 | 20711 | 3210 3210 |
29931 | 29931 | 371f0 | 3210 3210 |
29932 | 29932 | 00d26 | 3210 3210 |
29933 | 29933 | 5e075 | 3210 3210 |
29934 | 29934 | 59d75 | 3210 3210 |
29935 | 29935 | e6200 | 3210 3210 |
29936 | 29936 | b1201 | 3210 3210 |
29937 | 29937 | 902e5 | 3210 3210 |
29938 | 29938 | 29161 | 3210 3210 |
29939 | 29939 | 14760 | 3210 3210 |
29940 | 29940 | 45c5d | 3210 3210 |
29941 | 29941 | 04629 | 3210 3210 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )