SELECTp0_.idASid_0,p0_.type_tiersAStype_tiers_1,p0_.enseigne_prospectASenseigne_prospect_2,p0_.nomASnom_3,p0_.prenomASprenom_4,p0_.emailASemail_5,p0_.phoneASphone_6,p0_.created_atAScreated_at_7,p0_.statusASstatus_8,p0_.scoreASscore_9,p0_.pipeline_statusASpipeline_status_10,AsBinary(p0_.location) ASlocation_11,p0_.latitudeASlatitude_12,p0_.longitudeASlongitude_13,p0_.adresse_prospectASadresse_prospect_14,p0_.code_enseigneAScode_enseigne_15,p0_.code_agentAScode_agent_16,p0_.ifu_prospectASifu_prospect_17,p0_.civilite_prospectAScivilite_prospect_18,p0_.agent_nomASagent_nom_19,p0_.agent_prenomASagent_prenom_20,p0_.agent_photoASagent_photo_21,p0_.tva_assujAStva_assuj_22,p0_.code_prospectAScode_prospect_23,p0_.barcodeASbarcode_24,p0_.selected_pack_idASselected_pack_id_25,p0_.estimated_revenueASestimated_revenue_26,p0_.note_publiqueASnote_publique_27,p0_.note_priveeASnote_privee_28,p0_.is_convertedASis_converted_29,p0_.conversion_pack_idASconversion_pack_id_30,p0_.converted_atASconverted_at_31,p0_.agent_uuidASagent_uuid_32,p0_.enseigne_idASenseigne_id_33,p0_.campaign_idAScampaign_id_34,p0_.temperature_idAStemperature_id_35,p0_.converted_by_idASconverted_by_id_36FROMprospectionsp0_WHERE (p0_.agent_uuid=?) AND (p0_.code_enseigne='YLWE') ORDER BYp0_.created_atDESC
SELECTp0_.idASid_0,p0_.type_tiersAStype_tiers_1,p0_.enseigne_prospectASenseigne_prospect_2,p0_.nomASnom_3,p0_.prenomASprenom_4,p0_.emailASemail_5,p0_.phoneASphone_6,p0_.created_atAScreated_at_7,p0_.statusASstatus_8,p0_.scoreASscore_9,p0_.pipeline_statusASpipeline_status_10,AsBinary(p0_.location) ASlocation_11,p0_.latitudeASlatitude_12,p0_.longitudeASlongitude_13,p0_.adresse_prospectASadresse_prospect_14,p0_.code_enseigneAScode_enseigne_15,p0_.code_agentAScode_agent_16,p0_.ifu_prospectASifu_prospect_17,p0_.civilite_prospectAScivilite_prospect_18,p0_.agent_nomASagent_nom_19,p0_.agent_prenomASagent_prenom_20,p0_.agent_photoASagent_photo_21,p0_.tva_assujAStva_assuj_22,p0_.code_prospectAScode_prospect_23,p0_.barcodeASbarcode_24,p0_.selected_pack_idASselected_pack_id_25,p0_.estimated_revenueASestimated_revenue_26,p0_.note_publiqueASnote_publique_27,p0_.note_priveeASnote_privee_28,p0_.is_convertedASis_converted_29,p0_.conversion_pack_idASconversion_pack_id_30,p0_.converted_atASconverted_at_31,p0_.agent_uuidASagent_uuid_32,p0_.enseigne_idASenseigne_id_33,p0_.campaign_idAScampaign_id_34,p0_.temperature_idAStemperature_id_35,p0_.converted_by_idASconverted_by_id_36FROMprospectionsp0_WHERE
(p0_.agent_uuid=?)
AND (p0_.code_enseigne='YLWE')
ORDER BYp0_.created_atDESC
SELECTp0_.idASid_0,p0_.type_tiersAStype_tiers_1,p0_.enseigne_prospectASenseigne_prospect_2,p0_.nomASnom_3,p0_.prenomASprenom_4,p0_.emailASemail_5,p0_.phoneASphone_6,p0_.created_atAScreated_at_7,p0_.statusASstatus_8,p0_.scoreASscore_9,p0_.pipeline_statusASpipeline_status_10,AsBinary(p0_.location) ASlocation_11,p0_.latitudeASlatitude_12,p0_.longitudeASlongitude_13,p0_.adresse_prospectASadresse_prospect_14,p0_.code_enseigneAScode_enseigne_15,p0_.code_agentAScode_agent_16,p0_.ifu_prospectASifu_prospect_17,p0_.civilite_prospectAScivilite_prospect_18,p0_.agent_nomASagent_nom_19,p0_.agent_prenomASagent_prenom_20,p0_.agent_photoASagent_photo_21,p0_.tva_assujAStva_assuj_22,p0_.code_prospectAScode_prospect_23,p0_.barcodeASbarcode_24,p0_.selected_pack_idASselected_pack_id_25,p0_.estimated_revenueASestimated_revenue_26,p0_.note_publiqueASnote_publique_27,p0_.note_priveeASnote_privee_28,p0_.is_convertedASis_converted_29,p0_.conversion_pack_idASconversion_pack_id_30,p0_.converted_atASconverted_at_31,p0_.agent_uuidASagent_uuid_32,p0_.enseigne_idASenseigne_id_33,p0_.campaign_idAScampaign_id_34,p0_.temperature_idAStemperature_id_35,p0_.converted_by_idASconverted_by_id_36FROMprospectionsp0_WHERE (p0_.agent_uuid='b3e2a1b1-0824-4ce3-a1f1-12f7ae0a81dd') AND (p0_.code_enseigne='YLWE') ORDER BYp0_.created_atDESC;