Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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_.m_characteristic_id IN ( '1D86A256E70E46FEAF0087D860E41E7F', '55AED5E022C048B8898E7EC5DF14B435', 'A9787DD115834241A415E5622519CD89' ) )
- 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';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement