This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
34558 | 34558 | ec3ac | 850 850 |
34559 | 34559 | b668a | 850 850 |
34560 | 34560 | aaf5a | 850 850 |
34561 | 34561 | 5e075 | 850 850 |
34562 | 34562 | 59d75 | 850 850 |
34563 | 34563 | e6200 | 850 850 |
34564 | 34564 | b1201 | 850 850 |
34565 | 34565 | b42a4 | 850 850 |
34566 | 34566 | d679e | 850 850 |
34567 | 34567 | 17bc7 | 850 850 |
34568 | 34568 | aa04d | 850 850 |
34569 | 34569 | 95f91 | 850 850 |
34570 | 34570 | 7ce59 | 850 850 |
34571 | 34571 | a524c | 850 850 |
34572 | 34572 | 234f1 | 850 850 |
34573 | 34573 | 100b7 | 850 850 |
34574 | 34574 | 1518e | 850 850 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )