Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT COUNT( * ) AS total_cnt,
- COUNT( IF( bk1_is_initiator =1, 1, NULL ) ) AS init_pinnacle,
- COUNT( IF( bk2_is_initiator =1, 1, NULL ) ) AS init_fonbet,
- COUNT( IF( (bk1_is_initiator =0 AND bk2_is_initiator =0), 1, NULL ) ) AS init_none
- FROM `forks_stakes`
- WHERE bk_id = 'FON' AND vm_id IN ('084_KZ_KISLOV')
- AND DATE( added_at ) >= '2019-01-29'
- AND bet_result IN ( 1, -1 )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement