Advertisement
Guest User

Untitled

a guest
Feb 20th, 2019
58
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.77 KB | None | 0 0
  1. SELECT COUNT(*) AS 'times', userid, name
  2. FROM main
  3. WHERE comedate <= DATE_SUB(CURDATE(),
  4. INTERVAL 5 DAY)
  5. GROUP BY userid ORDER BY times DESC LIMIT 0,2;
  6.  
  7. SELECT * FROM details WHERE 1;
  8.  
  9. select x.times,
  10. x.userid,
  11. x.name,
  12. d.age,
  13. d.location
  14. from
  15. (
  16. SELECT COUNT(*) AS 'times', userid, name
  17. FROM main
  18. WHERE comedate <= DATE_SUB(CURDATE(),
  19. INTERVAL 5 DAY)
  20. GROUP BY userid
  21. ) x
  22. left join details d
  23. on x.userid = d.userid
  24.  
  25. select x.times,
  26. x.userid,
  27. x.name,
  28. d.age,
  29. d.location
  30. from
  31. (
  32. SELECT COUNT(*) AS 'times', userid, name
  33. FROM main
  34. WHERE comedate <= DATE_SUB(CURDATE(),
  35. INTERVAL 5 DAY)
  36. GROUP BY userid
  37. ORDER BY times DESC
  38. LIMIT 0,2
  39. ) x
  40. left join details d
  41. on x.userid = d.userid
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement