This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
2328 | 2328 | dad97 | 1244 1244 |
2401 | 2401 | dad97 | 1249 1249 |
2498 | 2498 | dad97 | 1247 1247 |
2561 | 2561 | dad97 | 1243 1243 |
2598 | 2598 | dad97 | 1246 1246 |
2767 | 2767 | dad97 | 1156 1156 |
3017 | 3017 | dad97 | 1157 1157 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )