This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
3483 | 3483 | d2054 | 82 82 |
3484 | 3484 | cde0d | 82 82 |
3485 | 3485 | 1ef30 | 82 82 |
3486 | 3486 | 52fc7 | 82 82 |
3487 | 3487 | dd761 | 82 82 |
3488 | 3488 | a1ac8 | 82 82 |
3489 | 3489 | 0250c | 82 82 |
3490 | 3490 | c71fb | 82 82 |
3491 | 3491 | 4ba69 | 82 82 |
3492 | 3492 | d5d33 | 82 82 |
3493 | 3493 | 04bf8 | 82 82 |
3494 | 3494 | 6fba5 | 82 82 |
3495 | 3495 | 371f0 | 82 82 |
3496 | 3496 | 5e075 | 82 82 |
3497 | 3497 | 59d75 | 82 82 |
3498 | 3498 | e6200 | 82 82 |
3499 | 3499 | b1201 | 82 82 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )