Order_stats query

SELECT o2.master_ticket_id, th2.ticket_id,
          IF(get_ticket_count_by_order (o2.master_ticket_id) = 0, COUNT(DISTINCT th2.ticket_id),
            COUNT(DISTINCT IF(
              EXISTS(
                SELECT * FROM merchant_package_characs mpc
                WHERE mpc.merchant_id = th2.merchant_id AND mpc.package_id = th2.package_id AND mpc.name = 'package_type'
                            AND mpc.value = 'Merchandise'
              ), NULL, th2.ticket_id
            ) ) ) AS package_tickets,
        IF( get_ticket_count_by_order (o2.master_ticket_id) = 0, COUNT(DISTINCT th2.ticket_id) , get_ticket_count_by_order (th2.master_ticket_id) ) AS order_tickets
        , o2.merchant_id AS merchant
        , m.name AS merchant_name
        , package_class
        , customer_type_name AS rate_type
        , package_desc
      FROM
        ticket_order_header o2
        INNER JOIN ticket_header th2 ON o2.master_ticket_id = th2.master_ticket_id
        INNER JOIN package_header ON th2.package_id = package_header.package_id
        INNER JOIN customer_type ON th2.customer_type = customer_type.customer_type
        INNER JOIN merchant m ON o2.merchant_id = m.merchant_id
      WHERE (o2.merchant_id IN (6234) or m.parent_econsignment_merchant_id IN (0) )
         AND order_date >= '2012-01-01'
        AND order_date < DATE_ADD('2012-10-31', INTERVAL 1 DAY)
      GROUP BY o2.master_ticket_id, th2.ticket_id