Advertisement
Gistrec

Сколько накрутил клиент за какое-то время

Mar 22nd, 2019
315
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.62 KB | None | 0 0
  1. SET @time_from = '2019-03-20 14:28:07'
  2. SET @time_to   = '2019-03-20 13:01:25'
  3. SET @owner_id  = 25
  4.  
  5. SELECT
  6.      SUM(tasks.now_add)  AS now,
  7.      SUM(tasks.need_add) AS need,
  8.      "comment" AS TYPE
  9. FROM likepanel.tasks
  10. WHERE
  11.      tasks.TYPE='comment'
  12.      AND tasks.CREATE < @time_from
  13.      AND tasks.CREATE > @time_to
  14.      AND tasks.owner_id = @owner_id
  15.  
  16. UNION
  17.  
  18. SELECT
  19.      SUM(tasks.now_add)  AS now,
  20.      SUM(tasks.need_add) AS need,
  21.      "like" AS TYPE
  22. FROM likepanel.tasks
  23. WHERE
  24.      tasks.TYPE='like'
  25.      AND tasks.CREATE < @time_from
  26.      AND tasks.CREATE > @time_to
  27.      AND tasks.owner_id = @owner_id
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement