This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
18546 | 18546 | ec3ac | 965 965 |
18547 | 18547 | 4801f | 965 965 |
18548 | 18548 | 5e075 | 965 965 |
18549 | 18549 | 59d75 | 965 965 |
18550 | 18550 | e6200 | 965 965 |
18551 | 18551 | b1201 | 965 965 |
18552 | 18552 | d6347 | 965 965 |
18553 | 18553 | ebf60 | 965 965 |
18554 | 18554 | 9a8c6 | 965 965 |
18555 | 18555 | 91693 | 965 965 |
18556 | 18556 | 1d2ab | 965 965 |
18557 | 18557 | abb72 | 965 965 |
18558 | 18558 | 41b26 | 965 965 |
18559 | 18559 | 2db78 | 965 965 |
18560 | 18560 | 6a38c | 965 965 |
18561 | 18561 | e128e | 965 965 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )