This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
18567 | 18567 | ec3ac | 931 931 |
18568 | 18568 | 4801f | 931 931 |
18569 | 18569 | 5e075 | 931 931 |
18570 | 18570 | 59d75 | 931 931 |
18571 | 18571 | e6200 | 931 931 |
18572 | 18572 | b1201 | 931 931 |
18573 | 18573 | d6347 | 931 931 |
18574 | 18574 | ebf60 | 931 931 |
18575 | 18575 | 9a8c6 | 931 931 |
18576 | 18576 | 91693 | 931 931 |
18577 | 18577 | 1d2ab | 931 931 |
18578 | 18578 | abb72 | 931 931 |
18579 | 18579 | 41b26 | 931 931 |
18580 | 18580 | 2db78 | 931 931 |
18581 | 18581 | 6a38c | 931 931 |
18582 | 18582 | e128e | 931 931 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )