SELECT product3_.EM_Obretur_notusereturnreason AS col_0_0_, coalesce( (SELECT obfmtc_pro6_.C_Taxcategory_ID FROM OBFMTC_Product_TaxCategory obfmtc_pro6_ WHERE obfmtc_pro6_.Isactive='Y' AND obfmtc_pro6_.M_Product_ID=product3_.M_Product_ID AND ad_isorgincluded('05DC508527714EDA9AC0B5DA58124FBC', obfmtc_pro6_.AD_Org_ID, product3_.AD_Client_ID)= (SELECT min(ad_isorgincluded('05DC508527714EDA9AC0B5DA58124FBC', obfmtc_pro7_.AD_Org_ID, product3_.AD_Client_ID)) FROM OBFMTC_Product_TaxCategory obfmtc_pro7_ WHERE obfmtc_pro7_.Isactive='Y' AND obfmtc_pro7_.M_Product_ID=product3_.M_Product_ID AND ad_isorgincluded('05DC508527714EDA9AC0B5DA58124FBC', obfmtc_pro7_.AD_Org_ID, product3_.AD_Client_ID)>=0)), product3_.C_TaxCategory_ID) AS col_1_0_, product3_.EM_Obrdm_Delivery_Mode AS col_2_0_, product3_.EM_Obrdm_Delivery_Mode_Lyw AS col_3_0_, product3_.EM_Obrdm_Isdeliveryservice AS col_4_0_, product3_.M_Product_ID AS col_5_0_, product3_.AD_Org_ID AS col_6_0_, product3_.Value AS col_7_0_, coalesce( (SELECT producttrl8_.Name FROM M_Product_Trl producttrl8_ WHERE producttrl8_.AD_Language='fr_FR' AND producttrl8_.M_Product_ID=product3_.M_Product_ID), product3_.Name) AS col_8_0_, product3_.M_Product_Category_ID AS col_9_0_, product3_.EM_Obpos_Scale AS col_10_0_, product3_.C_UOM_ID AS col_11_0_, uom9_.UOMSymbol AS col_12_0_, coalesce(uom9_.StdPrecision) AS col_13_0_, upper(product3_.UPC) AS col_14_0_, product3_.Description AS col_15_0_, product3_.EM_Obpos_Groupedproduct AS col_16_0_, product3_.IsStocked AS col_17_0_, product3_.EM_Obpos_Showstock AS col_18_0_, product3_.IsGeneric AS col_19_0_, product3_.M_Product_Status_ID AS col_20_0_, product3_.Generic_Product_ID AS col_21_0_, product3_.Characteristic_Desc AS col_22_0_, (product3_.Characteristic_Desc||',') AS col_23_0_, product3_.EM_Obpos_Show_Ch_Desc AS col_24_0_, product3_.ProductType AS col_25_0_, product3_.Prod_Cat_Selection AS col_26_0_, product3_.Product_Selection AS col_27_0_, product3_.Print_Description AS col_28_0_, product3_.EM_OBPOS_AllowAnonymousSale AS col_29_0_, product3_.Returnable AS col_30_0_, product3_.Overdue_Return_Days AS col_31_0_, product3_.Ispricerulebased AS col_32_0_, product3_.EM_Obpos_Proposal_Type AS col_33_0_, product3_.EM_Obpos_Ismultiselectable AS col_34_0_, product3_.Islinkedtoproduct AS col_35_0_, product3_.Ismodifytax AS col_36_0_, product3_.Allow_Deferred_Sell AS col_37_0_, product3_.Deferred_Sell_Max_Days AS col_38_0_, product3_.Quantity_Rule AS col_39_0_, product3_.EM_Obpos_Printservices AS col_40_0_, product3_.Weight AS col_41_0_, FALSE AS col_42_0_, product3_.EM_Obpos_Maxpriceassocprod AS col_43_0_, product3_.EM_Obpos_Minpriceassocprod AS col_44_0_, adimage2_.BinaryData AS col_45_0_, adimage2_.AD_Image_ID AS col_46_0_, adimage2_.Mimetype AS col_47_0_, obretco_pr0_.Bestseller AS col_48_0_, obretco_pr0_.M_Product_Status_ID AS col_49_0_, pricingpro5_.PriceList AS col_50_0_, pricingpro5_.PriceStd AS col_51_0_, pricingpro5_.PriceLimit AS col_52_0_, pricingpro5_.Cost AS col_53_0_, pricingpro5_.Algorithm AS col_54_0_, CASE WHEN product3_.IsActive='Y' AND (obretco_pr0_.Isactive IS NOT NULL) THEN obretco_pr0_.Isactive ELSE product3_.IsActive END AS col_55_0_, product3_.EM_Obpos_Editable_Price AS col_56_0_, 'false' AS col_57_0_, CASE WHEN product3_.M_AttributeSet_ID IS NOT NULL THEN TRUE ELSE FALSE END AS col_58_0_, CASE WHEN attributes4_.IsSerNo='Y' THEN TRUE ELSE FALSE END AS col_59_0_, (COALESCE( (SELECT eco.taxamt FROM phieco_taxcategory eco WHERE eco.phieco_taxcategory_id = product_co11_.em_phieco_dea ),0) * product_co11_.em_phieco_dea_qty) AS col_60_0_, (COALESCE( (SELECT eco.taxamt FROM phieco_taxcategory eco WHERE eco.phieco_taxcategory_id = product_co11_.em_phieco_deee ),0) * product_co11_.em_phieco_deee_qty) AS col_61_0_, product3_.EM_Phieco_Dea AS col_62_0_, product3_.EM_Phieco_Deee AS col_63_0_, product3_.EM_Obmupc_Multiupc_Desc AS col_64_0_, (SELECT obpos_prin13_.Template_Path FROM OBPOS_Print_Template obpos_prin13_ WHERE product3_.EM_Obpgc_Printtemplate_Id=obpos_prin13_.Obpos_Print_Template_ID) AS col_65_0_, product3_.EM_Obpgc_Printcard AS col_66_0_, (SELECT obpos_prin14_.Ispdf FROM OBPOS_Print_Template obpos_prin14_ WHERE product3_.EM_Obpgc_Printtemplate_Id=obpos_prin14_.Obpos_Print_Template_ID) AS col_67_0_, (SELECT obpos_prin15_.Printer FROM OBPOS_Print_Template obpos_prin15_ WHERE product3_.EM_Obpgc_Printtemplate_Id=obpos_prin15_.Obpos_Print_Template_ID) AS col_68_0_, product3_.EM_Obgcne_Expirationdays AS col_69_0_, product3_.EM_Gcnv_Giftcardtype AS col_70_0_, product3_.EM_Gcnv_Amount AS col_71_0_ FROM OBRETCO_Prol_Product obretco_pr0_ LEFT OUTER JOIN M_Product product1_ ON obretco_pr0_.M_Product_ID=product1_.M_Product_ID LEFT OUTER JOIN AD_Image adimage2_ ON product1_.AD_Image_ID=adimage2_.AD_Image_ID INNER JOIN M_Product product3_ ON obretco_pr0_.M_Product_ID=product3_.M_Product_ID LEFT OUTER JOIN M_AttributeSet attributes4_ ON product3_.M_AttributeSet_ID=attributes4_.M_AttributeSet_ID INNER JOIN M_ProductPrice pricingpro5_ ON product3_.M_Product_ID=pricingpro5_.M_Product_ID CROSS JOIN C_UOM uom9_ CROSS JOIN M_Product product_co11_ WHERE product3_.C_UOM_ID=uom9_.C_UOM_ID AND product3_.M_Product_ID=product_co11_.M_Product_ID AND 1=1 AND 1=1 AND 1=1 AND obretco_pr0_.Obretco_Productlist_ID='C06EAFD88D824598988B59E197F7B5C3' AND pricingpro5_.M_PriceList_Version_ID='7749C48ADC184AFDB11602527908782D' AND (product3_.Updated>'2020-08-26 11:07:23.994' OR obretco_pr0_.Updated>'2020-08-26 11:07:23.994' OR pricingpro5_.Updated>'2020-08-26 11:07:23.994' OR uom9_.Updated>'2020-08-26 11:07:23.994') ORDER BY product3_.M_Product_ID LIMIT 50000