Mysql query count zero from join where no record, MySQL

Language: Layout:

DROP TABLE IF EXISTS `category` ;
DROP TABLE IF EXISTS `item` ;
DROP TABLE IF EXISTS `transaction` ;
CREATE TABLE `category` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

INSERT INTO `category` VALUES ('1', 'Cat 1');
INSERT INTO `category` VALUES ('2', 'Cat 2');
INSERT INTO `category` VALUES ('3', 'Cat 3');

CREATE TABLE `item` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `category_id` int(11) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `price` decimal(10,0) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

INSERT INTO `item` VALUES ('1', '1', 'Title 1', '10');
INSERT INTO `item` VALUES ('2', '1', 'Title 2', '5');
INSERT INTO `item` VALUES ('3', '1', 'Title 3', '20');
INSERT INTO `item` VALUES ('4', '2', 'Title 4', '10');
INSERT INTO `item` VALUES ('5', '2', 'Title 5', '15');
INSERT INTO `item` VALUES ('6', '3', 'Title 6', '30');

CREATE TABLE `transaction` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `item_id` int(11) DEFAULT NULL,
  `buy_value` int(11) DEFAULT NULL,
  `buy_at_price` decimal(10,0) DEFAULT NULL,
  `date` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

INSERT INTO `transaction` VALUES ('1', '1', '1', '5', '10', '2018-01-01 10:50:18');
INSERT INTO `transaction` VALUES ('2', '1', '3', '2', '20', '2018-01-01 10:51:09');
INSERT INTO `transaction` VALUES ('3', '1', '3', '1', '20', '2018-01-01 10:51:35');
INSERT INTO `transaction` VALUES ('4', '2', '4', '2', '10', '2018-01-01 10:51:58');
INSERT INTO `transaction` VALUES ('5', '2', '5', '2', '15', '2018-01-02 10:52:26');

SELECT
    c.id AS category_id,
    c.name AS category_name,
    COALESCE(SUM(t.buy_value),0) AS total_category_buy_value,
    COALESCE(SUM(t.buy_value * t.buy_at_price),0) AS total_income
FROM
    category c
LEFT JOIN item i ON i.category_id = c.id
LEFT JOIN `transaction` t ON t.item_id = i.id 
                          AND t.date LIKE '2018-01-01%' 
GROUP BY c.id,c.name


absolute service time: 0,38 sec