Advertisement
viamvadens

Untitled

Feb 5th, 2019
120
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.38 KB | None | 0 0
  1. SELECT COUNT( * ) AS total_cnt,
  2. COUNT( IF( bk1_is_initiator =1, 1, NULL ) ) AS init_pinnacle,
  3. COUNT( IF( bk2_is_initiator =1, 1, NULL ) ) AS init_fonbet,
  4. COUNT( IF( (bk1_is_initiator =0 AND bk2_is_initiator =0), 1, NULL ) ) AS init_none
  5. FROM `forks_stakes`
  6. WHERE bk_id = 'FON' AND vm_id IN ('084_KZ_KISLOV')
  7. AND DATE( added_at ) >= '2019-01-29'
  8. AND bet_result IN ( 1, -1 )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement