select
        human0_.mammal as id1_3_0_,
        human2_.mammal as id1_3_1_,
        human0_2_.description as descript2_3_0_,
        human0_2_.body_weight as body_wei3_3_0_,
        human0_2_.mother_id as mother_i4_3_0_,
        human0_2_.father_id as father_i5_3_0_,
        human0_2_.zoo_id as zoo_id6_3_0_,
        human0_2_.serialNumber as serialNu7_3_0_,
        human0_1_.pregnant as pregnant2_14_0_,
        human0_1_.birthdate as birthdat3_14_0_,
        human0_.name_first as name_fir2_7_0_,
        human0_.name_initial as name_ini3_7_0_,
        human0_.name_last as name_las4_7_0_,
        human0_.nickName as nickName5_7_0_,
        human0_.height_centimeters / 2.54E0 as height_c6_7_0_,
        human0_.intValue as intValue7_7_0_,
        human0_.floatValue as floatVal8_7_0_,
        human0_.bigDecimalValue as bigDecim9_7_0_,
        human0_.bigIntegerValue as bigInte10_7_0_,
        human2_2_.description as descript2_3_1_,
        human2_2_.body_weight as body_wei3_3_1_,
        human2_2_.mother_id as mother_i4_3_1_,
        human2_2_.father_id as father_i5_3_1_,
        human2_2_.zoo_id as zoo_id6_3_1_,
        human2_2_.serialNumber as serialNu7_3_1_,
        human2_1_.pregnant as pregnant2_14_1_,
        human2_1_.birthdate as birthdat3_14_1_,
        human2_.name_first as name_fir2_7_1_,
        human2_.name_initial as name_ini3_7_1_,
        human2_.name_last as name_las4_7_1_,
        human2_.nickName as nickName5_7_1_,
        human2_.height_centimeters / 2.54E0 as height_c6_7_1_,
        human2_.intValue as intValue7_7_1_,
        human2_.floatValue as floatVal8_7_1_,
        human2_.bigDecimalValue as bigDecim9_7_1_,
        human2_.bigIntegerValue as bigInte10_7_1_ 
    from
        Human human0_ 
    inner join
        Mammal human0_1_ 
            on human0_.mammal=human0_1_.animal 
    inner join
        Animal human0_2_ 
            on human0_.mammal=human0_2_.id 
    inner join
        Human_friends friends1_ 
            on human0_.mammal=friends1_.human1 
    inner join
        Human human2_ 
            on friends1_.human2=human2_.mammal 
            and (
                human2_2_.body_weight<?
            ) 
    inner join
        Mammal human2_1_ 
            on human2_.mammal=human2_1_.animal 
    inner join
        Animal human2_2_ 
            on human2_.mammal=human2_2_.id