This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
2285 | 2285 | fb88d | 1069 1069 |
2323 | 2323 | fb88d | 1244 1244 |
2396 | 2396 | fb88d | 1249 1249 |
2453 | 2453 | fb88d | 1240 1240 |
2493 | 2493 | fb88d | 1247 1247 |
2556 | 2556 | fb88d | 1243 1243 |
2569 | 2569 | fb88d | 1241 1241 |
2593 | 2593 | fb88d | 1246 1246 |
2762 | 2762 | fb88d | 1156 1156 |
3012 | 3012 | fb88d | 1157 1157 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )