This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
26079 | 26079 | cc5ed | 2461 2461 |
26080 | 26080 | 371f0 | 2461 2461 |
26081 | 26081 | e6200 | 2461 2461 |
26082 | 26082 | b1201 | 2461 2461 |
26083 | 26083 | 8a7ee | 2461 2461 |
26084 | 26084 | 862ed | 2461 2461 |
26085 | 26085 | d1aa5 | 2461 2461 |
26086 | 26086 | 2ce65 | 2461 2461 |
26087 | 26087 | 18627 | 2461 2461 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )