This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
19608 | 19608 | cc5ed | 2841 2841 |
19609 | 19609 | 3da9b | 2841 2841 |
19610 | 19610 | 371f0 | 2841 2841 |
19611 | 19611 | 5e075 | 2841 2841 |
19612 | 19612 | 59d75 | 2841 2841 |
19613 | 19613 | e6200 | 2841 2841 |
19614 | 19614 | b1201 | 2841 2841 |
19615 | 19615 | 8a7ee | 2841 2841 |
19616 | 19616 | 862ed | 2841 2841 |
19617 | 19617 | f788a | 2841 2841 |
19618 | 19618 | 9848a | 2841 2841 |
19619 | 19619 | abb72 | 2841 2841 |
19620 | 19620 | 27369 | 2841 2841 |
19621 | 19621 | e128e | 2841 2841 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )