SELECT count(*)
  FROM courses c
       LEFT JOIN course_methodologies cm
          ON cm.method_id = c.method_id
       LEFT JOIN course_status cs
          ON cs.status_id = c.status_id
       LEFT JOIN partners p
          ON p.user_id = c.user_id
       LEFT JOIN events_schedule esched
          ON c.course_id = esched.course_id
       LEFT JOIN currency cur
          ON cur.currency_id = c.currency_id
       LEFT JOIN course_categories cc
          ON cc.course_id = c.course_id
       LEFT JOIN categories cat
          ON cat.category_id = cc.category_id
       LEFT JOIN program_types pt
          ON pt.program_type_id = c.program_type_id
       LEFT JOIN countries con
          ON con.country_id = c.country_id
       LEFT JOIN provinces ps
          ON ps.province_id = c.province_id
       LEFT JOIN states st
          ON st.state_id = c.state_id
       LEFT JOIN city cy
          ON cy.city_id = c.city_id
       LEFT JOIN partners_individual pi
          ON pi.user_id = c.user_id
       LEFT JOIN users u
          ON u.user_id = c.user_id
 WHERE 1 = 1 AND c.course_type = 1 AND active = 1 AND c.country_id = 52
       AND ((('2010-10-01 00:00:00' <= esched.date_start
              AND esched.date_start <= '2010-11-04 00:00:00')
             OR ('2010-10-01 00:00:00' <= esched.date_end
                 AND esched.date_end <= '2010-11-04 00:00:00'))
            OR ((esched.date_start <= '2010-10-01 00:00:00'
                 AND '2010-10-01 00:00:00' <= esched.date_end)
                OR (esched.date_start <= '2011-10-04 00:00:00'
                    AND '2010-11-04 00:00:00' <= esched.date_end)))