This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
19090 | 19090 | ec3ac | 933 933 |
19091 | 19091 | 4801f | 933 933 |
19092 | 19092 | 5e075 | 933 933 |
19093 | 19093 | 59d75 | 933 933 |
19094 | 19094 | e6200 | 933 933 |
19095 | 19095 | b1201 | 933 933 |
19096 | 19096 | d6347 | 933 933 |
19097 | 19097 | ebf60 | 933 933 |
19098 | 19098 | 9a8c6 | 933 933 |
19099 | 19099 | a2d21 | 933 933 |
19100 | 19100 | a1307 | 933 933 |
19101 | 19101 | abb72 | 933 933 |
19102 | 19102 | 41b26 | 933 933 |
19103 | 19103 | 2db78 | 933 933 |
19104 | 19104 | 6a38c | 933 933 |
19105 | 19105 | e128e | 933 933 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )