This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
2569 | 2569 | fb88d | 1241 1241 |
2570 | 2570 | 28463 | 1241 1241 |
2571 | 2571 | 8d659 | 1241 1241 |
2572 | 2572 | 9dc02 | 1241 1241 |
2573 | 2573 | 16ae8 | 1241 1241 |
2574 | 2574 | 1a869 | 1241 1241 |
2575 | 2575 | 0e564 | 1241 1241 |
2576 | 2576 | 36ca5 | 1241 1241 |
2577 | 2577 | e95f6 | 1241 1241 |
2578 | 2578 | 9ff24 | 1241 1241 |
2579 | 2579 | e6200 | 1241 1241 |
2580 | 2580 | b1201 | 1241 1241 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )