select wh.workorderid as "工单id",wo.title as "主题", LONGTODATE(wh.operationtime) as "操作时间" , wh.description as "描述", wh.operation as "操作" from workorderhistory wh left join workorder wo on wh.workorderid=wo.workorderid where LONGTODATE(wh.operationtime) >= <from_thisweek> AND LONGTODATE(wh.operationtime) <= <to_thisweek> order by wh.workorderid desc