select 
  product0_.M_Product_ID as m_produc1_474_, 
  product0_.AD_Client_ID as ad_clien2_474_, 
  product0_.AD_Org_ID as ad_org_i3_474_, 
  product0_.IsActive as isactive4_474_, 
  product0_.Created as created5_474_, 
  product0_.CreatedBy as createdb6_474_, 
  product0_.Updated as updated7_474_, 
  product0_.UpdatedBy as updatedb8_474_, 
  product0_.Value as value9_474_, 
  product0_.Name as name10_474_, 
  product0_.Description as descrip11_474_, 
  product0_.DocumentNote as documen12_474_, 
  product0_.Help as help13_474_, 
  product0_.UPC as upc14_474_, 
  product0_.SKU as sku15_474_, 
  product0_.C_UOM_ID as c_uom_i16_474_, 
  product0_.SalesRep_ID as salesre17_474_, 
  product0_.IsSummary as issumma18_474_, 
  product0_.IsStocked as isstock19_474_, 
  product0_.IsPurchased as ispurch20_474_, 
  product0_.IsSold as issold21_474_, 
  product0_.IsBOM as isbom22_474_, 
  product0_.IsInvoicePrintDetails as isinvoi23_474_, 
  product0_.IsPickListPrintDetails as ispickl24_474_, 
  product0_.IsVerified as isverif25_474_, 
  product0_.M_Product_Category_ID as m_produ26_474_, 
  product0_.Classification as classif27_474_, 
  product0_.Volume as volume28_474_, 
  product0_.Weight as weight29_474_, 
  product0_.ShelfWidth as shelfwi30_474_, 
  product0_.ShelfHeight as shelfhe31_474_, 
  product0_.ShelfDepth as shelfde32_474_, 
  product0_.UnitsPerPallet as unitspe33_474_, 
  product0_.C_TaxCategory_ID as c_taxca34_474_, 
  product0_.S_Resource_ID as s_resou35_474_, 
  product0_.Discontinued as discont36_474_, 
  product0_.DiscontinuedBy as discont37_474_, 
  product0_.Processing as process38_474_, 
  product0_.S_ExpenseType_ID as s_expen39_474_, 
  product0_.ProductType as product40_474_, 
  product0_.ImageURL as imageur41_474_, 
  product0_.DescriptionURL as descrip42_474_, 
  product0_.GuaranteeDays as guarant43_474_, 
  product0_.VersionNo as version44_474_, 
  product0_.M_AttributeSet_ID as m_attri45_474_, 
  product0_.M_AttributeSetInstance_ID as m_attri46_474_, 
  product0_.DownloadURL as downloa47_474_, 
  product0_.M_FreightCategory_ID as m_freig48_474_, 
  product0_.M_Locator_ID as m_locat49_474_, 
  product0_.AD_Image_ID as ad_imag50_474_, 
  product0_.C_BPartner_ID as c_bpart51_474_, 
  product0_.Ispriceprinted as isprice52_474_, 
  product0_.Name2 as name53_474_, 
  product0_.Stock_Min as stock_m54_474_, 
  product0_.Enforce_Attribute as enforce55_474_, 
  product0_.Calculated as calcula56_474_, 
  product0_.MA_Processplan_ID as ma_proc57_474_, 
  product0_.Production as product58_474_, 
  product0_.Capacity as capacit59_474_, 
  product0_.Delaymin as delaymi60_474_, 
  product0_.MRP_Planner_ID as mrp_pla61_474_, 
  product0_.MRP_Planningmethod_ID as mrp_pla62_474_, 
  product0_.Qtymax as qtymax63_474_, 
  product0_.Qtymin as qtymin64_474_, 
  product0_.Qtystd as qtystd65_474_, 
  product0_.Qtytype as qtytype66_474_, 
  product0_.Stockmin as stockmi67_474_, 
  product0_.Attrsetvaluetype as attrset68_474_, 
  product0_.Isquantityvariable as isquant69_474_, 
  product0_.Isdeferredrevenue as isdefer70_474_, 
  product0_.Revplantype as revplan71_474_, 
  product0_.Periodnumber as periodn72_474_, 
  product0_.Isdeferredexpense as isdefer73_474_, 
  product0_.Expplantype as expplan74_474_, 
  product0_.Periodnumber_Exp as periodn75_474_, 
  product0_.DefaultPeriod as default76_474_, 
  product0_.DefaultPeriod_Exp as default77_474_, 
  product0_.Bookusingpoprice as bookusi78_474_, 
  product0_.C_Uom_Weight_ID as c_uom_w79_474_, 
  product0_.M_Brand_ID as m_brand80_474_, 
  product0_.IsGeneric as isgener81_474_, 
  product0_.Generic_Product_ID as generic82_474_, 
  product0_.CreateVariants as createv83_474_, 
  product0_.Characteristic_Desc as charact84_474_, 
  product0_.Updateinvariants as updatei85_474_, 
  product0_.ManageVariants as managev86_474_, 
  product0_.Prod_Cat_Selection as prod_ca87_474_, 
  product0_.Product_Selection as product88_474_, 
  product0_.Print_Description as print_d89_474_, 
  product0_.Returnable as returna90_474_, 
  product0_.Overdue_Return_Days as overdue91_474_, 
  product0_.Ispricerulebased as isprice92_474_, 
  product0_.Unique_Per_Document as unique_93_474_, 
  product0_.Relateprodcattoservice as relatep94_474_, 
  product0_.Relateprodtoservice as relatep95_474_, 
  product0_.Islinkedtoproduct as islinke96_474_, 
  product0_.Quantity_Rule as quantit97_474_, 
  product0_.Allow_Deferred_Sell as allow_d98_474_, 
  product0_.Deferred_Sell_Max_Days as deferre99_474_, 
  product0_.M_Product_Status_ID as m_prod100_474_, 
  product0_.Ismodifytax as ismodi101_474_, 
  product0_.EM_OBAWO_Locator_Grp_List_ID as em_oba102_474_, 
  product0_.Relateprodcattaxtoservice as relate103_474_, 
  product0_.Copyservicemodifytaxconfig as copyse104_474_, 
  product0_.EM_Obawo_Deviation_Inspection as em_oba105_474_, 
  product0_.EM_Obpos_Scale as em_obp106_474_, 
  product0_.M_Product_Subtype_ID as m_prod107_474_, 
  product0_.EM_Obpos_Groupedproduct as em_obp108_474_, 
  product0_.row_characteristic as row_ch109_474_, 
  product0_.column_characteristic as column110_474_, 
  product0_.EM_Obpos_Showstock as em_obp111_474_, 
  product0_.EM_Obdest_Enabled as em_obd112_474_, 
  product0_.EM_Obpos_Show_Ch_Desc as em_obp113_474_, 
  product0_.EM_Obdest_Rcharacteristic as em_obd114_474_, 
  product0_.EM_Obpos_Proposal_Type as em_obp115_474_, 
  product0_.EM_Obdest_Ccharacteristic as em_obd116_474_, 
  product0_.EM_Obpos_Ismultiselectable as em_obp117_474_, 
  product0_.EM_OBPOS_AllowAnonymousSale as em_obp118_474_, 
  product0_.EM_Obpos_Printservices as em_obp119_474_, 
  product0_.EM_Obpos_Editable_Price as em_obp120_474_, 
  product0_.EM_Obrdm_Delivery_Mode as em_obr121_474_, 
  product0_.EM_Obrdm_Delivery_Mode_Lyw as em_obr122_474_, 
  product0_.EM_Obrdm_Isdeliveryservice as em_obr123_474_, 
  product0_.EM_Gcnv_Giftcardtype as em_gcn124_474_, 
  product0_.EM_Gcnv_Amount as em_gcn125_474_, 
  product0_.EM_Gcnv_Allowpartialreturn as em_gcn126_474_, 
  product0_.EM_Obpos_Maxpriceassocprod as em_obp127_474_, 
  product0_.EM_Obgcne_Expirationdays as em_obg128_474_, 
  product0_.EM_Obpos_Minpriceassocprod as em_obp129_474_, 
  product0_.EM_Obpgc_Printcard as em_obp130_474_, 
  product0_.EM_Obpgc_Printtemplate_Id as em_obp131_474_, 
  product0_.EM_Obpos2_No_Standard_Sale as em_obp132_474_, 
  product0_.EM_Obpos2_Imageclass as em_obp133_474_, 
  product0_.EM_Obpos2_Color_ID as em_obp134_474_, 
  product0_.EM_Obpos_Skipapplypromotions as em_obp135_474_, 
  product0_.EM_Obpos2_Pickupptype_ID as em_obp136_474_, 
  product0_.EM_Obpos2_Deliveryctype_ID as em_obp137_474_, 
  product0_.EM_Obpos2_Notificationptype_ID as em_obp138_474_, 
  product0_.EM_Obpos2_Pim_Url as em_obp139_474_, 
  product0_.characteristicDimensionEnabled as charac140_474_, 
  product0_.EM_Obmupc_Multiupc_Desc as em_obm141_474_, 
  product0_.EM_Obserpr_Required_Followup as em_obs142_474_, 
  product0_.EM_Gcnv_Discountsrestricted as em_gcn143_474_, 
  product0_.EM_Epa_Productcategory as em_epa144_474_, 
  product0_.EM_Etxf_Iselegible as em_etx145_474_, 
  product0_.EM_Gcnv_Aspaymentmethod as em_gcn146_474_, 
  product0_.EM_Gcnv_Taxablegiftcard as em_gcn147_474_, 
  product0_.EM_Obpgc_Printtempemail_ID as em_obp148_474_, 
  product0_.EM_Obpgc_Useautomaticseq as em_obp149_474_, 
  product0_.EM_Obfi_Ingredients_Allergens as em_obf150_474_, 
  product0_.EM_Obfi_Nutritional_Info as em_obf151_474_, 
  product0_.EM_Gcnv_Giftcardextradays as em_gcn152_474_, 
  product0_.EM_Obfi_Storage_Instructions as em_obf153_474_, 
  product0_.Special_Use as specia154_474_, 
  product0_.EM_OBCOMBO_Discount_Link as em_obc155_474_, 
  product0_.EM_Obpos_Salesunitfactor as em_obp156_474_, 
  product0_.EM_OBDISC_Pack_Discount_Link as em_obd157_474_, 
  product0_.Isgeneratevariantean as isgene158_474_, 
  product0_.EM_Obpos2_Isotf as em_obp159_474_, 
  product0_.EM_Obpos2_Request_Price as em_obp160_474_, 
  product0_.AD_Sequence_ID as ad_seq161_474_, 
  product0_.EM_Gcnv_Redemptiontype as em_gcn162_474_ 
from 
  M_Product product0_ 
  left outer join M_Product_Ch_Value productcha1_ on product0_.M_Product_ID = productcha1_.M_Product_ID 
  and (
    productcha1_.M_Characteristic_ID = ?
  ) 
  left outer join M_Ch_Value characteri2_ on productcha1_.M_Ch_Value_ID = characteri2_.M_Ch_Value_ID 
  left outer join AD_TreeNode adtreenode3_ on (
    adtreenode3_.Node_ID = characteri2_.M_Ch_Value_ID
  ) 
  left outer join M_Product_Ch_Value productcha4_ on product0_.M_Product_ID = productcha4_.M_Product_ID 
  and (
    productcha4_.M_Characteristic_ID = ?
  ) 
  left outer join M_Ch_Value characteri5_ on productcha4_.M_Ch_Value_ID = characteri5_.M_Ch_Value_ID 
  left outer join AD_TreeNode adtreenode6_ on (
    adtreenode6_.Node_ID = characteri5_.M_Ch_Value_ID
  ) 
where 
  (
    product0_.AD_Org_ID in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
  ) 
  and (
    product0_.AD_Client_ID in (?, ?)
  ) 
order by 
  product0_.Value, 
  product0_.M_Product_ID 
limit 
  ?