Hopefully an easy one for someone out there:

I just need this script to return tickets for the previous week or sat-sun prior

1. SELECT wo.WORKORDERID "Request ID",
   aau.FIRST_NAME "Requester",
   ti.FIRST_NAME "Technician",
   scd.NAME "Subcategory",
   wo.TITLE "Subject",
   ApprovalDetails.EMAIL "Approver Email",
   LONGTODATE(ApprovalStage.SENT_DATE) "Approval Sent date",
   LONGTODATE(ApprovalDetails.ACTION_DATE) "Approved Date",
   ApprovalStatusDefinition.STATUSNAME "Approval Status",
   ApprovalDetails.COMMENTS "Comments" FROM WorkOrder wo
2. LEFT JOIN SDUser sdu ON wo.REQUESTERID=sdu.USERID
   LEFT JOIN AaaUser aau ON sdu.USERID=aau.USER_ID
   LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID 
   LEFT JOIN SubCategoryDefinition scd ON wos.SUBCATEGORYID=scd.SUBCATEGORYID
   LEFT JOIN SDUser td ON wos.OWNERID=td.USERID
   LEFT JOIN AaaUser ti ON td.USERID=ti.USER_ID
   LEFT JOIN PriorityDefinition pd ON wos.PRIORITYID=pd.PRIORITYID
   LEFT JOIN StatusDefinition std ON wos.STATUSID=std.STATUSID
   LEFT JOIN WorkOrder_Queue woq ON wo.WORKORDERID=woq.WORKORDERID
   LEFT JOIN QueueDefinition qd ON woq.QUEUEID=qd.QUEUEID
   JOIN ApprovalStageMapping ON wo.WORKORDERID=ApprovalStageMapping.WORKORDERID
   LEFT JOIN ApprovalDetails ON ApprovalStageMapping.APPROVAL_STAGEID=ApprovalDetails.APPROVAL_STAGEID
   LEFT JOIN ApprovalStage ON ApprovalDetails.APPROVAL_STAGEID=ApprovalStage.APPROVAL_STAGEID
   LEFT JOIN  approvalstatusdefinition ON ApprovalDetails.STATUSID=ApprovalStatusDefinition.STATUSID
3. WHERE  (((scd.NAME = 'Symitar Perameter Changes')
   OR (scd.NAME = 'Symitar Priviledge Change'))
   AND (((wo.CREATEDTIME >= 1430020800000)
   AND ((wo.CREATEDTIME != 0)
   AND (wo.CREATEDTIME IS NOT NULL)))
   AND ((wo.CREATEDTIME <= 1430625599000)
   AND (((wo.CREATEDTIME != 0)
   AND (wo.CREATEDTIME IS NOT NULL))
   AND (wo.CREATEDTIME != -1))))) 
   AND wo.ISPARENT='1'