This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
9515 | 9515 | ec3ac | 886 886 |
9516 | 9516 | 59b7b | 886 886 |
9517 | 9517 | a14cf | 886 886 |
9518 | 9518 | 5e075 | 886 886 |
9519 | 9519 | 59d75 | 886 886 |
9520 | 9520 | e6200 | 886 886 |
9521 | 9521 | b1201 | 886 886 |
9522 | 9522 | b8d0a | 886 886 |
9523 | 9523 | c8e9f | 886 886 |
9524 | 9524 | e128e | 886 886 |
9525 | 9525 | 598d9 | 886 886 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )