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