select * from schedules 
      INNER JOIN client_locations ON schedules.LOCATION = client_locations.ID 
      LEFT JOIN service_types ON schedules.SERVICE_TYPE = service_types.ID 
      LEFT JOIN s_req ON schedules.ID = s_req.SID 
      LEFT JOIN s_terp ON s_terp.SID = schedules.ID 
WHERE FULL = 0 AND 
     s_req.ID IS NULL AND 
     s_terp.ID IS NULL AND 
     schedules.START_DATE BETWEEN ('2005-10-18 00:00:00' AND '2005-10-30 23:59:00') OR 
     schedules.END_DATE BETWEEN ('2005-10-18 00:00:00' AND '2005-10-30 23:59:00') AND 
     service_types.ID IN (13) 
ORDER BY schedules.START_DATE ASC