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
Comments
0 B
|👍
/👎