SELECT
count(1)
FROM
(
SELECT
a.id
FROM
vvv_order a
WHERE
(
a.status
= 3
AND a.date_begin = (
SELECT
min(date_begin)
FROM
vvv_order s
WHERE
s.task_id = a.task_id
AND s.status
= 3
)
)
OR (
a.status
= 2
AND vet_status = 1
)
AND a.`status` != 4
AND a.`isDelete` = 0
AND a.admin_id = '199'
AND a.info = - 1
) aa
status=3的情况下可能会有多条一样的数据,除了date_begin不一样.