This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
18713 | 18713 | ec3ac | 950 950 |
18714 | 18714 | 4801f | 950 950 |
18715 | 18715 | 5e075 | 950 950 |
18716 | 18716 | 59d75 | 950 950 |
18717 | 18717 | e6200 | 950 950 |
18718 | 18718 | b1201 | 950 950 |
18719 | 18719 | d6347 | 950 950 |
18720 | 18720 | ebf60 | 950 950 |
18721 | 18721 | 9a8c6 | 950 950 |
18722 | 18722 | a2d21 | 950 950 |
18723 | 18723 | a1307 | 950 950 |
18724 | 18724 | abb72 | 950 950 |
18725 | 18725 | 41b26 | 950 950 |
18726 | 18726 | 2db78 | 950 950 |
18727 | 18727 | 6a38c | 950 950 |
18728 | 18728 | e128e | 950 950 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )