SELECT c.course_id,
       c.course_reference_no,
       c.course_title,
       c.currency_id,
       c.cost,
       c.program_type_id,
       c.method_id,
       c.status_id,
       c.no_of_days,
       c.total_hours,
       c.no_of_participants,
       c.no_of_batches,
       c.deadline_for_enrollment,
       c.course_description,
       c.course_details,
       c.trainers_name,
       c.venue,
       c.room_no,
       c.address,
       c.city_id,
       c.province_id,
       c.state_id,
       c.country_id,
       c.zipcode,
       c.contact_details,
       c.partner_id,
       c.date_added,
       c.date_modified,
       c.date_deleted,
       c.batch_date_required,
       c.credits,
       c.active,
       c.cost_vat_included,
       c.cost_not_specified,
       c.expiration_date,
       c.special_offer,
       c.individual_id,
       con.country_name,
       pt.program_type_name,
       cs.status_name,
       cs.status_description,
       cm.method_name,
       cm.method_description,
       p.company_aka,
       cur.name,
       cat.category_name,
       ps.province_name,
       st.state_name,
       cy.city_name,
       p.partner_name,
       pi.lastname,
       pi.firstname,
       CONCAT(CONCAT(pi.lastname, ' , '), pi.firstname) AS fullname,
       esched.*
  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 c.course_title LIKE '%cook%'
       AND cat.main_category_id = 40
       AND cat.category_id = 360
       AND ((('2010-09-01 00:00:00' <= esched.date_start
              AND esched.date_start <= '2010-09-25 00:00:00')
             OR ('2010-09-01 00:00:00' <= esched.date_end
                 AND esched.date_end <= '2010-09-25 00:00:00'))
            OR ((esched.date_start <= '2010-09-01 00:00:00'
                 AND '2010-09-01 00:00:00' <= esched.date_end)
                OR (esched.date_start <= '2010-09-25 00:00:00'
                    AND '2010-09-25 00:00:00' <= esched.date_end)))
GROUP BY c.course_id
ORDER BY c.course_id DESC