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`