This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
33388 | 33388 | ec3ac | 820 820 |
33389 | 33389 | b668a | 820 820 |
33390 | 33390 | a14cf | 820 820 |
33391 | 33391 | 5e075 | 820 820 |
33392 | 33392 | 59d75 | 820 820 |
33393 | 33393 | e6200 | 820 820 |
33394 | 33394 | b1201 | 820 820 |
33395 | 33395 | b42a4 | 820 820 |
33396 | 33396 | d679e | 820 820 |
33397 | 33397 | 17bc7 | 820 820 |
33398 | 33398 | aa04d | 820 820 |
33399 | 33399 | 95f91 | 820 820 |
33400 | 33400 | 65a38 | 820 820 |
33401 | 33401 | e128e | 820 820 |
33402 | 33402 | d75c0 | 820 820 |
33403 | 33403 | 16071 | 820 820 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )