Home Esplora Aiuto
Registrati Accedi
xuyiping
/
docker-compose
1
0
Forka 0
File Problemi 0 Pull Requests 0 Wiki
Ramo (Branch): master
Rami (Branch) Tag
docker-compose
/
mysql5.7
/
mysql
/
data
/
heatwatch
/
nowcow.frm

nowcow.frm 17 KB
Permalink Cronologia Originale

123456789101112131415 
  1. TYPE=VIEW
    2. 

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

  3. md5=5a707ae6e36c66055b3f433cdea1c406
    4. 

  4. updatable=1
    5. 

  5. algorithm=0
    6. 

  6. definer_user=roo
    7. 

  7. definer_host=%
    8. 

  8. suid=1
    9. 

  9. with_check_option=0
    10. 

  10. timestamp=2022-12-14 10:07:38
    11. 

  11. create-version=1
    12. 

  12. source=select `cow`.`intCowId` AS `intCowId`,`cow`.`intPastureId` AS `intPastureId`,`cow`.`varCowCode` AS `varCowCode`,`cow`.`dateBirthDate` AS `dateBirthDate`,`cow`.`decBirWeight` AS `decBirWeight`,`cow`.`decQuotiety` AS `decQuotiety`,`cow`.`intCurBar` AS `intCurBar`,`cow`.`intCurFetal` AS `intCurFetal`,`cow`.`intDryEvtId` AS `intDryEvtId`,`cow`.`intBreed` AS `intBreed`,`cow`.`cSex` AS `cSex`,`cow`.`dateCurDn` AS `dateCurDn`,`cow`.`dateCurPz` AS `dateCurPz`,`cow`.`intBull` AS `intBull`,`cow`.`intPzCount` AS `intPzCount`,`cow`.`varProvider` AS `varProvider`,`cow`.`intPzPerson` AS `intPzPerson`,`cow`.`dateCurYt` AS `dateCurYt`,`cow`.`intYtPerson` AS `intYtPerson`,`cow`.`dateCurFj` AS `dateCurFj`,`cow`.`intFjResult` AS `intFjResult`,`cow`.`intFjPerson` AS `intFjPerson`,`cow`.`dateCurGn` AS `dateCurGn`,`cow`.`dateCurCd` AS `dateCurCd`,`cow`.`intCdClass` AS `intCdClass`,`cow`.`dateLeave` AS `dateLeave`,`cow`.`EID1` AS `EID1`,`cow`.`EID2` AS `EID2`,`cow`.`EID3` AS `EID3`,`cow`.`LeftPic` AS `LeftPic`,`cow`.`CenterPic` AS `CenterPic`,`cow`.`RightPic` AS `RightPic`,`cow`.`sireClass` AS `sireClass`,`cow`.`belongState` AS `belongState`,`cow`.`varMother` AS `varMother`,`cow`.`wGrandFather` AS `wGrandFather`,`cow`.`varFather` AS `varFather`,`cow`.`grandFather` AS `grandFather`,`cow`.`begats1` AS `begats1`,`cow`.`begats2` AS `begats2`,`cow`.`begats3` AS `begats3`,`cow`.`zFYNDate` AS `zFYNDate`,`cow`.`zYCNDate` AS `zYCNDate`,`cow`.`zCLNDate` AS `zCLNDate`,`cow`.`intLeaveClass` AS `intLeaveClass`,`cow`.`intReason` AS `intReason`,`cow`.`varGoWhere` AS `varGoWhere`,`cow`.`calvingMonth` AS `calvingMonth`,`cow`.`abortionDate` AS `abortionDate`,`cow`.`21DateHYL` AS `21DateHYL`,`cow`.`recentIllDate` AS `recentIllDate`,`cow`.`recentIllName` AS `recentIllName`,`cow`.`recentFootDate` AS `recentFootDate`,`cow`.`ecentQuarantineDate` AS `ecentQuarantineDate`,`cow`.`ecentQuarantineName` AS `ecentQuarantineName`,`cow`.`ecentWeight` AS `ecentWeight`,`cow`.`ecentWeightDate` AS `ecentWeightDate`,`cow`.`ecentGrade` AS `ecentGrade`,`cow`.`ecentGradeDate` AS `ecentGradeDate`,`cow`.`intProduceDay` AS `intProduceDay`,`cow`.`gaugeProduce` AS `gaugeProduce`,`cow`.`intBodyCell` AS `intBodyCell`,`cow`.`decFat` AS `decFat`,`cow`.`decPro` AS `decPro`,`cow`.`fatProRatio` AS `fatProRatio`,`cow`.`intCurFetalProduce` AS `intCurFetalProduce`,`cow`.`decP305F` AS `decP305F`,`cow`.`decP305P` AS `decP305P`,`cow`.`fatProRatio305` AS `fatProRatio305`,`cow`.`decP305M` AS `decP305M`,`cow`.`TimesDate` AS `TimesDate`,`cow`.`TimesBeginDate` AS `TimesBeginDate`,`cow`.`TimesProduce` AS `TimesProduce`,`cow`.`MilkingStation` AS `MilkingStation`,`cow`.`MilkingStationPlace` AS `MilkingStationPlace`,`cow`.`avg7diversity` AS `avg7diversity`,`cow`.`msProduceDay` AS `msProduceDay`,`cow`.`produce7diversity` AS `produce7diversity`,`cow`.`S15FlowRate` AS `S15FlowRate`,`cow`.`S30FlowRate` AS `S30FlowRate`,`cow`.`S60FlowRate` AS `S60FlowRate`,`cow`.`M2FlowRate` AS `M2FlowRate`,`cow`.`timeConsuming` AS `timeConsuming`,`cow`.`conductivity` AS `conductivity`,`cow`.`relativeActivity` AS `relativeActivity`,`cow`.`intCurBarName` AS `intCurBarName`,`cow`.`monthAge` AS `monthAge`,`cow`.`firstMonthAge` AS `firstMonthAge`,`cow`.`firstDate` AS `firstDate`,`cow`.`firstDayAge` AS `firstDayAge`,`cow`.`daughterCount` AS `daughterCount`,`cow`.`childCount` AS `childCount`,`cow`.`daughterProportion` AS `daughterProportion`,`cow`.`calvingDays` AS `calvingDays`,`cow`.`emptyDays` AS `emptyDays`,`cow`.`lactationDays` AS `lactationDays`,`cow`.`gravidityDays` AS `gravidityDays`,`cow`.`estrusDays` AS `estrusDays`,`cow`.`drymilkDays` AS `drymilkDays`,`cow`.`pgCount` AS `pgCount`,`cow`.`gnrhCount` AS `gnrhCount`,`cow`.`productionDate` AS `productionDate`,`cow`.`intHyCount` AS `intHyCount`,`cow`.`isSexed` AS `isSexed`,`cow`.`footdiseaseDays` AS `footdiseaseDays`,`cow`.`IsJointInjury` AS `IsJointInjury`,`cow`.`IsStepDown` AS `IsStepDown`,`cow`.`IsfootdiseaseRepaired` AS `IsfootdiseaseRepaired`,`cow`.`IsFootDisease` AS `IsFootDisease`,`cow`.`footCount` AS `footCount`,`cow`.`footDays` AS `footDays`,`cow`.`bubbyDays` AS `bubbyDays`,`cow`.`IsBubby` AS `IsBubby`,`cow`.`IsbubbyRepaired` AS `IsbubbyRepaired`,`cow`.`bubbyCount` AS `bubbyCount`,`cow`.`bubbyRepairedDays` AS `bubbyRepairedDays`,`cow`.`BlindBubbyCount` AS `BlindBubbyCount`,`cow`.`lastTQ` AS `lastTQ`,`cow`.`lastTQDays` AS `lastTQDays`,`cow`.`hybriDays` AS `hybriDays`,`cow`.`isTQ` AS `isTQ`,`cow`.`hightActivity` AS `hightActivity`,`cow`.`Activity` AS `Activity`,`cow`.`lastTQDate` AS `lastTQDate`,`cow`.`isEstrus` AS `isEstrus`,`cow`.`addSource` AS `addSource` from `cow` where `cow`.`dateLeave` is null and `cow`.`intPastureId` = 1
    13. 

  13. client_cs_name=utf8
    14. 

  14. connection_cl_name=utf8_general_ci
    15. 

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