TYPE=VIEW
query=(select count(`tmrwatch`.`lpplandtl1`.`ID`) AS `mcount`,`tmrwatch`.`lpplandtl1`.`PID` AS `pid` from `tmrwatch`.`lpplandtl1` group by `tmrwatch`.`lpplandtl1`.`PID`)
md5=2b7fcc5c4cf765e54b7a04aeac853f29
updatable=0
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
timestamp=2021-12-05 04:06:48
create-version=2
source=(select count(`lpplandtl1`.`ID`) AS `mcount`,`lpplandtl1`.`PID` AS `pid` from `lpplandtl1` group by `lpplandtl1`.`PID`)
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=(select count(`tmrwatch`.`lpplandtl1`.`ID`) AS `mcount`,`tmrwatch`.`lpplandtl1`.`PID` AS `pid` from `tmrwatch`.`lpplandtl1` group by `tmrwatch`.`lpplandtl1`.`PID`)
mariadb-version=100511