(SELECT SUM(IF(r1.status=2,CASE

            WHEN previousDate <= e1.dateFrom AND nextDate >= e1.dateTo
            THEN DATEDIFF(e1.dateTo, e1.dateFrom) + 1
            WHEN previousDate <= e1.dateFrom AND nextDate <= e1.dateTo AND nextDate >= e1.dateFrom
            THEN DATEDIFF(DATESUB(DATEADD(DATE_FORMAT(e.dateTo,'%Y-01-01'),QUARTER(e.dateTo),'quarter'),1,'day'), e1.dateFrom) + 1
            WHEN previousDate >= e1.dateFrom AND nextDate >= e1.dateTo AND previousDate <= e1.dateTo
            THEN DATEDIFF(e1.dateTo, DATESUB(DATEADD(DATE_FORMAT(e.dateFrom,'%Y-01-01'),QUARTER(e.dateFrom),'quarter'),1,'quarter')) + 1
            WHEN previousDate >= e1.dateFrom AND previousDate <= e1.dateTo AND nextDate >= e1.dateFrom AND nextDate <= e1.dateTo
            THEN DATEDIFF(DATESUB(DATEADD(DATE_FORMAT(e.dateTo,'%Y-01-01'),QUARTER(e.dateTo),'quarter'),1,'day'), DATESUB(DATEADD(DATE_FORMAT(e.dateFrom,'%Y-01-01'),QUARTER(e.dateFrom),'quarter'),1,'quarter')) + 1
            ELSE 0

            END,0))
        FROM AutowimarCoreBundle:FinalCarUser f1
        JOIN f1.rentOrders r1
        JOIN r1.calendarEntry e1
        WHERE
      ((e1.dateFrom BETWEEN DATESUB(DATEADD(DATE_FORMAT(e.dateFrom,'%Y-01-01'),QUARTER(e.dateFrom),'quarter'),1,'quarter') AND DATESUB(DATEADD(DATE_FORMAT(e.dateTo,'%Y-01-01'),QUARTER(e.dateTo),'quarter'),1,'day')) OR
      (e1.dateTo BETWEEN DATESUB(DATEADD(DATE_FORMAT(e.dateFrom,'%Y-01-01'),QUARTER(e.dateFrom),'quarter'),1,'quarter') AND DATESUB(DATEADD(DATE_FORMAT(e.dateTo,'%Y-01-01'),QUARTER(e.dateTo),'quarter'),1,'day')) OR
      (e.dateFrom BETWEEN DATE_FORMAT(e1.dateFrom,'%Y-%m-%d 00:00:00') AND DATE_FORMAT(e1.dateTo,'%Y-%m-%d 23:59:59')) OR
      (e.dateTo BETWEEN DATE_FORMAT(e1.dateFrom,'%Y-%m-%d 00:00:00') AND DATE_FORMAT(e1.dateTo,'%Y-%m-%d 23:59:59')))
      AND f1.id = f.id AND r1.packet IN (1,2,3,4))
         as ad