| 123456789101112131415 |
- TYPE=VIEW
- query=select `e`.`intEvtId` AS `intEvtId`,`e`.`intPastureId` AS `intPastureId`,`e`.`intCowId` AS `intCowId`,`e`.`dateEvtDate` AS `dateEvtDate`,`e`.`intClass` AS `intClass`,`e`.`intPersoner` AS `intPersoner`,`e`.`varNotes` AS `varNotes`,`e`.`OldClass` AS `OldClass`,`e`.`NewClass` AS `NewClass`,`e`.`OldState` AS `OldState`,`e`.`NewState` AS `NewState`,`e`.`OldBar` AS `OldBar`,`e`.`NewBar` AS `NewBar`,`e`.`dateNewDate` AS `dateNewDate`,`e`.`varNewer` AS `varNewer`,`e`.`dateUpdDate` AS `dateUpdDate`,`e`.`varUpder` AS `varUpder`,`e`.`intCurFetal` AS `intCurFetal`,`e`.`OldBarName` AS `OldBarName`,`e`.`NewBarName` AS `NewBarName`,`e`.`sources` AS `sources`,`e`.`fromsource` AS `fromsource` from `heatwatch`.`events` `e` where (isnull(`e`.`dateEvtDate`) or isnull(`e`.`NewClass`))
- md5=231804ab95d181c857bf2aa733de0e50
- updatable=1
- algorithm=0
- definer_user=roo
- definer_host=%
- suid=1
- with_check_option=0
- timestamp=2022-12-14 10:07:38
- create-version=1
- source=select `e`.`intEvtId` AS `intEvtId`,`e`.`intPastureId` AS `intPastureId`,`e`.`intCowId` AS `intCowId`,`e`.`dateEvtDate` AS `dateEvtDate`,`e`.`intClass` AS `intClass`,`e`.`intPersoner` AS `intPersoner`,`e`.`varNotes` AS `varNotes`,`e`.`OldClass` AS `OldClass`,`e`.`NewClass` AS `NewClass`,`e`.`OldState` AS `OldState`,`e`.`NewState` AS `NewState`,`e`.`OldBar` AS `OldBar`,`e`.`NewBar` AS `NewBar`,`e`.`dateNewDate` AS `dateNewDate`,`e`.`varNewer` AS `varNewer`,`e`.`dateUpdDate` AS `dateUpdDate`,`e`.`varUpder` AS `varUpder`,`e`.`intCurFetal` AS `intCurFetal`,`e`.`OldBarName` AS `OldBarName`,`e`.`NewBarName` AS `NewBarName`,`e`.`sources` AS `sources`,`e`.`fromsource` AS `fromsource` from `events` `e` where `e`.`dateEvtDate` is null or `e`.`NewClass` is null
- client_cs_name=utf8
- connection_cl_name=utf8_general_ci
- view_body_utf8=select `e`.`intEvtId` AS `intEvtId`,`e`.`intPastureId` AS `intPastureId`,`e`.`intCowId` AS `intCowId`,`e`.`dateEvtDate` AS `dateEvtDate`,`e`.`intClass` AS `intClass`,`e`.`intPersoner` AS `intPersoner`,`e`.`varNotes` AS `varNotes`,`e`.`OldClass` AS `OldClass`,`e`.`NewClass` AS `NewClass`,`e`.`OldState` AS `OldState`,`e`.`NewState` AS `NewState`,`e`.`OldBar` AS `OldBar`,`e`.`NewBar` AS `NewBar`,`e`.`dateNewDate` AS `dateNewDate`,`e`.`varNewer` AS `varNewer`,`e`.`dateUpdDate` AS `dateUpdDate`,`e`.`varUpder` AS `varUpder`,`e`.`intCurFetal` AS `intCurFetal`,`e`.`OldBarName` AS `OldBarName`,`e`.`NewBarName` AS `NewBarName`,`e`.`sources` AS `sources`,`e`.`fromsource` AS `fromsource` from `heatwatch`.`events` `e` where (isnull(`e`.`dateEvtDate`) or isnull(`e`.`NewClass`))
|
