SELECT
  `p`.`TicketCode` AS `TicketCode`,
  `p`.`PaymentSum` AS `PaymentSum`,
  `p`.`AbonentID` AS `AbonentID`,
  `c`.`ContractorName` AS `ContractorName`,
  `d`.`Year` AS `DiscountYear`,
  `d`.`Quarter` AS `DiscountQuarter`,
  `d`.`Month` AS `DiscountMonth`,
  `d`.`MonthName` AS `DiscountMonthName`,
  `d`.`Day` AS `DiscountDay`,
  `d1`.`Year` AS `PaymentYear`,
  `d1`.`Quarter` AS `PaymentQuarter`,
  `d1`.`Month` AS `PaymentMonth`,
  `d1`.`MonthName` AS `PaymentMonthName`,
  `d2`.`Year` AS `Year`,
  `d2`.`Month` AS `Month`,
  `d2`.`MonthName` AS `MonthName`,
  `pm`.`PaymentMethodName` AS `PaymentMethodName`,
  `ps`.`PaymentSourceName` AS `PaymentSourceName`,
  `pt`.`PaymentTypeName` AS `PaymentTypeName`,
  `pu`.`PublicUtilitiesName` AS `PublicUtilitiesName`,
  `s`.`ServiceName` AS `ServiceName`,
  `s`.`ResourceName` AS `ResourceName`,
  `su`.`SubsidyName` AS `SubsidyName`
FROM ((((((((((`payment` `p`
  JOIN `contractor` `c`
    ON ((`p`.`ContractorID` = `c`.`ContractorID`)))
  JOIN `date` `d`
    ON ((`p`.`DateDiscountID` = `d`.`DateID`)))
  JOIN `date` `d1`
    ON ((`p`.`DatePaymentID` = `d1`.`DateID`)))
  JOIN `date` `d2`
    ON ((`p`.`DateID` = `d2`.`DateID`)))
  JOIN `paymentmethod` `pm`
    ON ((`p`.`PaymentMethodID` = `pm`.`PaymentMethodID`)))
  JOIN `paymentsource` `ps`
    ON ((`p`.`PaymentSourceID` = `ps`.`PaymentSourceID`)))
  JOIN `paymenttype` `pt`
    ON ((`p`.`PaymentTypeID` = `pt`.`PaymentTypeID`)))
  JOIN `publicutilities` `pu`
    ON ((`p`.`PublicUtilitiesID` = `pu`.`PublicUtilitiesID`)))
  JOIN `service` `s`
    ON ((`p`.`ServiceID` = `s`.`ServiceID`)))
  JOIN `subsidy` `su`
    ON ((`p`.`SubsidyID` = `su`.`SubsidyID`)))

select
    `Payment_All`.`ResourceName` as `c0`,
    `Payment_All`.`ServiceName` as `c1`,
    `Payment_All`.`PaymentSourceName` as `c2`,
    `Payment_All`.`DiscountYear` as `c3`,
    `Payment_All`.`DiscountQuarter` as `c4`,
    `Payment_All`.`DiscountMonth` as `c5`,
    `Payment_All`.`DiscountDay` as `c5`,
    sum(`Payment_All`.`PaymentSum`) as `m0`,
    count(distinct `Payment_All`.`TicketCode`) as `m1`
from
    `Payment_All` as `Payment_All`
where
    `Payment_All`.`DiscountYear` = 2013
and
    `Payment_All`.`DiscountQuarter` = 3
and
    `Payment_All`.`DiscountMonth` = 9
and 
    `Payment_All`.`ResourceName` in ('Водоотведение', 'Горячее водоснабжение', 'Холодное водоснабжение')
and
    `Payment_All`.`ServiceName` in ('Водоотведение', 'Горячая вода', 'Холодная вода')
group by
    `Payment_All`.`ResourceName`,
    `Payment_All`.`ServiceName`,
    `Payment_All`.`PaymentSourceName`,
    `Payment_All`.`DiscountYear`,
    `Payment_All`.`DiscountQuarter`,
    `Payment_All`.`DiscountMonth`,
    `Payment_All`.`DiscountDay`

d	1	SIMPLE	index_merge	PRIMARY,IDX_Date_Month,IDX_Date_Quarter,IDX_Date_Year	IDX_Date_Year,IDX_Date_Month,IDX_Date_Quarter	2,1,1		7	Using intersect(IDX_Date_Year,IDX_Date_Month,IDX_Date_Quarter); Using where; Using temporary; Using filesort
p	1	SIMPLE	ref	IDX_Payment_ContractorID,IDX_Payment_DateDiscountID,IDX_Payment_DateID,IDX_Payment_DatePaymentID,IDX_Payment_PaymentMethodID,IDX_Payment_PaymentSourceID,IDX_Payment_PaymentTypeID,IDX_Payment_ServiceID,IDX_Payment_SubsidyID	IDX_Payment_DateDiscountID	4	abonentwh.d.DateID	5508	
pu	1	SIMPLE	eq_ref	PRIMARY	PRIMARY	1	abonentwh.p.PublicUtilitiesID	1	Using index
su	1	SIMPLE	eq_ref	PRIMARY	PRIMARY	1	abonentwh.p.SubsidyID	1	Using index
pm	1	SIMPLE	eq_ref	PRIMARY	PRIMARY	2	abonentwh.p.PaymentMethodID	1	Using index
s	1	SIMPLE	eq_ref	PRIMARY	PRIMARY	2	abonentwh.p.ServiceID	1	Using where
c	1	SIMPLE	eq_ref	PRIMARY	PRIMARY	2	abonentwh.p.ContractorID	1	Using index
ps	1	SIMPLE	eq_ref	PRIMARY	PRIMARY	2	abonentwh.p.PaymentSourceID	1	
d1	1	SIMPLE	eq_ref	PRIMARY	PRIMARY	4	abonentwh.p.DatePaymentID	1	Using index
d2	1	SIMPLE	eq_ref	PRIMARY	PRIMARY	4	abonentwh.p.DateID	1	Using index
pt	1	SIMPLE	eq_ref	PRIMARY	PRIMARY	1	abonentwh.p.PaymentTypeID	1	Using index