gistfile1.txt

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 ?