SQL Query partly dissapears after opening

CREATE TABLE dipendenti.calendar (
  id INT(11) NOT NULL AUTO_INCREMENT,
  datefield DATE NOT NULL,
  PRIMARY KEY (id)
)
ENGINE = INNODB
AUTO_INCREMENT = 14246
AVG_ROW_LENGTH = 28
CHARACTER SET latin1
COLLATE latin1_swedish_ci
ROW_FORMAT = DYNAMIC;

SELECT
  `calendar`.`datefield` AS `data_assunzioni`,
  IFNULL(COUNT(`datipersonali`.`con_inizio_contratto`), 0) AS `assunzioni`
FROM (`calendar`
  LEFT JOIN `datipersonali`
    ON ((CAST(`datipersonali`.`con_inizio_contratto` AS date) = `calendar`.`datefield`)))
WHERE (`calendar`.`datefield` <= CAST(NOW() AS date))
GROUP BY `calendar`.`datefield`

SELECT
  `calendar`.`datefield` AS `data_licenziamenti`,
  IFNULL(COUNT(`datipersonali`.`con_licenziamento_data`), 0) AS `licenziamenti`
FROM (`calendar`
  LEFT JOIN `datipersonali`
    ON ((CAST(`datipersonali`.`con_licenziamento_data` AS date) = `calendar`.`datefield`)))
WHERE (`calendar`.`datefield` <= CAST(NOW() AS date))
GROUP BY `calendar`.`datefield`