---- Query for Count
SELECT Count(*) AS y0_ 
FROM   m_pricelist_version this_ 
WHERE  this_.m_pricelist_id='AEE66281A08F42B6BC509B8A80A33C29' 
AND    this_.validfrom<='2016-08-24 00:00:00' 
AND    this_.ad_org_id IN ('E443A31992CB4635AFCAEABE7183CE85', 
                           '0', 
                           'DC206C91AA6A4897B44DA897936E0EC3', 
                           '7BABA5FF80494CAFA54DEBD22EC46F01', 
                           'BAE22373FEBE4CCCA24517E23F0C8A48', 
                           '19404EAD144C49A0AF37D54377CF452D', 
                           'B843C30461EA4501935CB1D125C9C25A', 
                           '2E60544D37534C0B89E765FE29BC0B43') 
AND    this_.ad_client_id IN ('23C59575B9CF467C9620760EB255B389', 
                              '0') 
AND    this_.isactive=$13 2016-08-25 15:50:33 cestLOG:DURATION: 0.152 ms bind s_7091/C_7092:SELECT Count(*) AS y0_ 
FROM   m_pricelist_version this_ 
WHERE  this_.m_pricelist_id=$1 
AND    this_.validfrom<='2016-08-24 00:00:00' 
AND    this_.ad_org_id IN ('E443A31992CB4635AFCAEABE7183CE85', 
                           '0', 
                           'DC206C91AA6A4897B44DA897936E0EC3', 
                           '7BABA5FF80494CAFA54DEBD22EC46F01, 
                           'BAE22373FEBE4CCCA24517E23F0C8A48', 
                           '19404EAD144C49A0AF37D54377CF452D', 
                           'B843C30461EA4501935CB1D125C9C25A', 
                           '2E60544D37534C0B89E765FE29BC0B43') 
AND    this_.ad_client_id IN ('23C59575B9CF467C9620760EB255B389', 
                              '0') 
AND    this_.isactive='Y'

---- Query for List (missing order by)

SELECT this_.m_pricelist_version_id       AS M1_522_0_, 
       this_.ad_client_id                 AS AD2_522_0_, 
       this_.ad_org_id                    AS AD3_522_0_, 
       this_.isactive                     AS IsActive522_0_, 
       this_.created                      AS Created522_0_, 
       this_.createdby                    AS CreatedBy522_0_, 
       this_.updated                      AS Updated522_0_, 
       this_.updatedby                    AS UpdatedBy522_0_, 
       this_.NAME                         AS Name522_0_, 
       this_.description                  AS Descrip10_522_0_, 
       this_.m_pricelist_id               AS M11_522_0_, 
       this_.m_discountschema_id          AS M12_522_0_, 
       this_.validfrom                    AS ValidFrom522_0_, 
       this_.proccreate                   AS ProcCreate522_0_, 
       this_.m_pricelist_version_base_id  AS M15_522_0_, 
       this_.m_pricelist_version_generate AS M16_522_0_ 
FROM   m_pricelist_version this_ 
WHERE  this_.m_pricelist_id = 'AEE66281A08F42B6BC509B8A80A33C29' 
       AND this_.validfrom <=$ '2016-08-24 00:00:00' 
       AND this_.ad_org_id IN ( 'E443A31992CB4635AFCAEABE7183CE85', '0', 'DC206C91AA6A4897B44DA897936E0EC3', '7BABA5FF80494CAFA54DEBD22EC46F01', 
                                'BAE22373FEBE4CCCA24517E23F0C8A48', '19404EAD144C49A0AF37D54377CF452D', 'B843C30461EA4501935CB1D125C9C25A', '2E60544D37534C0B89E765FE29BC0B43' ) 
       AND this_.ad_client_id IN ( '23C59575B9CF467C9620760EB255B389', '0' ) 
       AND this_.isactive = 'Y'