select swl.softwarename "软件名称",softtype.SOFTWARETYPE AS "软件类型",si.workstationname "工作站名称", aaaUser.FIRST_NAME "所有者", LONGTODATE(swi.filecreatedtime)  "安装时间" from softwarelist swl left join softwareinfo swi on swl.softwareid=swi.softwareid left join systeminfo si on swi.workstationid=si.workstationid left join Resources resource ON si.WORKSTATIONID=resource.RESOURCEID LEFT JOIN ResourceOwner rOwner ON resource.RESOURCEID=rOwner.RESOURCEID LEFT JOIN ResourceAssociation rToAsset ON rOwner.RESOURCEOWNERID=rToAsset.RESOURCEOWNERID LEFT JOIN SoftwareList softl ON swl.SOFTWAREID=softl.SOFTWAREID LEFT JOIN SDUser sdUser ON rOwner.USERID=sdUser.USERID LEFT JOIN AaaUser aaaUser ON sdUser.USERID=aaaUser.USER_ID LEFT JOIN SoftwareType softtype ON softl.SOFTWARETYPEID=softtype.SOFTWARETYPEID WHERE  (softtype.SOFTWARETYPE = 'Prohibited')  and LONGTODATE(swi.filecreatedtime)>=<from_lastweek> and LONGTODATE(swi.filecreatedtime)<=<to_thisweek>