TYPE=VIEW
query=select `c`.`intCowId` AS `evtCowId`,`c`.`intPastureId` AS `intPastureId`,`c`.`varCowCode` AS `varCowCode`,`c`.`dateBirthDate` AS `dateBirthDate`,`c`.`decBirWeight` AS `decBirWeight`,`c`.`decQuotiety` AS `decQuotiety`,`c`.`intCurBar` AS `intCurBar`,`c`.`intCurFetal` AS `intCurFetal`,`c`.`intDryEvtId` AS `intDryEvtId`,`c`.`intBreed` AS `intBreed`,`c`.`cSex` AS `cSex`,`c`.`dateCurDn` AS `dateCurDn`,`c`.`dateCurPz` AS `dateCurPz`,`c`.`intBull` AS `intBull`,`c`.`intPzCount` AS `intPzCount`,`c`.`varProvider` AS `varProvider`,`c`.`intPzPerson` AS `intPzPerson`,`c`.`dateCurYt` AS `dateCurYt`,`c`.`intYtPerson` AS `intYtPerson`,`c`.`dateCurFj` AS `dateCurFj`,`c`.`intFjResult` AS `intFjResult`,`c`.`intFjPerson` AS `intFjPerson`,`c`.`dateCurGn` AS `dateCurGn`,`c`.`dateCurCd` AS `dateCurCd`,`c`.`intCdClass` AS `intCdClass`,`c`.`dateLeave` AS `dateLeave`,`c`.`EID1` AS `EID1`,`c`.`EID2` AS `EID2`,`c`.`EID3` AS `EID3`,`c`.`LeftPic` AS `LeftPic`,`c`.`CenterPic` AS `CenterPic`,`c`.`RightPic` AS `RightPic`,`c`.`sireClass` AS `sireClass`,`c`.`belongState` AS `belongState`,`c`.`varMother` AS `varMother`,`c`.`wGrandFather` AS `wGrandFather`,`c`.`varFather` AS `varFather`,`c`.`grandFather` AS `grandFather`,`c`.`begats1` AS `begats1`,`c`.`begats2` AS `begats2`,`c`.`begats3` AS `begats3`,`c`.`zFYNDate` AS `zFYNDate`,`c`.`zYCNDate` AS `zYCNDate`,`c`.`zCLNDate` AS `zCLNDate`,`c`.`intLeaveClass` AS `intLeaveClass`,`c`.`intReason` AS `intReason`,`c`.`varGoWhere` AS `varGoWhere`,`c`.`calvingMonth` AS `calvingMonth`,`c`.`abortionDate` AS `abortionDate`,`c`.`21DateHYL` AS `21DateHYL`,`c`.`recentIllDate` AS `recentIllDate`,`c`.`recentIllName` AS `recentIllName`,`c`.`recentFootDate` AS `recentFootDate`,`c`.`ecentQuarantineDate` AS `ecentQuarantineDate`,`c`.`ecentQuarantineName` AS `ecentQuarantineName`,`c`.`ecentWeight` AS `ecentWeight`,`c`.`ecentWeightDate` AS `ecentWeightDate`,`c`.`ecentGrade` AS `ecentGrade`,`c`.`ecentGradeDate` AS `ecentGradeDate`,`c`.`intProduceDay` AS `intProduceDay`,`c`.`gaugeProduce` AS `gaugeProduce`,`c`.`intBodyCell` AS `intBodyCell`,`c`.`decFat` AS `decFat`,`c`.`decPro` AS `decPro`,`c`.`fatProRatio` AS `fatProRatio`,`c`.`intCurFetalProduce` AS `intCurFetalProduce`,`c`.`decP305F` AS `decP305F`,`c`.`decP305P` AS `decP305P`,`c`.`fatProRatio305` AS `fatProRatio305`,`c`.`decP305M` AS `decP305M`,`c`.`TimesDate` AS `TimesDate`,`c`.`TimesBeginDate` AS `TimesBeginDate`,`c`.`TimesProduce` AS `TimesProduce`,`c`.`MilkingStation` AS `MilkingStation`,`c`.`MilkingStationPlace` AS `MilkingStationPlace`,`c`.`avg7diversity` AS `avg7diversity`,`c`.`msProduceDay` AS `msProduceDay`,`c`.`produce7diversity` AS `produce7diversity`,`c`.`S15FlowRate` AS `S15FlowRate`,`c`.`S30FlowRate` AS `S30FlowRate`,`c`.`S60FlowRate` AS `S60FlowRate`,`c`.`M2FlowRate` AS `M2FlowRate`,`c`.`timeConsuming` AS `timeConsuming`,`c`.`conductivity` AS `conductivity`,`c`.`relativeActivity` AS `relativeActivity`,`c`.`intCurBarName` AS `intCurBarName`,`c`.`monthAge` AS `monthAge`,`c`.`firstMonthAge` AS `firstMonthAge`,`c`.`firstDate` AS `firstDate`,`c`.`firstDayAge` AS `firstDayAge`,`c`.`daughterCount` AS `daughterCount`,`c`.`childCount` AS `childCount`,`c`.`daughterProportion` AS `daughterProportion`,`c`.`calvingDays` AS `calvingDays`,`c`.`emptyDays` AS `emptyDays`,`c`.`lactationDays` AS `lactationDays`,`c`.`gravidityDays` AS `gravidityDays`,`c`.`estrusDays` AS `estrusDays`,`c`.`drymilkDays` AS `drymilkDays`,`c`.`pgCount` AS `pgCount`,`c`.`gnrhCount` AS `gnrhCount`,`c`.`productionDate` AS `productionDate`,`c`.`intHyCount` AS `intHyCount`,`c`.`isSexed` AS `isSexed`,`c`.`footdiseaseDays` AS `footdiseaseDays`,`c`.`IsJointInjury` AS `IsJointInjury`,`c`.`IsStepDown` AS `IsStepDown`,`c`.`IsfootdiseaseRepaired` AS `IsfootdiseaseRepaired`,`c`.`IsFootDisease` AS `IsFootDisease`,`c`.`footCount` AS `footCount`,`c`.`footDays` AS `footDays`,`c`.`bubbyDays` AS `bubbyDays`,`c`.`IsBubby` AS `IsBubby`,`c`.`IsbubbyRepaired` AS `IsbubbyRepaired`,`c`.`bubbyCount` AS `bubbyCount`,`c`.`bubbyRepairedDays` AS `bubbyRepairedDays`,`c`.`BlindBubbyCount` AS `BlindBubbyCount`,`c`.`lastTQ` AS `lastTQ`,`c`.`lastTQDays` AS `lastTQDays`,`c`.`hybriDays` AS `hybriDays`,`c`.`isTQ` AS `isTQ`,`c`.`hightActivity` AS `hightActivity`,`c`.`Activity` AS `Activity`,`c`.`lastTQDate` AS `lastTQDate`,`c`.`isEstrus` AS `isEstrus`,`c`.`addSource` AS `addSource`,`b`.`cowType` AS `cowType` from (`heatwatch`.`bar` `b` join `heatwatch`.`cow` `c` on(((`b`.`varBarCode` = `c`.`intCurBar`) and (`b`.`intPastureId` = `c`.`intPastureId`))))
md5=04489bb0a6b4b5c1069996e644bec60f
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 `c`.`intCowId` AS `evtCowId`,`c`.`intPastureId` AS `intPastureId`,`c`.`varCowCode` AS `varCowCode`,`c`.`dateBirthDate` AS `dateBirthDate`,`c`.`decBirWeight` AS `decBirWeight`,`c`.`decQuotiety` AS `decQuotiety`,`c`.`intCurBar` AS `intCurBar`,`c`.`intCurFetal` AS `intCurFetal`,`c`.`intDryEvtId` AS `intDryEvtId`,`c`.`intBreed` AS `intBreed`,`c`.`cSex` AS `cSex`,`c`.`dateCurDn` AS `dateCurDn`,`c`.`dateCurPz` AS `dateCurPz`,`c`.`intBull` AS `intBull`,`c`.`intPzCount` AS `intPzCount`,`c`.`varProvider` AS `varProvider`,`c`.`intPzPerson` AS `intPzPerson`,`c`.`dateCurYt` AS `dateCurYt`,`c`.`intYtPerson` AS `intYtPerson`,`c`.`dateCurFj` AS `dateCurFj`,`c`.`intFjResult` AS `intFjResult`,`c`.`intFjPerson` AS `intFjPerson`,`c`.`dateCurGn` AS `dateCurGn`,`c`.`dateCurCd` AS `dateCurCd`,`c`.`intCdClass` AS `intCdClass`,`c`.`dateLeave` AS `dateLeave`,`c`.`EID1` AS `EID1`,`c`.`EID2` AS `EID2`,`c`.`EID3` AS `EID3`,`c`.`LeftPic` AS `LeftPic`,`c`.`CenterPic` AS `CenterPic`,`c`.`RightPic` AS `RightPic`,`c`.`sireClass` AS `sireClass`,`c`.`belongState` AS `belongState`,`c`.`varMother` AS `varMother`,`c`.`wGrandFather` AS `wGrandFather`,`c`.`varFather` AS `varFather`,`c`.`grandFather` AS `grandFather`,`c`.`begats1` AS `begats1`,`c`.`begats2` AS `begats2`,`c`.`begats3` AS `begats3`,`c`.`zFYNDate` AS `zFYNDate`,`c`.`zYCNDate` AS `zYCNDate`,`c`.`zCLNDate` AS `zCLNDate`,`c`.`intLeaveClass` AS `intLeaveClass`,`c`.`intReason` AS `intReason`,`c`.`varGoWhere` AS `varGoWhere`,`c`.`calvingMonth` AS `calvingMonth`,`c`.`abortionDate` AS `abortionDate`,`c`.`21DateHYL` AS `21DateHYL`,`c`.`recentIllDate` AS `recentIllDate`,`c`.`recentIllName` AS `recentIllName`,`c`.`recentFootDate` AS `recentFootDate`,`c`.`ecentQuarantineDate` AS `ecentQuarantineDate`,`c`.`ecentQuarantineName` AS `ecentQuarantineName`,`c`.`ecentWeight` AS `ecentWeight`,`c`.`ecentWeightDate` AS `ecentWeightDate`,`c`.`ecentGrade` AS `ecentGrade`,`c`.`ecentGradeDate` AS `ecentGradeDate`,`c`.`intProduceDay` AS `intProduceDay`,`c`.`gaugeProduce` AS `gaugeProduce`,`c`.`intBodyCell` AS `intBodyCell`,`c`.`decFat` AS `decFat`,`c`.`decPro` AS `decPro`,`c`.`fatProRatio` AS `fatProRatio`,`c`.`intCurFetalProduce` AS `intCurFetalProduce`,`c`.`decP305F` AS `decP305F`,`c`.`decP305P` AS `decP305P`,`c`.`fatProRatio305` AS `fatProRatio305`,`c`.`decP305M` AS `decP305M`,`c`.`TimesDate` AS `TimesDate`,`c`.`TimesBeginDate` AS `TimesBeginDate`,`c`.`TimesProduce` AS `TimesProduce`,`c`.`MilkingStation` AS `MilkingStation`,`c`.`MilkingStationPlace` AS `MilkingStationPlace`,`c`.`avg7diversity` AS `avg7diversity`,`c`.`msProduceDay` AS `msProduceDay`,`c`.`produce7diversity` AS `produce7diversity`,`c`.`S15FlowRate` AS `S15FlowRate`,`c`.`S30FlowRate` AS `S30FlowRate`,`c`.`S60FlowRate` AS `S60FlowRate`,`c`.`M2FlowRate` AS `M2FlowRate`,`c`.`timeConsuming` AS `timeConsuming`,`c`.`conductivity` AS `conductivity`,`c`.`relativeActivity` AS `relativeActivity`,`c`.`intCurBarName` AS `intCurBarName`,`c`.`monthAge` AS `monthAge`,`c`.`firstMonthAge` AS `firstMonthAge`,`c`.`firstDate` AS `firstDate`,`c`.`firstDayAge` AS `firstDayAge`,`c`.`daughterCount` AS `daughterCount`,`c`.`childCount` AS `childCount`,`c`.`daughterProportion` AS `daughterProportion`,`c`.`calvingDays` AS `calvingDays`,`c`.`emptyDays` AS `emptyDays`,`c`.`lactationDays` AS `lactationDays`,`c`.`gravidityDays` AS `gravidityDays`,`c`.`estrusDays` AS `estrusDays`,`c`.`drymilkDays` AS `drymilkDays`,`c`.`pgCount` AS `pgCount`,`c`.`gnrhCount` AS `gnrhCount`,`c`.`productionDate` AS `productionDate`,`c`.`intHyCount` AS `intHyCount`,`c`.`isSexed` AS `isSexed`,`c`.`footdiseaseDays` AS `footdiseaseDays`,`c`.`IsJointInjury` AS `IsJointInjury`,`c`.`IsStepDown` AS `IsStepDown`,`c`.`IsfootdiseaseRepaired` AS `IsfootdiseaseRepaired`,`c`.`IsFootDisease` AS `IsFootDisease`,`c`.`footCount` AS `footCount`,`c`.`footDays` AS `footDays`,`c`.`bubbyDays` AS `bubbyDays`,`c`.`IsBubby` AS `IsBubby`,`c`.`IsbubbyRepaired` AS `IsbubbyRepaired`,`c`.`bubbyCount` AS `bubbyCount`,`c`.`bubbyRepairedDays` AS `bubbyRepairedDays`,`c`.`BlindBubbyCount` AS `BlindBubbyCount`,`c`.`lastTQ` AS `lastTQ`,`c`.`lastTQDays` AS `lastTQDays`,`c`.`hybriDays` AS `hybriDays`,`c`.`isTQ` AS `isTQ`,`c`.`hightActivity` AS `hightActivity`,`c`.`Activity` AS `Activity`,`c`.`lastTQDate` AS `lastTQDate`,`c`.`isEstrus` AS `isEstrus`,`c`.`addSource` AS `addSource`,`b`.`cowType` AS `cowType` from (`bar` `b` join `cow` `c` on(`b`.`varBarCode` = `c`.`intCurBar` and `b`.`intPastureId` = `c`.`intPastureId`))
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `c`.`intCowId` AS `evtCowId`,`c`.`intPastureId` AS `intPastureId`,`c`.`varCowCode` AS `varCowCode`,`c`.`dateBirthDate` AS `dateBirthDate`,`c`.`decBirWeight` AS `decBirWeight`,`c`.`decQuotiety` AS `decQuotiety`,`c`.`intCurBar` AS `intCurBar`,`c`.`intCurFetal` AS `intCurFetal`,`c`.`intDryEvtId` AS `intDryEvtId`,`c`.`intBreed` AS `intBreed`,`c`.`cSex` AS `cSex`,`c`.`dateCurDn` AS `dateCurDn`,`c`.`dateCurPz` AS `dateCurPz`,`c`.`intBull` AS `intBull`,`c`.`intPzCount` AS `intPzCount`,`c`.`varProvider` AS `varProvider`,`c`.`intPzPerson` AS `intPzPerson`,`c`.`dateCurYt` AS `dateCurYt`,`c`.`intYtPerson` AS `intYtPerson`,`c`.`dateCurFj` AS `dateCurFj`,`c`.`intFjResult` AS `intFjResult`,`c`.`intFjPerson` AS `intFjPerson`,`c`.`dateCurGn` AS `dateCurGn`,`c`.`dateCurCd` AS `dateCurCd`,`c`.`intCdClass` AS `intCdClass`,`c`.`dateLeave` AS `dateLeave`,`c`.`EID1` AS `EID1`,`c`.`EID2` AS `EID2`,`c`.`EID3` AS `EID3`,`c`.`LeftPic` AS `LeftPic`,`c`.`CenterPic` AS `CenterPic`,`c`.`RightPic` AS `RightPic`,`c`.`sireClass` AS `sireClass`,`c`.`belongState` AS `belongState`,`c`.`varMother` AS `varMother`,`c`.`wGrandFather` AS `wGrandFather`,`c`.`varFather` AS `varFather`,`c`.`grandFather` AS `grandFather`,`c`.`begats1` AS `begats1`,`c`.`begats2` AS `begats2`,`c`.`begats3` AS `begats3`,`c`.`zFYNDate` AS `zFYNDate`,`c`.`zYCNDate` AS `zYCNDate`,`c`.`zCLNDate` AS `zCLNDate`,`c`.`intLeaveClass` AS `intLeaveClass`,`c`.`intReason` AS `intReason`,`c`.`varGoWhere` AS `varGoWhere`,`c`.`calvingMonth` AS `calvingMonth`,`c`.`abortionDate` AS `abortionDate`,`c`.`21DateHYL` AS `21DateHYL`,`c`.`recentIllDate` AS `recentIllDate`,`c`.`recentIllName` AS `recentIllName`,`c`.`recentFootDate` AS `recentFootDate`,`c`.`ecentQuarantineDate` AS `ecentQuarantineDate`,`c`.`ecentQuarantineName` AS `ecentQuarantineName`,`c`.`ecentWeight` AS `ecentWeight`,`c`.`ecentWeightDate` AS `ecentWeightDate`,`c`.`ecentGrade` AS `ecentGrade`,`c`.`ecentGradeDate` AS `ecentGradeDate`,`c`.`intProduceDay` AS `intProduceDay`,`c`.`gaugeProduce` AS `gaugeProduce`,`c`.`intBodyCell` AS `intBodyCell`,`c`.`decFat` AS `decFat`,`c`.`decPro` AS `decPro`,`c`.`fatProRatio` AS `fatProRatio`,`c`.`intCurFetalProduce` AS `intCurFetalProduce`,`c`.`decP305F` AS `decP305F`,`c`.`decP305P` AS `decP305P`,`c`.`fatProRatio305` AS `fatProRatio305`,`c`.`decP305M` AS `decP305M`,`c`.`TimesDate` AS `TimesDate`,`c`.`TimesBeginDate` AS `TimesBeginDate`,`c`.`TimesProduce` AS `TimesProduce`,`c`.`MilkingStation` AS `MilkingStation`,`c`.`MilkingStationPlace` AS `MilkingStationPlace`,`c`.`avg7diversity` AS `avg7diversity`,`c`.`msProduceDay` AS `msProduceDay`,`c`.`produce7diversity` AS `produce7diversity`,`c`.`S15FlowRate` AS `S15FlowRate`,`c`.`S30FlowRate` AS `S30FlowRate`,`c`.`S60FlowRate` AS `S60FlowRate`,`c`.`M2FlowRate` AS `M2FlowRate`,`c`.`timeConsuming` AS `timeConsuming`,`c`.`conductivity` AS `conductivity`,`c`.`relativeActivity` AS `relativeActivity`,`c`.`intCurBarName` AS `intCurBarName`,`c`.`monthAge` AS `monthAge`,`c`.`firstMonthAge` AS `firstMonthAge`,`c`.`firstDate` AS `firstDate`,`c`.`firstDayAge` AS `firstDayAge`,`c`.`daughterCount` AS `daughterCount`,`c`.`childCount` AS `childCount`,`c`.`daughterProportion` AS `daughterProportion`,`c`.`calvingDays` AS `calvingDays`,`c`.`emptyDays` AS `emptyDays`,`c`.`lactationDays` AS `lactationDays`,`c`.`gravidityDays` AS `gravidityDays`,`c`.`estrusDays` AS `estrusDays`,`c`.`drymilkDays` AS `drymilkDays`,`c`.`pgCount` AS `pgCount`,`c`.`gnrhCount` AS `gnrhCount`,`c`.`productionDate` AS `productionDate`,`c`.`intHyCount` AS `intHyCount`,`c`.`isSexed` AS `isSexed`,`c`.`footdiseaseDays` AS `footdiseaseDays`,`c`.`IsJointInjury` AS `IsJointInjury`,`c`.`IsStepDown` AS `IsStepDown`,`c`.`IsfootdiseaseRepaired` AS `IsfootdiseaseRepaired`,`c`.`IsFootDisease` AS `IsFootDisease`,`c`.`footCount` AS `footCount`,`c`.`footDays` AS `footDays`,`c`.`bubbyDays` AS `bubbyDays`,`c`.`IsBubby` AS `IsBubby`,`c`.`IsbubbyRepaired` AS `IsbubbyRepaired`,`c`.`bubbyCount` AS `bubbyCount`,`c`.`bubbyRepairedDays` AS `bubbyRepairedDays`,`c`.`BlindBubbyCount` AS `BlindBubbyCount`,`c`.`lastTQ` AS `lastTQ`,`c`.`lastTQDays` AS `lastTQDays`,`c`.`hybriDays` AS `hybriDays`,`c`.`isTQ` AS `isTQ`,`c`.`hightActivity` AS `hightActivity`,`c`.`Activity` AS `Activity`,`c`.`lastTQDate` AS `lastTQDate`,`c`.`isEstrus` AS `isEstrus`,`c`.`addSource` AS `addSource`,`b`.`cowType` AS `cowType` from (`heatwatch`.`bar` `b` join `heatwatch`.`cow` `c` on(((`b`.`varBarCode` = `c`.`intCurBar`) and (`b`.`intPastureId` = `c`.`intPastureId`))))
