SELECT
  COUNT(`week`.`id`) AS `cell1`,
  COUNT(`months`.`id`) AS `cell2`
FROM
  (SELECT
     *
   FROM
     `contract`
   WHERE
     `contract`.date_create BETWEEN STR_TO_DATE('2017-10-01  00:00:00', '%Y-%m-%d %H:%i:%s') AND STR_TO_DATE('2017-10-30 23:59:59', '%Y-%m-%d %H:%i:%s')
        AND `contract`.`vidan_flag` = '1'
        AND `contract`.`filial_id` = 4) as months,
  (SELECT
     *
  FROM
     `contract`
  WHERE
     `contract`.date_create BETWEEN STR_TO_DATE('2017-10-23  00:00:00', '%Y-%m-%d %H:%i:%s') AND STR_TO_DATE('2017-10-30 23:59:59', '%Y-%m-%d %H:%i:%s')
        AND `contract`.`vidan_flag` = '1'
        AND `contract`.`filial_id` = 4) as week
LIMIT 1;

SELECT
  `week`.`cnt` AS `cell1`,
  `months`.`cnt` AS `cell2`
FROM
  (SELECT
     COUNT(`id`) AS `cnt`
   FROM
     `contract`
   WHERE
     `contract`.date_create BETWEEN '2017-10-01  00:00:00' AND '2017-10-30 23:59:59'
     AND `contract`.`vidan_flag` = '1'
     AND `contract`.`filial_id` = 4) as months,
  (SELECT
     *
  FROM
     `contract`
  WHERE
     `contract`.date_create BETWEEN '2017-10-23  00:00:00' AND '2017-10-30 23:59:59'
     AND `contract`.`vidan_flag` = '1'
     AND `contract`.`filial_id` = 4) as week

SELECT
  COUNT(`ctr`.`id`) AS `cnt_month`
  SUM(IF(
    ctr.date_create BETWEEN '2017-10-23  00:00:00' AND '2017-10-30 23:59:59',
    1,
    0
  )) AS `cnt_week`
FROM
  `contract` ctr
WHERE
  ctr.date_create BETWEEN '2017-10-01  00:00:00' AND '2017-10-30 23:59:59'
  AND ctr.`vidan_flag` = '1'
  AND ctr.`filial_id` = 4

SELECT count(*) as month,
          sum(case when date_create >= '2017-10-23'
                    and date_create < '2017-10-30'+interval 1 day
              then 1 else 0) as week
     FROM `contract`
    WHERE date_create >= '2017-10-01' AND date_create < '2017-10-30'+interval 1 day
      AND `contract`.`vidan_flag` = '1'
      AND `contract`.`filial_id` = 4