|
楼主 |
发表于 2013-9-27 14:02:48
|
显示全部楼层
select t, t.sName, t.sCURL, t.sProcess, t.sActivity, t.sCreateTime, t.sExecutorFName, t.sExecutorNames, t.sEURL, t.sCreatorFName, t.sShortcut, t.sHints, t.sCreatorFID, t.sExecutorFID, t.sKindID from SA_Task t where (t.sKindID='tkTask' or t.sKindID='tkExecutor' or t.sKindID='tkNotice' or t.sKindID IS NULL) and (t.sStatusID='tesReady' or t.sStatusID='tesExecuting') and (t.sTypeID IS NULL or t.sTypeID <> 'WORKREMIND') and (('/A966540DAF5A4F35AD31286344102BA5.ogn/9492B44A6FDB4E63908189E5FB4B74F4.ogn/44392FBF27E44757B95B2F4A9DBFCF44.dpt/BA578AB373884F3CBAFAC5C1FE98FCD8.pos/C850071A40CB4D1FBBE59F1EE63C4BC9@BA578AB373884F3CBAFAC5C1FE98FCD8.psm' like concat(t.sExecutorFID, '%') or '/A966540DAF5A4F35AD31286344102BA5.ogn/9492B44A6FDB4E63908189E5FB4B74F4.ogn/44392FBF27E44757B95B2F4A9DBFCF44.dpt/12409EE64A1E4AF491496A5E6471254B.pos/C850071A40CB4D1FBBE59F1EE63C4BC9@12409EE64A1E4AF491496A5E6471254B.psm' like concat(t.sExecutorFID, '%')) and (t.sExecutorFID like '/%')) order by t.sCreateTime desc limit 0,8
是这个么 |
|