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`))
