missing_d

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `missing_d`
AS SELECT
   `d60`.`channel_code` AS `channel_code`,
   `d60`.`time_code` AS `time_code`,
   `d60`.`value` AS `value`,
   `d60`.`tep` AS `tep`,
   `d60`.`datasheet_id` AS `datasheet_id`,
   `d60`.`time_year` AS `time_year`,
   `d60`.`time_month` AS `time_month`,
   `d60`.`time_day` AS `time_day`,
   `d60`.`time_hour` AS `time_hour`,
   `s`.`grouping` AS `grouping`
FROM ((`channel_data_60` `d60` join `source` `s` on((`s`.`code` = `d60`.`channel_code`))) left join `channel_data_day` `dm` on(((`d60`.`channel_code` = `dm`.`channel_code`) and (`d60`.`time_year` = `dm`.`time_year`) and (`d60`.`time_month` = `dm`.`time_month`) and (`d60`.`time_day` = `dm`.`time_day`)))) where isnull(`dm`.`channel_code`);