SELECT DISTINCT COALESCE (pricingadj0_.M_Offer_Characteristic_ID, characteri2_.M_Ch_Value_ID) AS col_0_0_, pricingadj0_.M_Characteristic_ID AS col_1_0_, characteri2_.M_Ch_Value_ID AS col_2_0_, pricingadj0_.M_Offer_ID AS col_3_0_, characteri1_.Name AS col_4_0_, CASE WHEN pricingadj0_.Isactive = 'Y' AND pricingadj4_.IsActive = 'Y' THEN TRUE ELSE FALSE END AS col_5_0_, pricingadj0_.Isincludecharacteristics AS col_6_0_ FROM M_Offer_Characteristic pricingadj0_ LEFT OUTER JOIN M_Characteristic characteri1_ ON pricingadj0_.M_Characteristic_ID = characteri1_.M_Characteristic_ID LEFT OUTER JOIN M_Ch_Value characteri2_ ON characteri1_.M_Characteristic_ID = characteri2_.M_Characteristic_ID CROSS JOIN M_Offer pricingadj4_ WHERE pricingadj0_.M_Offer_ID = pricingadj4_.M_Offer_ID AND pricingadj0_.Isactive = 'Y' AND pricingadj4_.IsActive = 'Y' AND m_isparent_ch_value (characteri2_.M_Ch_Value_ID, pricingadj0_.M_Ch_Value_ID, pricingadj0_.M_Characteristic_ID) <> - 1 AND (EXISTS ( SELECT 1 FROM M_Offer pricingadj6_ WHERE pricingadj6_.AD_Client_ID = '757D621ABD1948F5BCBAD91F19BB70AC' AND (pricingadj6_.Pricelist_Selection = 'Y' AND NOT (EXISTS ( SELECT 1 FROM M_Offer_PriceList pricingadj7_ WHERE pricingadj7_.IsActive = 'Y' AND pricingadj7_.M_Offer_ID = pricingadj6_.M_Offer_ID AND pricingadj7_.M_PriceList_ID = '638015D6C28C43CC82FDEEAC658A824C')) OR pricingadj6_.Pricelist_Selection = 'N' AND (EXISTS ( SELECT 1 FROM M_Offer_PriceList pricingadj8_ WHERE pricingadj8_.IsActive = 'Y' AND pricingadj8_.M_Offer_ID = pricingadj6_.M_Offer_ID AND pricingadj8_.M_PriceList_ID = '638015D6C28C43CC82FDEEAC658A824C'))) AND (pricingadj6_.Product_Selection = 'Y' OR pricingadj6_.Product_Selection = 'N' AND (EXISTS ( SELECT 1 FROM M_Offer_Product pricingadj9_ CROSS JOIN OBRETCO_Prol_Product obretco_pr10_ CROSS JOIN M_Product product11_ WHERE pricingadj9_.M_Product_ID = product11_.M_Product_ID AND pricingadj9_.M_Offer_ID = pricingadj6_.M_Offer_ID AND pricingadj9_.IsActive = 'Y' AND pricingadj9_.M_Product_ID = obretco_pr10_.M_Product_ID AND obretco_pr10_.Isactive = 'Y' AND product11_.IsActive = 'Y' AND obretco_pr10_.Obretco_Productlist_ID = '5BD0E488E2B44A6488E91BCA79447FFC'))) AND (pricingadj6_.AD_Org_ID IN ('0', '21953EE6A34A424DA97BA8863953A3BB', '1F000EB998B94441AC9388472697307F', 'F57042F02962424BAD986D4F8588E199', 'AF8F3A088EC54473A02AD68E0556BBE3')) AND (pricingadj6_.Org_Selection = 'Y' AND NOT (EXISTS ( SELECT 1 FROM M_Offer_Organization pricingadj12_ WHERE pricingadj12_.Isactive = 'Y' AND pricingadj12_.M_Offer_ID = pricingadj6_.M_Offer_ID AND pricingadj12_.AD_Org_ID = '21953EE6A34A424DA97BA8863953A3BB')) OR pricingadj6_.Org_Selection = 'N' AND (EXISTS ( SELECT 1 FROM M_Offer_Organization pricingadj13_ WHERE pricingadj13_.Isactive = 'Y' AND pricingadj13_.M_Offer_ID = pricingadj6_.M_Offer_ID AND pricingadj13_.AD_Org_ID = '21953EE6A34A424DA97BA8863953A3BB'))) AND (pricingadj6_.EM_OBDISC_C_Currency_ID IS NULL OR pricingadj6_.EM_OBDISC_C_Currency_ID = '102') AND pricingadj0_.M_Offer_ID = pricingadj6_.M_Offer_ID)) AND 1 = 1 ORDER BY pricingadj0_.M_Characteristic_ID ASC LIMIT '50000';