select count(a.ID,a.WorkflowID ,a.CreatedTime,a.CreatedBy,a.ModifiedBy,a.ModifiedTime ,
(select DisplayPageStepName From AE_WorkflowSteps WHERE WorkflowID =a.WorkflowID and StepName =a.Step) AS Step,
a.Step as InsideStep,
a.StepNo,
a.Title,
"Task,Create User" as UserID,
"Task,ErrorText" as ErrorText,
(select DisplayPageStepName From AE_WorkflowSteps WHERE WorkflowID =a.WorkflowID and StepName =x."Task,PreStep") AS PreStep,
"Task,IsOCR" as IsOCR,
"Task,ReScanMsg" as ReScanMsg,
"Task,ReScanPerson" as ReScanPerson,
(SELECT EndedTime FROM ae_taskstep WHERE TaskID = a.ID AND TaskCreatedTime = a.CreatedTime AND Step = '影像有误待重扫'
ORDER BY StepNo DESC LIMIT 1) as ReScanTime,
(SELECT DISTINCT DisplayPageWorkflowName From AE_WorkflowSteps where WorkflowID =a.WorkflowID ) as WorkflowName,
"Task,ScanUserName" as ScanUserName)
FROM AE_Task a , "Task,K3" x
where a.ID =x.TaskID and 1=1 and step !='影像废弃' AND WorkflowID = 'a24075ee-b482-4e4b-8ed1-5511cb470097' ORDER BY a.CreatedTime DESC LIMIT 0,10;
最后一行where开始报错
以及怎么样通过TABLE_ROWCOUNT才能达到FOUND_ROWS()的效果