Original query example

SELECT productcha0_.m_product_ch_value_id   AS col_0_0_,
       product3_.m_product_id               AS col_1_0_,
       characteri1_.m_characteristic_id     AS col_2_0_,
       characteri1_.name                    AS col_3_0_,
       characteri1_.isactive                AS col_4_0_,
       characteri1_.em_obpos_filteronwebpos AS col_5_0_,
       characteri2_.m_ch_value_id           AS col_6_0_
FROM   m_product_ch_value productcha0_
       INNER JOIN m_characteristic characteri1_
               ON productcha0_.m_characteristic_id =
                  characteri1_.m_characteristic_id
       INNER JOIN m_ch_value characteri2_
               ON productcha0_.m_ch_value_id = characteri2_.m_ch_value_id
       INNER JOIN m_product product3_
               ON productcha0_.m_product_id = product3_.m_product_id
       INNER JOIN obretco_prol_product obretcopro4_
               ON product3_.m_product_id = obretcopro4_.m_product_id
       INNER JOIN m_productprice pricingpro5_
               ON product3_.m_product_id = pricingpro5_.m_product_id
WHERE  obretcopro4_.obretco_productlist_id = '8D9E81036317417B8B599E8460C3C029'
       AND pricingpro5_.m_pricelist_version_id = 'D77A704798F54DAC9D8D0D669B14787F'
       AND characteri1_.em_obpos_useonwebpos = 'Y'
       AND 1 = 1
       AND 1 = 1
       AND ( productcha0_.ad_org_id IN ( 'C459182BF30B46FEAF1C91DE123CDB99', 'C459182BF30B46FEAF1C91DE123CDB99', 'C459182BF30B46FEAF1C91DE123CDB99', 'E39FFB10775A41B388EE673ECD6BB8F1', '666F00005B054CE49CB29F2A6D53FB2A', '9EBEB39D6202456ABC2F4853145E3BF6' ) )
       AND ( productcha0_.ad_client_id IN ( '9404134F8B374DEE92E79CD87B834E19',
                                            '0' ) )
       AND obretcopro4_.isactive = 'Y'
       AND pricingpro5_.isactive = 'Y'
       AND productcha0_.isactive = 'Y'
       AND characteri1_.isactive = 'Y'
       AND characteri2_.isactive = 'Y'
       AND characteri1_.isactive = 'Y'
ORDER  BY productcha0_.m_product_ch_value_id
LIMIT  '10000' offset '40000';