This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
28299 | 28299 | cc5ed | 2463 2463 |
28300 | 28300 | 371f0 | 2463 2463 |
28301 | 28301 | e6200 | 2463 2463 |
28302 | 28302 | b1201 | 2463 2463 |
28303 | 28303 | 8a7ee | 2463 2463 |
28304 | 28304 | 862ed | 2463 2463 |
28305 | 28305 | d1aa5 | 2463 2463 |
28306 | 28306 | 2ce65 | 2463 2463 |
28307 | 28307 | 7746b | 2463 2463 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )