| 12345678910111213141516 |
- TYPE=VIEW
- query=select `tmrwatch`.`tmr`.`MobileMacNo` AS `MobileMacNo`,`tmrwatch`.`tmr`.`DataCaptureNo` AS `DataCaptureNo`,`tmrwatch`.`lpplan`.`Minutes` AS `Minutes`,`countdtl1`.`mcount` + `countdtl2`.`mcount` AS `TaskCount`,`tmrwatch`.`lpplan`.`ID` AS `ID`,`tmrwatch`.`lpplan`.`PDATE` AS `PDATE`,`tmrwatch`.`lpplan`.`ProjName` AS `ProjName`,`tmrwatch`.`lpplan`.`PEDate` AS `PEDate`,`tmrwatch`.`lpplan`.`DriverID` AS `DriverID` from (((`tmrwatch`.`lpplan` join `tmrwatch`.`tmr` on(`tmrwatch`.`lpplan`.`TID` = `tmrwatch`.`tmr`.`ID`)) join `tmrwatch`.`countdtl1` on(`tmrwatch`.`lpplan`.`ID` = `countdtl1`.`pid`)) join `tmrwatch`.`countdtl2` on(`tmrwatch`.`lpplan`.`ID` = `countdtl2`.`pid`)) where `tmrwatch`.`lpplan`.`Sel` = 1 order by `tmrwatch`.`lpplan`.`SORT`,`tmrwatch`.`lpplan`.`ProjName`
- md5=eec50df4560cdcbac743e2c5815462e0
- updatable=0
- algorithm=0
- definer_user=root
- definer_host=localhost
- suid=1
- with_check_option=0
- timestamp=2021-12-05 04:06:49
- create-version=2
- source=select `tmr`.`MobileMacNo` AS `MobileMacNo`,`tmr`.`DataCaptureNo` AS `DataCaptureNo`,`lpplan`.`Minutes` AS `Minutes`,(`countdtl1`.`mcount` + `countdtl2`.`mcount`) AS `TaskCount`,`lpplan`.`ID` AS `ID`,`lpplan`.`PDATE` AS `PDATE`,`lpplan`.`ProjName` AS `ProjName`,`lpplan`.`PEDate` AS `PEDate`,`lpplan`.`DriverID` AS `DriverID` from (((`lpplan` join `tmr` on((`lpplan`.`TID` = `tmr`.`ID`))) join `countdtl1` on((`lpplan`.`ID` = `countdtl1`.`pid`))) join `countdtl2` on((`lpplan`.`ID` = `countdtl2`.`pid`))) where (`lpplan`.`Sel` = 1) order by `lpplan`.`SORT`,`lpplan`.`ProjName`
- client_cs_name=utf8
- connection_cl_name=utf8_general_ci
- view_body_utf8=select `tmrwatch`.`tmr`.`MobileMacNo` AS `MobileMacNo`,`tmrwatch`.`tmr`.`DataCaptureNo` AS `DataCaptureNo`,`tmrwatch`.`lpplan`.`Minutes` AS `Minutes`,`countdtl1`.`mcount` + `countdtl2`.`mcount` AS `TaskCount`,`tmrwatch`.`lpplan`.`ID` AS `ID`,`tmrwatch`.`lpplan`.`PDATE` AS `PDATE`,`tmrwatch`.`lpplan`.`ProjName` AS `ProjName`,`tmrwatch`.`lpplan`.`PEDate` AS `PEDate`,`tmrwatch`.`lpplan`.`DriverID` AS `DriverID` from (((`tmrwatch`.`lpplan` join `tmrwatch`.`tmr` on(`tmrwatch`.`lpplan`.`TID` = `tmrwatch`.`tmr`.`ID`)) join `tmrwatch`.`countdtl1` on(`tmrwatch`.`lpplan`.`ID` = `countdtl1`.`pid`)) join `tmrwatch`.`countdtl2` on(`tmrwatch`.`lpplan`.`ID` = `countdtl2`.`pid`)) where `tmrwatch`.`lpplan`.`Sel` = 1 order by `tmrwatch`.`lpplan`.`SORT`,`tmrwatch`.`lpplan`.`ProjName`
- mariadb-version=100511
|
