Advertisement
viamvadens

Untitled

Feb 5th, 2019
119
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.54 KB | None | 0 0
  1. SELECT fs.id, fs.fork_id, fs.bet_name,
  2. f.bk1_name, f.bk2_name,
  3. fs.real_cf, IF( fs.bk_name = f.bk1_name, bk1_coef, bk2_coef ) AS fork_cf,
  4. (1/IF( fs.bk_name = f.bk1_name, bk1_coef, bk2_coef )-1/fs.real_cf) as BK2_CF_DIFF
  5. FROM (
  6.  
  7. SELECT id, fork_id, bk_name, bet_name, event_name, cf, real_cf, bk1_forks_count, bk2_forks_count
  8. FROM `forks_stakes`
  9. WHERE bk_id = 'FON'
  10. AND vm_id
  11. IN (
  12. '084_KZ_KISLOV', '099_IK_SAIDZHONOV'
  13. )
  14. AND DATE( added_at ) >= '2019-02-04'
  15. GROUP BY event_name, bet_name
  16. ) AS fs
  17. JOIN forks AS f ON ( f.id = fs.fork_id )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement