gistfile1.sql

    /* criteria query */ select
        this_.id as id7_4_,
        this_.datum as datum7_4_,
        this_.gemeldet as gemeldet7_4_,
        this_.menge as menge7_4_,
        this_.sorte_id as sorte5_7_4_,
        this_1_.weingarten_id as weingarten2_8_4_,
        this_2_.lieferant_id as lieferant3_9_4_,
        this_2_.preis as preis9_4_,
        case 
            when this_1_.id is not null then 1 
            when this_2_.id is not null then 2 
            when this_.id is not null then 0 
        end as clazz_4_,
        esorte2_.id as id0_0_,
        esorte2_.kurzel as kurzel0_0_,
        esorte2_.name as name0_0_,
        eweingarte3_.id as id5_1_,
        eweingarte3_.adresse as adresse5_1_,
        eweingarte3_.aktiv as aktiv5_1_,
        eweingarte3_.name as name5_1_,
        eweingarte3_.ort as ort5_1_,
        eweingarte3_.plz as plz5_1_,
        eweingarte3_.sorte_id as sorte7_5_1_,
        esorte4_.id as id0_2_,
        esorte4_.kurzel as kurzel0_2_,
        esorte4_.name as name0_2_,
        elieferant5_.id as id6_3_,
        elieferant5_.adresse as adresse6_3_,
        elieferant5_.email as email6_3_,
        elieferant5_.fax as fax6_3_,
        elieferant5_.kommentar as kommentar6_3_,
        elieferant5_.land as land6_3_,
        elieferant5_.mobil as mobil6_3_,
        elieferant5_.name as name6_3_,
        elieferant5_.ort as ort6_3_,
        elieferant5_.plz as plz6_3_,
        elieferant5_.telefon as telefon6_3_,
        elieferant5_.titel as titel6_3_,
        elieferant5_.traubenlieferant as trauben13_6_3_,
        elieferant5_.vorname as vorname6_3_,
        elieferant5_.weinlieferant as weinlie15_6_3_ 
    from
        Ernte this_ 
    left outer join
        ErnteErnte this_1_ 
            on this_.id=this_1_.id 
    left outer join
        ErnteZukauf this_2_ 
            on this_.id=this_2_.id 
    inner join
        Sorte esorte2_ 
            on this_.sorte_id=esorte2_.id 
    left outer join
        Weingarten eweingarte3_ 
            on this_1_.weingarten_id=eweingarte3_.id 
    left outer join
        Sorte esorte4_ 
            on eweingarte3_.sorte_id=esorte4_.id 
    left outer join
        Lieferant elieferant5_ 
            on this_2_.lieferant_id=elieferant5_.id 
    order by
        this_.datum asc limit ?