TYPE=VIEW query=select `currentprojid`.`MobileMacNo` AS `inputMobileMacNo`,`tmrwatch`.`newesttmrweighttime`.`TNAME` AS `TNAME`,`tmrwatch`.`newesttmrweighttime`.`tmrID` AS `tmrID`,`tmrwatch`.`newesttmrweighttime`.`DataCaptureNo` AS `DataCaptureNo`,`tmrwatch`.`newesttmrweighttime`.`fname` AS `FNAME`,`tmrwatch`.`newesttmrweighttime`.`BNAME` AS `BNAME`,`tmrwatch`.`newesttmrweighttime`.`recbuttonID` AS `recbuttonID`,`tmrwatch`.`newesttmrweighttime`.`ObjAddr` AS `ObjAddr`,`tmrwatch`.`newesttmrweighttime`.`SrcAddr` AS `SrcAddr`,`tmrwatch`.`newesttmrweighttime`.`InTime` AS `InTime`,`tmrwatch`.`newesttmrweighttime`.`ButtonType` AS `ButtonType`,`tmrwatch`.`newesttmrweighttime`.`ProjTodayID` AS `ProjTodayID`,`tmrwatch`.`newesttmrweighttime`.`Pid` AS `Pid`,`tmrwatch`.`newesttmrweighttime`.`downloadedplanid` AS `downloadedplanid`,`tmrwatch`.`newesttmrweighttime`.`Mydate` AS `Mydate`,`tmrwatch`.`newesttmrweighttime`.`TodayID` AS `TodayID`,`tmrwatch`.`newesttmrweighttime`.`ProjName` AS `ProjName`,`tmrwatch`.`newesttmrweighttime`.`Minutes` AS `Minutes`,`tmrwatch`.`newesttmrweighttime`.`ItemNum` AS `ItemNum`,`tmrwatch`.`newesttmrweighttime`.`MobileMacNo` AS `MobileMacNo`,`tmrwatch`.`newesttmrweighttime`.`FeedItemID` AS `FeedItemID`,`tmrwatch`.`newesttmrweighttime`.`OperateName` AS `OperateName` from (`tmrwatch`.`currentprojid` join `tmrwatch`.`newesttmrweighttime` on(`currentprojid`.`recbuttonID` = `tmrwatch`.`newesttmrweighttime`.`recbuttonID`)) md5=e7a8a330fe2aaec948630055919b3a55 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 `currentprojid`.`MobileMacNo` AS `inputMobileMacNo`,`newesttmrweighttime`.`TNAME` AS `TNAME`,`newesttmrweighttime`.`tmrID` AS `tmrID`,`newesttmrweighttime`.`DataCaptureNo` AS `DataCaptureNo`,`newesttmrweighttime`.`fname` AS `FNAME`,`newesttmrweighttime`.`BNAME` AS `BNAME`,`newesttmrweighttime`.`recbuttonID` AS `recbuttonID`,`newesttmrweighttime`.`ObjAddr` AS `ObjAddr`,`newesttmrweighttime`.`SrcAddr` AS `SrcAddr`,`newesttmrweighttime`.`InTime` AS `InTime`,`newesttmrweighttime`.`ButtonType` AS `ButtonType`,`newesttmrweighttime`.`ProjTodayID` AS `ProjTodayID`,`newesttmrweighttime`.`Pid` AS `Pid`,`newesttmrweighttime`.`downloadedplanid` AS `downloadedplanid`,`newesttmrweighttime`.`Mydate` AS `Mydate`,`newesttmrweighttime`.`TodayID` AS `TodayID`,`newesttmrweighttime`.`ProjName` AS `ProjName`,`newesttmrweighttime`.`Minutes` AS `Minutes`,`newesttmrweighttime`.`ItemNum` AS `ItemNum`,`newesttmrweighttime`.`MobileMacNo` AS `MobileMacNo`,`newesttmrweighttime`.`FeedItemID` AS `FeedItemID`,`newesttmrweighttime`.`OperateName` AS `OperateName` from (`currentprojid` join `newesttmrweighttime` on((`currentprojid`.`recbuttonID` = `newesttmrweighttime`.`recbuttonID`))) client_cs_name=utf8 connection_cl_name=utf8_general_ci view_body_utf8=select `currentprojid`.`MobileMacNo` AS `inputMobileMacNo`,`tmrwatch`.`newesttmrweighttime`.`TNAME` AS `TNAME`,`tmrwatch`.`newesttmrweighttime`.`tmrID` AS `tmrID`,`tmrwatch`.`newesttmrweighttime`.`DataCaptureNo` AS `DataCaptureNo`,`tmrwatch`.`newesttmrweighttime`.`fname` AS `FNAME`,`tmrwatch`.`newesttmrweighttime`.`BNAME` AS `BNAME`,`tmrwatch`.`newesttmrweighttime`.`recbuttonID` AS `recbuttonID`,`tmrwatch`.`newesttmrweighttime`.`ObjAddr` AS `ObjAddr`,`tmrwatch`.`newesttmrweighttime`.`SrcAddr` AS `SrcAddr`,`tmrwatch`.`newesttmrweighttime`.`InTime` AS `InTime`,`tmrwatch`.`newesttmrweighttime`.`ButtonType` AS `ButtonType`,`tmrwatch`.`newesttmrweighttime`.`ProjTodayID` AS `ProjTodayID`,`tmrwatch`.`newesttmrweighttime`.`Pid` AS `Pid`,`tmrwatch`.`newesttmrweighttime`.`downloadedplanid` AS `downloadedplanid`,`tmrwatch`.`newesttmrweighttime`.`Mydate` AS `Mydate`,`tmrwatch`.`newesttmrweighttime`.`TodayID` AS `TodayID`,`tmrwatch`.`newesttmrweighttime`.`ProjName` AS `ProjName`,`tmrwatch`.`newesttmrweighttime`.`Minutes` AS `Minutes`,`tmrwatch`.`newesttmrweighttime`.`ItemNum` AS `ItemNum`,`tmrwatch`.`newesttmrweighttime`.`MobileMacNo` AS `MobileMacNo`,`tmrwatch`.`newesttmrweighttime`.`FeedItemID` AS `FeedItemID`,`tmrwatch`.`newesttmrweighttime`.`OperateName` AS `OperateName` from (`tmrwatch`.`currentprojid` join `tmrwatch`.`newesttmrweighttime` on(`currentprojid`.`recbuttonID` = `tmrwatch`.`newesttmrweighttime`.`recbuttonID`)) mariadb-version=100511