This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
33063 | 33063 | ec3ac | 1538 1538 |
33064 | 33064 | e95bb | 1538 1538 |
33065 | 33065 | 16102 | 1538 1538 |
33066 | 33066 | fc69a | 1538 1538 |
33067 | 33067 | f3822 | 1538 1538 |
33068 | 33068 | 371f0 | 1538 1538 |
33069 | 33069 | e6200 | 1538 1538 |
33070 | 33070 | b1201 | 1538 1538 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )