This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
3436 | 3436 | 0524b | 588 588 |
8338 | 8338 | 0524b | 598 598 |
8351 | 8351 | 0524b | 604 604 |
8488 | 8488 | 0524b | 593 593 |
8494 | 8494 | 0524b | 596 596 |
8713 | 8713 | 0524b | 569 569 |
12880 | 12880 | 0524b | 617 617 |
13208 | 13208 | 0524b | 564 564 |
14571 | 14571 | 0524b | 624 624 |
31123 | 31123 | 0524b | 590 590 |
31151 | 31151 | 0524b | 589 589 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )