Advertisement
Guest User

Untitled

a guest
Dec 11th, 2017
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.30 KB | None | 0 0
  1. SELECT * , (cnt_404 / cnt_all) AS 404_prc
  2. FROM (
  3. SELECT bk, bet_type,
  4. COUNT( IF( STATUS IN ( 1, 2, 210 ) , 1, NULL ) ) AS cnt_all,
  5. COUNT( IF( STATUS IN ( 404 ) , 1, NULL ) ) AS cnt_404
  6. FROM `fork_logs`
  7. WHERE DATE( created_at ) >= '2017-12-10'
  8. GROUP BY bk, bet_type
  9. ) AS t
  10. ORDER BY `404_prc` DESC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement