CREATE TABLE `data` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  `npl` int(11) NOT NULL,
  `date_put` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `i_del` (`deleted`),
  KEY `i_npl` (`npl`),
  KEY `i_dat` (`date_put`),
  KEY `i_dd` (`deleted`,`date_put`) USING BTREE
) ENGINE=InnoDB;

SELECT MAX(npl) FROM data WHERE NOT deleted AND (date_put BETWEEN '2018-01-01 00:00:00' AND '2018-07-29 06:54:00')