SELECTr0_.idASid_0,r0_.nameASname_1,r0_.addressASaddress_2,r0_.zipcodeASzipcode_3,r0_.cityAScity_4,r0_.phoneASphone_5,r0_.emailASemail_6,r0_.siretASsiret_7,r0_.tva_numberAStva_number_8,r0_.created_atAScreated_at_9,r0_.typeAStype_10,r0_.statusASstatus_11,r0_.commercial_zoneAScommercial_zone_12,r0_.countryAScountry_13,r0_.verify_by_bdASverify_by_bd_14,r0_.verify_by_naASverify_by_na_15,r0_.verify_by_rlASverify_by_rl_16,r0_.admin_commentASadmin_comment_17,r0_.closeASclose_18,r0_.type_profileAStype_profile_19,r0_.reseauASreseau_20,r0_.groupeASgroupe_21,r0_.importedASimported_22,r0_.sap_codeASsap_code_23,r0_.activity_idASactivity_id_24,r0_.rachat_matiere_idASrachat_matiere_id_25,r0_.network_idASnetwork_id_26,r0_.retailer_group_idASretailer_group_id_27FROMretailerr0_WHEREr0_.status=?ANDr0_.idIN (?) ORDER BYr0_.nameASC
SELECTr0_.idASid_0,r0_.nameASname_1,r0_.addressASaddress_2,r0_.zipcodeASzipcode_3,r0_.cityAScity_4,r0_.phoneASphone_5,r0_.emailASemail_6,r0_.siretASsiret_7,r0_.tva_numberAStva_number_8,r0_.created_atAScreated_at_9,r0_.typeAStype_10,r0_.statusASstatus_11,r0_.commercial_zoneAScommercial_zone_12,r0_.countryAScountry_13,r0_.verify_by_bdASverify_by_bd_14,r0_.verify_by_naASverify_by_na_15,r0_.verify_by_rlASverify_by_rl_16,r0_.admin_commentASadmin_comment_17,r0_.closeASclose_18,r0_.type_profileAStype_profile_19,r0_.reseauASreseau_20,r0_.groupeASgroupe_21,r0_.importedASimported_22,r0_.sap_codeASsap_code_23,r0_.activity_idASactivity_id_24,r0_.rachat_matiere_idASrachat_matiere_id_25,r0_.network_idASnetwork_id_26,r0_.retailer_group_idASretailer_group_id_27FROMretailerr0_WHEREr0_.status=?ANDr0_.idIN (?)
ORDER BYr0_.nameASC
SELECTr0_.idASid_0,r0_.nameASname_1,r0_.addressASaddress_2,r0_.zipcodeASzipcode_3,r0_.cityAScity_4,r0_.phoneASphone_5,r0_.emailASemail_6,r0_.siretASsiret_7,r0_.tva_numberAStva_number_8,r0_.created_atAScreated_at_9,r0_.typeAStype_10,r0_.statusASstatus_11,r0_.commercial_zoneAScommercial_zone_12,r0_.countryAScountry_13,r0_.verify_by_bdASverify_by_bd_14,r0_.verify_by_naASverify_by_na_15,r0_.verify_by_rlASverify_by_rl_16,r0_.admin_commentASadmin_comment_17,r0_.closeASclose_18,r0_.type_profileAStype_profile_19,r0_.reseauASreseau_20,r0_.groupeASgroupe_21,r0_.importedASimported_22,r0_.sap_codeASsap_code_23,r0_.activity_idASactivity_id_24,r0_.rachat_matiere_idASrachat_matiere_id_25,r0_.network_idASnetwork_id_26,r0_.retailer_group_idASretailer_group_id_27FROMretailerr0_WHEREr0_.status=1ANDr0_.idIN ('4949') ORDER BYr0_.nameASC;
SELECTr0_.idASid_0,r0_.nameASname_1,r0_.addressASaddress_2,r0_.zipcodeASzipcode_3,r0_.cityAScity_4,r0_.phoneASphone_5,r0_.emailASemail_6,r0_.siretASsiret_7,r0_.tva_numberAStva_number_8,r0_.created_atAScreated_at_9,r0_.typeAStype_10,r0_.statusASstatus_11,r0_.commercial_zoneAScommercial_zone_12,r0_.countryAScountry_13,r0_.verify_by_bdASverify_by_bd_14,r0_.verify_by_naASverify_by_na_15,r0_.verify_by_rlASverify_by_rl_16,r0_.admin_commentASadmin_comment_17,r0_.closeASclose_18,r0_.type_profileAStype_profile_19,r0_.reseauASreseau_20,r0_.groupeASgroupe_21,r0_.importedASimported_22,r0_.sap_codeASsap_code_23,r0_.activity_idASactivity_id_24,r0_.rachat_matiere_idASrachat_matiere_id_25,r0_.network_idASnetwork_id_26,r0_.retailer_group_idASretailer_group_id_27FROMretailerr0_WHEREr0_.activity_id=?ANDr0_.idIN (?) ORDER BYr0_.nameASC
SELECTr0_.idASid_0,r0_.nameASname_1,r0_.addressASaddress_2,r0_.zipcodeASzipcode_3,r0_.cityAScity_4,r0_.phoneASphone_5,r0_.emailASemail_6,r0_.siretASsiret_7,r0_.tva_numberAStva_number_8,r0_.created_atAScreated_at_9,r0_.typeAStype_10,r0_.statusASstatus_11,r0_.commercial_zoneAScommercial_zone_12,r0_.countryAScountry_13,r0_.verify_by_bdASverify_by_bd_14,r0_.verify_by_naASverify_by_na_15,r0_.verify_by_rlASverify_by_rl_16,r0_.admin_commentASadmin_comment_17,r0_.closeASclose_18,r0_.type_profileAStype_profile_19,r0_.reseauASreseau_20,r0_.groupeASgroupe_21,r0_.importedASimported_22,r0_.sap_codeASsap_code_23,r0_.activity_idASactivity_id_24,r0_.rachat_matiere_idASrachat_matiere_id_25,r0_.network_idASnetwork_id_26,r0_.retailer_group_idASretailer_group_id_27FROMretailerr0_WHEREr0_.activity_id=?ANDr0_.idIN (?)
ORDER BYr0_.nameASC
SELECTr0_.idASid_0,r0_.nameASname_1,r0_.addressASaddress_2,r0_.zipcodeASzipcode_3,r0_.cityAScity_4,r0_.phoneASphone_5,r0_.emailASemail_6,r0_.siretASsiret_7,r0_.tva_numberAStva_number_8,r0_.created_atAScreated_at_9,r0_.typeAStype_10,r0_.statusASstatus_11,r0_.commercial_zoneAScommercial_zone_12,r0_.countryAScountry_13,r0_.verify_by_bdASverify_by_bd_14,r0_.verify_by_naASverify_by_na_15,r0_.verify_by_rlASverify_by_rl_16,r0_.admin_commentASadmin_comment_17,r0_.closeASclose_18,r0_.type_profileAStype_profile_19,r0_.reseauASreseau_20,r0_.groupeASgroupe_21,r0_.importedASimported_22,r0_.sap_codeASsap_code_23,r0_.activity_idASactivity_id_24,r0_.rachat_matiere_idASrachat_matiere_id_25,r0_.network_idASnetwork_id_26,r0_.retailer_group_idASretailer_group_id_27FROMretailerr0_WHEREr0_.activity_id=14ANDr0_.idIN ('5284') ORDER BYr0_.nameASC;
SELECTm0_.idASid_0,m0_.nameASname_1,m0_.activeASactive_2,m0_.positionASposition_3,m0_.is_vracASis_vrac_4,m0_.always_badASalways_bad_5,m0_.created_atAScreated_at_6,m0_.parent_idASparent_id_7FROMmaterial_typem0_WHEREm0_.active=?ANDm0_.idIN (?) ORDER BYm0_.parent_idASC,m0_.positionASC,m0_.nameASC
SELECTm0_.idASid_0,m0_.nameASname_1,m0_.activeASactive_2,m0_.positionASposition_3,m0_.is_vracASis_vrac_4,m0_.always_badASalways_bad_5,m0_.created_atAScreated_at_6,m0_.parent_idASparent_id_7FROMmaterial_typem0_WHEREm0_.active=?ANDm0_.idIN (?)
ORDER BYm0_.parent_idASC,m0_.positionASC,m0_.nameASC
SELECTm0_.idASid_0,m0_.nameASname_1,m0_.activeASactive_2,m0_.positionASposition_3,m0_.is_vracASis_vrac_4,m0_.always_badASalways_bad_5,m0_.created_atAScreated_at_6,m0_.parent_idASparent_id_7FROMmaterial_typem0_WHEREm0_.active=1ANDm0_.idIN ('1') ORDER BYm0_.parent_idASC,m0_.positionASC,m0_.nameASC;