Dynamics CRM open activities sales report

SELECT activitypointer.subject, activitypointer.activitytypecode AS ActivityType, activitypointer.statecode AS ActivityStatus, activitypointer.prioritycode AS Priority, activitypointer.scheduledend AS DueDate
  FROM activitypointer
LEFT OUTER JOIN owner AS owner_activitypointers ON activitypointer.ownerid = owner_activitypointers.ownerid
WHERE (owner_activitypointers.name = 'Devart Corp' AND activitypointer.isregularactivity = True AND (activitypointer.statecode = 'Open' OR activitypointer.statecode = 'Scheduled'))
ORDER BY activitypointer.subject