This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
5549 | 5549 | cc5ed | 2750 2750 |
5550 | 5550 | 66d45 | 2750 2750 |
5551 | 5551 | bf1e7 | 2750 2750 |
5552 | 5552 | e6200 | 2750 2750 |
5553 | 5553 | b1201 | 2750 2750 |
5554 | 5554 | 902e5 | 2750 2750 |
5555 | 5555 | 74b62 | 2750 2750 |
5556 | 5556 | 35025 | 2750 2750 |
5557 | 5557 | afd28 | 2750 2750 |
5558 | 5558 | 7e7c6 | 2750 2750 |
5559 | 5559 | 2113e | 2750 2750 |
5560 | 5560 | d5b24 | 2750 2750 |
5561 | 5561 | 0ce79 | 2750 2750 |
5562 | 5562 | 22cc9 | 2750 2750 |
5563 | 5563 | 415bf | 2750 2750 |
5564 | 5564 | 5f339 | 2750 2750 |
5565 | 5565 | d14f5 | 2750 2750 |
5566 | 5566 | 21405 | 2750 2750 |
5567 | 5567 | 0f722 | 2750 2750 |
5568 | 5568 | 984e7 | 2750 2750 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )