| 123456789101112131415 |
- TYPE=VIEW
- query=select `heatwatch`.`cow`.`varCowCode` AS `varCowCode`,if((`heatwatch`.`cow`.`intCurBar` > 0),`heatwatch`.`cow`.`intCurBarName`,\'待分配\') AS `intCurBarName`,`heatwatch`.`cow`.`monthAge` AS `monthAge`,`heatwatch`.`cow`.`intPastureId` AS `intPastureId` from `heatwatch`.`cow` where (isnull(`heatwatch`.`cow`.`dateLeave`) and find_in_set(floor(`heatwatch`.`cow`.`monthAge`),(select `heatwatch`.`manageparam`.`varVal` from `heatwatch`.`manageparam` where ((`heatwatch`.`manageparam`.`varDiscribe` = \'拍照月龄\') and (`heatwatch`.`manageparam`.`intPastureId` = `heatwatch`.`cow`.`intPastureId`))))) order by `heatwatch`.`cow`.`intCurBarName`,`heatwatch`.`cow`.`varCowCode`
- md5=205d72b58f9e15047d9768fa2427db7b
- updatable=1
- algorithm=0
- definer_user=roo
- definer_host=%
- suid=1
- with_check_option=0
- timestamp=2022-12-14 10:07:39
- create-version=1
- source=select `cow`.`varCowCode` AS `varCowCode`,if(`cow`.`intCurBar` > 0,`cow`.`intCurBarName`,\'待分配\') AS `intCurBarName`,`cow`.`monthAge` AS `monthAge`,`cow`.`intPastureId` AS `intPastureId` from `cow` where `cow`.`dateLeave` is null and find_in_set(floor(`cow`.`monthAge`),(select `manageparam`.`varVal` from `manageparam` where `manageparam`.`varDiscribe` = \'拍照月龄\' and `manageparam`.`intPastureId` = `cow`.`intPastureId`)) order by `cow`.`intCurBarName`,`cow`.`varCowCode`
- client_cs_name=utf8
- connection_cl_name=utf8_general_ci
- view_body_utf8=select `heatwatch`.`cow`.`varCowCode` AS `varCowCode`,if((`heatwatch`.`cow`.`intCurBar` > 0),`heatwatch`.`cow`.`intCurBarName`,\'待分配\') AS `intCurBarName`,`heatwatch`.`cow`.`monthAge` AS `monthAge`,`heatwatch`.`cow`.`intPastureId` AS `intPastureId` from `heatwatch`.`cow` where (isnull(`heatwatch`.`cow`.`dateLeave`) and find_in_set(floor(`heatwatch`.`cow`.`monthAge`),(select `heatwatch`.`manageparam`.`varVal` from `heatwatch`.`manageparam` where ((`heatwatch`.`manageparam`.`varDiscribe` = \'拍照月龄\') and (`heatwatch`.`manageparam`.`intPastureId` = `heatwatch`.`cow`.`intPastureId`))))) order by `heatwatch`.`cow`.`intCurBarName`,`heatwatch`.`cow`.`varCowCode`
|
