Главная Обзор Помощь
Регистрация Вход
xuyiping
/
docker-compose
1
0
Ответвить 0
Файлы Задачи 0 Запросы на слияние 0 Вики
Ветка: master
Ветки Метки
docker-compose
/
mysql5.7
/
mysql
/
data
/
heatwatch
/
v_cow_infield.frm

v_cow_infield.frm 17 KB
Постоянная ссылка История Исходник

123456789101112131415 
  1. TYPE=VIEW
    2. 

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

  3. md5=9ef2a59f3d9dad24c265943f79a79103
    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:39
    11. 

  11. create-version=1
    12. 

  12. source=select `a`.`intCowId` AS `intCowId`,`b`.`intInId` AS `intInId`,`b`.`intEvtId` AS `intEvtId`,`a`.`varCowCode` AS `varCowCode`,`a`.`dateBirthDate` AS `dateBirthDate`,ifnull(`a`.`decBirWeight`,\'\') AS `decBirWeight`,`a`.`decQuotiety` AS `decQuotiety`,`a`.`intCurBar` AS `intCurBar`,`a`.`intCurFetal` AS `intCurFetal`,ifnull(`a`.`intDryEvtId`,\'\') AS `intDryEvtId`,`a`.`intBreed` AS `intBreed`,`a`.`cSex` AS `cSex`,ifnull(`a`.`dateCurDn`,\'\') AS `dateCurDn`,ifnull(`a`.`intPzCount`,\'\') AS `intPzCount`,`a`.`varProvider` AS `varProvider`,ifnull(`a`.`intPzPerson`,\'\') AS `intPzPerson`,ifnull(`a`.`dateCurFj`,\'\') AS `dateCurFj`,ifnull(`a`.`intFjResult`,\'\') AS `intFjResult`,ifnull(`a`.`intFjPerson`,\'\') AS `intFjPerson`,if(`a`.`dateCurGn` > 0,`a`.`dateCurGn`,if(`a`.`dateCurCd` > 0,\'\',ifnull(`b`.`dateGn`,\'\'))) AS `dateCurGn`,if(`a`.`dateCurCd` > 0,`a`.`dateCurCd`,if(`b`.`dateCd` > 0,`b`.`dateCd`,\'\')) AS `dateCurCd`,if(`a`.`dateCurCd` > 0,ifnull(`a`.`intCdClass`,\'\'),ifnull(`b`.`CdClass`,\'\')) AS `intCdClass`,if(`a`.`dateCurPz` > 0,`a`.`dateCurPz`,if(`a`.`dateCurCd` > 0,\'\',ifnull(`b`.`datePz`,\'\'))) AS `dateCurPz`,if(`a`.`dateCurPz` > 0,`a`.`intBull`,if(`a`.`dateCurCd` > 0,\'\',ifnull(`b`.`varBull`,\'\'))) AS `intBull`,if(`a`.`dateCurYt` > 0,`a`.`dateCurYt`,if(`a`.`dateCurCd` > 0,\'\',ifnull(`b`.`dateYt`,\'\'))) AS `dateCurYt`,ifnull(`a`.`intYtPerson`,\'\') AS `intYtPerson`,ifnull(`a`.`dateLeave`,\'\') AS `dateLeave`,ifnull(`a`.`EID1`,\'\') AS `EID1`,`a`.`EID2` AS `EID2`,`a`.`EID3` AS `EID3`,`a`.`addSource` AS `addSource`,`a`.`isEstrus` AS `isEstrus`,`a`.`lastTQDate` AS `lastTQDate`,`a`.`Activity` AS `Activity`,`a`.`hightActivity` AS `hightActivity`,`a`.`isTQ` AS `isTQ`,ifnull(`a`.`hybriDays`,\'\') AS `hybriDays`,`a`.`lastTQDays` AS `lastTQDays`,`a`.`lastTQ` AS `lastTQ`,`a`.`BlindBubbyCount` AS `BlindBubbyCount`,`a`.`bubbyRepairedDays` AS `bubbyRepairedDays`,`a`.`bubbyCount` AS `bubbyCount`,`a`.`IsbubbyRepaired` AS `IsbubbyRepaired`,`a`.`bubbyDays` AS `bubbyDays`,`a`.`IsBubby` AS `IsBubby`,ifnull(`a`.`footDays`,\'\') AS `footDays`,`a`.`footCount` AS `footCount`,`a`.`IsFootDisease` AS `IsFootDisease`,`a`.`IsfootdiseaseRepaired` AS `IsfootdiseaseRepaired`,`a`.`IsStepDown` AS `IsStepDown`,`a`.`IsJointInjury` AS `IsJointInjury`,`a`.`footdiseaseDays` AS `footdiseaseDays`,`a`.`isSexed` AS `isSexed`,ifnull(`a`.`intHyCount`,\'\') AS `intHyCount`,ifnull(`a`.`productionDate`,\'\') AS `productionDate`,`a`.`gnrhCount` AS `gnrhCount`,`a`.`pgCount` AS `pgCount`,`a`.`estrusDays` AS `estrusDays`,`a`.`drymilkDays` AS `drymilkDays`,ifnull(`a`.`gravidityDays`,\'\') AS `gravidityDays`,ifnull(`a`.`lactationDays`,\'\') AS `lactationDays`,`a`.`emptyDays` AS `emptyDays`,ifnull(`a`.`calvingDays`,\'\') AS `calvingDays`,`a`.`daughterProportion` AS `daughterProportion`,`a`.`childCount` AS `childCount`,`a`.`daughterCount` AS `daughterCount`,`a`.`firstDayAge` AS `firstDayAge`,`a`.`firstDate` AS `firstDate`,`a`.`firstMonthAge` AS `firstMonthAge`,`a`.`monthAge` AS `monthAge`,`a`.`intCurBarName` AS `intCurBarName`,`a`.`relativeActivity` AS `relativeActivity`,`a`.`conductivity` AS `conductivity`,`a`.`timeConsuming` AS `timeConsuming`,`a`.`M2FlowRate` AS `M2FlowRate`,`a`.`S30FlowRate` AS `S30FlowRate`,`a`.`S60FlowRate` AS `S60FlowRate`,`a`.`S15FlowRate` AS `S15FlowRate`,`a`.`produce7diversity` AS `produce7diversity`,`a`.`msProduceDay` AS `msProduceDay`,`a`.`avg7diversity` AS `avg7diversity`,`a`.`MilkingStationPlace` AS `MilkingStationPlace`,`a`.`MilkingStation` AS `MilkingStation`,`a`.`TimesProduce` AS `TimesProduce`,`a`.`TimesBeginDate` AS `TimesBeginDate`,`a`.`TimesDate` AS `TimesDate`,ifnull(`a`.`decP305M`,\'\') AS `decP305M`,`a`.`fatProRatio305` AS `fatProRatio305`,`a`.`decP305P` AS `decP305P`,`a`.`decP305F` AS `decP305F`,`a`.`intCurFetalProduce` AS `intCurFetalProduce`,`a`.`fatProRatio` AS `fatProRatio`,`a`.`decPro` AS `decPro`,`a`.`decFat` AS `decFat`,`a`.`intBodyCell` AS `intBodyCell`,`a`.`gaugeProduce` AS `gaugeProduce`,ifnull(`a`.`intProduceDay`,\'\') AS `intProduceDay`,ifnull(`a`.`ecentGradeDate`,\'\') AS `ecentGradeDate`,ifnull(`a`.`ecentGrade`,\'\') AS `ecentGrade`,`a`.`ecentWeightDate` AS `ecentWeightDate`,`a`.`ecentWeight` AS `ecentWeight`,ifnull(`a`.`ecentQuarantineName`,\'\') AS `ecentQuarantineName`,ifnull(`a`.`ecentQuarantineDate`,\'\') AS `ecentQuarantineDate`,ifnull(`a`.`recentFootDate`,\'\') AS `recentFootDate`,ifnull(`a`.`recentIllName`,\'\') AS `recentIllName`,ifnull(`a`.`recentIllDate`,\'\') AS `recentIllDate`,`a`.`21DateHYL` AS `21DateHYL`,ifnull(`a`.`abortionDate`,\'\') AS `abortionDate`,`a`.`varGoWhere` AS `varGoWhere`,`a`.`calvingMonth` AS `calvingMonth`,ifnull(`a`.`intReason`,\'\') AS `intReason`,`a`.`intLeaveClass` AS `intLeaveClass`,`a`.`zCLNDate` AS `zCLNDate`,`a`.`zYCNDate` AS `zYCNDate`,`a`.`zFYNDate` AS `zFYNDate`,`a`.`begats3` AS `begats3`,`a`.`begats2` AS `begats2`,`a`.`begats1` AS `begats1`,`a`.`grandFather` AS `grandFather`,`a`.`wGrandFather` AS `wGrandFather`,`a`.`varFather` AS `varFather`,`a`.`varMother` AS `varMother`,`a`.`belongState` AS `belongState`,`a`.`sireClass` AS `sireClass`,`a`.`RightPic` AS `RightPic`,`a`.`CenterPic` AS `CenterPic`,`a`.`LeftPic` AS `LeftPic`,`b`.`intYtResult` AS `intYtResult`,`b`.`dateDn` AS `dateDn`,`b`.`varOldCountry` AS `varOldCountry`,`b`.`varOldDiscrbe` AS `varOldDiscrbe`,`b`.`varSex` AS `varSex`,`b`.`mPrice` AS `mPrice`,`b`.`decWeight` AS `decWeight`,ifnull(left(`a`.`EID1createdate`,10),\'\') AS `EID1createdate` from (`cow` `a` join `infield` `b`) where `a`.`intCowId` = `b`.`intCowId`
    13. 

  13. client_cs_name=utf8
    14. 

  14. connection_cl_name=utf8_general_ci
    15. 

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