This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
14992 | 14992 | ec3ac | 1653 1653 |
14993 | 14993 | 0733f | 1653 1653 |
14994 | 14994 | a14cf | 1653 1653 |
14995 | 14995 | 5e075 | 1653 1653 |
14996 | 14996 | a4abf | 1653 1653 |
14997 | 14997 | 59d75 | 1653 1653 |
14998 | 14998 | e6200 | 1653 1653 |
14999 | 14999 | b1201 | 1653 1653 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )