SELECT itemdelive0_.itemdeliverydetail_id AS itemdeli1_4_0_,
       itemdelive0_.itemdelivery_id       AS itemdeli2_4_0_,
       itemdelive0_.partitiondate         AS partitio3_4_0_,
       itemdelive1_.itemdelivery_id       AS itemdeli1_3_1_,
       itemdelive1_.delivery_date         AS delivery2_3_1_,
       supplierin2_.supplierinvoice_id    AS supplier1_9_2_,
       itemdelive0_.amount                AS amount4_0_,
       itemdelive0_.processed_by_rem      AS processed5_4_0_,
       itemdelive0_.single_item_price     AS single6_4_0_,
       itemdelive0_.bookingaccount_id     AS bookinga7_4_0_,
       itemdelive0_.supplierinvoice_id    AS supplier8_4_0_,
       itemdelive1_.delivery_note         AS delivery3_3_1_,
       itemdelive1_.we_number             AS we4_3_1_,
       itemdelive1_.bcc_id                AS bcc5_3_1_,
       itemdelive1_.item_id               AS item6_3_1_,
       itemdelive1_.supplier_id           AS supplier7_3_1_,
       supplierin2_.batchno               AS batchno9_2_,
       supplierin2_.bookingno             AS bookingno9_2_,
       supplierin2_.barcode               AS barcode9_2_,
       supplierin2_.invoice_date          AS invoice5_9_2_,
       supplierin2_.invoice_number        AS invoice6_9_2_,
       supplierin2_.processed_by_rem      AS processed7_9_2_,
       supplierin2_.service_date          AS service8_9_2_,
       supplierin2_.supplier_id           AS supplier9_9_2_
FROM   itemdeliverydetail itemdelive0_
       inner join itemdelivery itemdelive1_
         ON itemdelive0_.itemdelivery_id = itemdelive1_.itemdelivery_id
            AND itemdelive0_.partitiondate = itemdelive1_.delivery_date
       left outer join supplierinvoice supplierin2_
         ON itemdelive0_.supplierinvoice_id = supplierin2_.supplierinvoice_id
WHERE  itemdelive0_.itemdeliverydetail_id = 21931828;

SELECT specialcon0_.specialcondition_id AS specialc1_5_,
       specialcon0_.itemdelivery_id     AS itemdeli2_5_,
       specialcon0_.partitiondate       AS partitio3_5_,
       specialcon0_.condition_value     AS condition4_5_,
       specialcon0_.is_allowed          AS is5_5_,
       specialcon0_.processed_by_rem    AS processed6_5_,
       specialcon0_.spcondtype_id       AS spcondtype7_5_,
       specialcon0_.bookingaccount_id   AS bookinga8_5_
FROM   specialcondition specialcon0_
WHERE  ( specialcon0_.itemdelivery_id, specialcon0_.partitiondate ) IN (SELECT
       itemdelive1_.itemdelivery_id,
              itemdelive1_.partitiondate
                                                                        FROM
              itemdeliverydetail itemdelive1_,
              itemdelivery itemdelive2_
                                                                        WHERE
              itemdelive1_.itemdelivery_id = itemdelive2_.itemdelivery_id
              AND itemdelive1_.partitiondate = itemdelive2_.delivery_date
              AND itemdelive1_.itemdeliverydetail_id = 21931828)