Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SET @time_from = '2019-03-20 14:28:07'
- SET @time_to = '2019-03-20 13:01:25'
- SET @owner_id = 25
- SELECT
- SUM(tasks.now_add) AS now,
- SUM(tasks.need_add) AS need,
- "comment" AS TYPE
- FROM likepanel.tasks
- WHERE
- tasks.TYPE='comment'
- AND tasks.CREATE < @time_from
- AND tasks.CREATE > @time_to
- AND tasks.owner_id = @owner_id
- UNION
- SELECT
- SUM(tasks.now_add) AS now,
- SUM(tasks.need_add) AS need,
- "like" AS TYPE
- FROM likepanel.tasks
- WHERE
- tasks.TYPE='like'
- AND tasks.CREATE < @time_from
- AND tasks.CREATE > @time_to
- AND tasks.owner_id = @owner_id
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement