| 1 |
1.05 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.mail AS mail_3, t0.url AS url_4, t0.adresse AS adresse_5, t0.cp AS cp_6, t0.ville AS ville_7, t0.telephone AS telephone_8, t0.domain_activate AS domain_activate_9, t0.bAbonnementCalendrier AS bAbonnementCalendrier_10, t0.newsletterCouleur AS newsletterCouleur_11, t0.dateCreation AS dateCreation_12, t0.version AS version_13, t0.actuv2_token AS actuv2_token_14, t0.actuv2_referer AS actuv2_referer_15, t0.actuv2_widgetUrl AS actuv2_widgetUrl_16, t0.actuv2_colorPrimary AS actuv2_colorPrimary_17, t0.actuv2_colorSecondary AS actuv2_colorSecondary_18, t0.actuv2_urlContact AS actuv2_urlContact_19, t0.host AS host_20, t0.website_created_at AS website_created_at_21, t0.idsellsy AS idsellsy_22, t0.simulateur_token AS simulateur_token_23, t0.simulateur_widget_url AS simulateur_widget_url_24, t0.rgpd_token AS rgpd_token_25, t0.rgpd_widget_url AS rgpd_widget_url_26, t0.ce_token AS ce_token_27, t0.ce_widget_url AS ce_widget_url_28, t0.tous_en_ligne_token AS tous_en_ligne_token_29, t0.tous_en_ligne_widget_url AS tous_en_ligne_widget_url_30, t0.rgpd_sender AS rgpd_sender_31, t0.rgpd_sender_name AS rgpd_sender_name_32, t0.rgpd_expert_externe_use AS rgpd_expert_externe_use_33, t0.ce_sender AS ce_sender_34, t0.ce_sender_name AS ce_sender_name_35, t0.ce_expert_externe_use AS ce_expert_externe_use_36, t0.cir_sender AS cir_sender_37, t0.cir_sender_name AS cir_sender_name_38, t0.cir_expert_externe_use AS cir_expert_externe_use_39, t0.cir_token AS cir_token_40, t0.cir_widget_url AS cir_widget_url_41, t0.mailing_module AS mailing_module_42, t0.mailing_sender AS mailing_sender_43, t0.mailing_header AS mailing_header_44, t0.logo_cabinet AS logo_cabinet_45, t0.vcard_access AS vcard_access_46, t0.last_update AS last_update_47, t0.dark_theme AS dark_theme_48, t0.appelle_ton_ec_token AS appelle_ton_ec_token_49, t0.appelle_ton_ec_widget_url AS appelle_ton_ec_widget_url_50, t0.gmb_enable AS gmb_enable_51, t0.actuv2_not_ec AS actuv2_not_ec_52, t0.actuv2_only_podcast AS actuv2_only_podcast_53, t0.gmb_url AS gmb_url_54, t0.gmb_name AS gmb_name_55, t0.calendly_url AS calendly_url_56, t0.survey_client_requested AS survey_client_requested_57, t0.survey_client_activate AS survey_client_activate_58, t0.podcast_intro_filename AS podcast_intro_filename_59, t0.enable_podcast_private AS enable_podcast_private_60, t0.podcast_private_student AS podcast_private_student_61, t0.podcast_private_token AS podcast_private_token_62, t0.podcast_private_widget_url AS podcast_private_widget_url_63, t0.subscriber_podcast_private AS subscriber_podcast_private_64, t0.logo_pal_path AS logo_pal_path_65, t0.google_analytics_id AS google_analytics_id_66, t0.email_nl_actu_test AS email_nl_actu_test_67, t0.helpers_firms_token AS helpers_firms_token_68, t0.helpers_firms_widget_url AS helpers_firms_widget_url_69, t0.emailing_client_activate AS emailing_client_activate_70, t0.emailing_client_token_max AS emailing_client_token_max_71, t0.emailing_client_sender AS emailing_client_sender_72, t0.sms_client_activate AS sms_client_activate_73, t0.sms_client_credit_max AS sms_client_credit_max_74, t0.sms_client_sender AS sms_client_sender_75, t0.sms_client_sender_label AS sms_client_sender_label_76, t0.anniversaire_client_sender AS anniversaire_client_sender_77, t0.anniversaire_client_activate AS anniversaire_client_activate_78, t0.event_token AS event_token_79, t0.event_widget_url AS event_widget_url_80, t0.event_client_requested AS event_client_requested_81, t0.sponsorship_token AS sponsorship_token_82, t0.sponsorship_widget_url AS sponsorship_widget_url_83, t0.sponsorship_client_requested AS sponsorship_client_requested_84, t0.sponsorship_client_activate AS sponsorship_client_activate_85, t0.recommendation_token AS recommendation_token_86, t0.recommendation_widget_url AS recommendation_widget_url_87, t0.recommendation_client_requested AS recommendation_client_requested_88, t0.recommendation_client_activate AS recommendation_client_activate_89, t0.survey_token AS survey_token_90, t0.survey_widget_url AS survey_widget_url_91, t0.satisfaction_token AS satisfaction_token_92, t0.satisfaction_widget_url AS satisfaction_widget_url_93, t0.electronic_invoice_token AS electronic_invoice_token_94, t0.electronic_invoice_widget_url AS electronic_invoice_widget_url_95, t0.satisfaction_client_activate AS satisfaction_client_activate_96, t0.card_trello_event_create AS card_trello_event_create_97, t0.card_trello_satisfaction_create AS card_trello_satisfaction_create_98, t0.platform_enabled AS platform_enabled_99, t0.sepa_prelevement_date AS sepa_prelevement_date_100, t0.onboarding_replay_url AS onboarding_replay_url_101, t0.onboarding_replay_notified_at AS onboarding_replay_notified_at_102, t0.onboarding_replay_code AS onboarding_replay_code_103, t0.linkedin_username AS linkedin_username_104, t0.linkedin_password AS linkedin_password_105, t0.linkedin_password_updated_at AS linkedin_password_updated_at_106, t107.id AS id_108, t107.description AS description_109, t107.website AS website_110, t107.end_date_time AS end_date_time_111, t107.accounting_firm_id AS accounting_firm_id_112, t113.id AS id_114, t113.modules AS modules_115, t113.website_news_links AS website_news_links_116, t113.website_news_images AS website_news_images_117, t113.website_news_documents AS website_news_documents_118, t113.website_news_max_image_size AS website_news_max_image_size_119, t113.website_news_max_document_size AS website_news_max_document_size_120, t113.ebook_max_image_size AS ebook_max_image_size_121, t113.ebook_max_document_size AS ebook_max_document_size_122, t113.ebook_documents AS ebook_documents_123, t113.ebook_images AS ebook_images_124, t113.web_mail AS web_mail_125, t113.google_tag_manager AS google_tag_manager_126, t113.google_analytics AS google_analytics_127, t113.domain_type AS domain_type_128, t113.seo_meta_title AS seo_meta_title_129, t113.seo_meta_description AS seo_meta_description_130, t113.google_recaptcha_site_key AS google_recaptcha_site_key_131, t113.google_recaptcha_secret AS google_recaptcha_secret_132, t113.favicon AS favicon_133, t113.web_mail_recrutement AS web_mail_recrutement_134, t113.maintenance AS maintenance_135, t113.construction AS construction_136, t113.monetico_tpe AS monetico_tpe_137, t113.monetico_societe AS monetico_societe_138, t113.monetico_cle AS monetico_cle_139, t113.accounting_firm_id AS accounting_firm_id_140, t113.mailjetapi_id AS mailjetapi_id_141, t113.mailjetapi_recrutement_id AS mailjetapi_recrutement_id_142, t143.id AS id_144, t143.updated_at AS updated_at_145, t143.send_mail_acces_client_tmp AS send_mail_acces_client_tmp_146, t143.accounting_firm_id AS accounting_firm_id_147, t0.mailing_api_id AS mailing_api_id_148, t0.rgpd_expert_id AS rgpd_expert_id_149, t0.ce_expert_id AS ce_expert_id_150, t0.cir_expert_id AS cir_expert_id_151, t0.emailing_client_api_id AS emailing_client_api_id_152 FROM cabinet t0 LEFT JOIN primary_news t107 ON t107.accounting_firm_id = t0.id LEFT JOIN parameters t113 ON t113.accounting_firm_id = t0.id LEFT JOIN identite_visuelle t143 ON t143.accounting_firm_id = t0.id WHERE t0.host = ? LIMIT 1
Parameters: [
"vcard-frontdev.lagence.expert"
]
SELECT
t0.id AS id_1,
t0.nom AS nom_2,
t0.mail AS mail_3,
t0.url AS url_4,
t0.adresse AS adresse_5,
t0.cp AS cp_6,
t0.ville AS ville_7,
t0.telephone AS telephone_8,
t0.domain_activate AS domain_activate_9,
t0.bAbonnementCalendrier AS bAbonnementCalendrier_10,
t0.newsletterCouleur AS newsletterCouleur_11,
t0.dateCreation AS dateCreation_12,
t0.version AS version_13,
t0.actuv2_token AS actuv2_token_14,
t0.actuv2_referer AS actuv2_referer_15,
t0.actuv2_widgetUrl AS actuv2_widgetUrl_16,
t0.actuv2_colorPrimary AS actuv2_colorPrimary_17,
t0.actuv2_colorSecondary AS actuv2_colorSecondary_18,
t0.actuv2_urlContact AS actuv2_urlContact_19,
t0.host AS host_20,
t0.website_created_at AS website_created_at_21,
t0.idsellsy AS idsellsy_22,
t0.simulateur_token AS simulateur_token_23,
t0.simulateur_widget_url AS simulateur_widget_url_24,
t0.rgpd_token AS rgpd_token_25,
t0.rgpd_widget_url AS rgpd_widget_url_26,
t0.ce_token AS ce_token_27,
t0.ce_widget_url AS ce_widget_url_28,
t0.tous_en_ligne_token AS tous_en_ligne_token_29,
t0.tous_en_ligne_widget_url AS tous_en_ligne_widget_url_30,
t0.rgpd_sender AS rgpd_sender_31,
t0.rgpd_sender_name AS rgpd_sender_name_32,
t0.rgpd_expert_externe_use AS rgpd_expert_externe_use_33,
t0.ce_sender AS ce_sender_34,
t0.ce_sender_name AS ce_sender_name_35,
t0.ce_expert_externe_use AS ce_expert_externe_use_36,
t0.cir_sender AS cir_sender_37,
t0.cir_sender_name AS cir_sender_name_38,
t0.cir_expert_externe_use AS cir_expert_externe_use_39,
t0.cir_token AS cir_token_40,
t0.cir_widget_url AS cir_widget_url_41,
t0.mailing_module AS mailing_module_42,
t0.mailing_sender AS mailing_sender_43,
t0.mailing_header AS mailing_header_44,
t0.logo_cabinet AS logo_cabinet_45,
t0.vcard_access AS vcard_access_46,
t0.last_update AS last_update_47,
t0.dark_theme AS dark_theme_48,
t0.appelle_ton_ec_token AS appelle_ton_ec_token_49,
t0.appelle_ton_ec_widget_url AS appelle_ton_ec_widget_url_50,
t0.gmb_enable AS gmb_enable_51,
t0.actuv2_not_ec AS actuv2_not_ec_52,
t0.actuv2_only_podcast AS actuv2_only_podcast_53,
t0.gmb_url AS gmb_url_54,
t0.gmb_name AS gmb_name_55,
t0.calendly_url AS calendly_url_56,
t0.survey_client_requested AS survey_client_requested_57,
t0.survey_client_activate AS survey_client_activate_58,
t0.podcast_intro_filename AS podcast_intro_filename_59,
t0.enable_podcast_private AS enable_podcast_private_60,
t0.podcast_private_student AS podcast_private_student_61,
t0.podcast_private_token AS podcast_private_token_62,
t0.podcast_private_widget_url AS podcast_private_widget_url_63,
t0.subscriber_podcast_private AS subscriber_podcast_private_64,
t0.logo_pal_path AS logo_pal_path_65,
t0.google_analytics_id AS google_analytics_id_66,
t0.email_nl_actu_test AS email_nl_actu_test_67,
t0.helpers_firms_token AS helpers_firms_token_68,
t0.helpers_firms_widget_url AS helpers_firms_widget_url_69,
t0.emailing_client_activate AS emailing_client_activate_70,
t0.emailing_client_token_max AS emailing_client_token_max_71,
t0.emailing_client_sender AS emailing_client_sender_72,
t0.sms_client_activate AS sms_client_activate_73,
t0.sms_client_credit_max AS sms_client_credit_max_74,
t0.sms_client_sender AS sms_client_sender_75,
t0.sms_client_sender_label AS sms_client_sender_label_76,
t0.anniversaire_client_sender AS anniversaire_client_sender_77,
t0.anniversaire_client_activate AS anniversaire_client_activate_78,
t0.event_token AS event_token_79,
t0.event_widget_url AS event_widget_url_80,
t0.event_client_requested AS event_client_requested_81,
t0.sponsorship_token AS sponsorship_token_82,
t0.sponsorship_widget_url AS sponsorship_widget_url_83,
t0.sponsorship_client_requested AS sponsorship_client_requested_84,
t0.sponsorship_client_activate AS sponsorship_client_activate_85,
t0.recommendation_token AS recommendation_token_86,
t0.recommendation_widget_url AS recommendation_widget_url_87,
t0.recommendation_client_requested AS recommendation_client_requested_88,
t0.recommendation_client_activate AS recommendation_client_activate_89,
t0.survey_token AS survey_token_90,
t0.survey_widget_url AS survey_widget_url_91,
t0.satisfaction_token AS satisfaction_token_92,
t0.satisfaction_widget_url AS satisfaction_widget_url_93,
t0.electronic_invoice_token AS electronic_invoice_token_94,
t0.electronic_invoice_widget_url AS electronic_invoice_widget_url_95,
t0.satisfaction_client_activate AS satisfaction_client_activate_96,
t0.card_trello_event_create AS card_trello_event_create_97,
t0.card_trello_satisfaction_create AS card_trello_satisfaction_create_98,
t0.platform_enabled AS platform_enabled_99,
t0.sepa_prelevement_date AS sepa_prelevement_date_100,
t0.onboarding_replay_url AS onboarding_replay_url_101,
t0.onboarding_replay_notified_at AS onboarding_replay_notified_at_102,
t0.onboarding_replay_code AS onboarding_replay_code_103,
t0.linkedin_username AS linkedin_username_104,
t0.linkedin_password AS linkedin_password_105,
t0.linkedin_password_updated_at AS linkedin_password_updated_at_106,
t107.id AS id_108,
t107.description AS description_109,
t107.website AS website_110,
t107.end_date_time AS end_date_time_111,
t107.accounting_firm_id AS accounting_firm_id_112,
t113.id AS id_114,
t113.modules AS modules_115,
t113.website_news_links AS website_news_links_116,
t113.website_news_images AS website_news_images_117,
t113.website_news_documents AS website_news_documents_118,
t113.website_news_max_image_size AS website_news_max_image_size_119,
t113.website_news_max_document_size AS website_news_max_document_size_120,
t113.ebook_max_image_size AS ebook_max_image_size_121,
t113.ebook_max_document_size AS ebook_max_document_size_122,
t113.ebook_documents AS ebook_documents_123,
t113.ebook_images AS ebook_images_124,
t113.web_mail AS web_mail_125,
t113.google_tag_manager AS google_tag_manager_126,
t113.google_analytics AS google_analytics_127,
t113.domain_type AS domain_type_128,
t113.seo_meta_title AS seo_meta_title_129,
t113.seo_meta_description AS seo_meta_description_130,
t113.google_recaptcha_site_key AS google_recaptcha_site_key_131,
t113.google_recaptcha_secret AS google_recaptcha_secret_132,
t113.favicon AS favicon_133,
t113.web_mail_recrutement AS web_mail_recrutement_134,
t113.maintenance AS maintenance_135,
t113.construction AS construction_136,
t113.monetico_tpe AS monetico_tpe_137,
t113.monetico_societe AS monetico_societe_138,
t113.monetico_cle AS monetico_cle_139,
t113.accounting_firm_id AS accounting_firm_id_140,
t113.mailjetapi_id AS mailjetapi_id_141,
t113.mailjetapi_recrutement_id AS mailjetapi_recrutement_id_142,
t143.id AS id_144,
t143.updated_at AS updated_at_145,
t143.send_mail_acces_client_tmp AS send_mail_acces_client_tmp_146,
t143.accounting_firm_id AS accounting_firm_id_147,
t0.mailing_api_id AS mailing_api_id_148,
t0.rgpd_expert_id AS rgpd_expert_id_149,
t0.ce_expert_id AS ce_expert_id_150,
t0.cir_expert_id AS cir_expert_id_151,
t0.emailing_client_api_id AS emailing_client_api_id_152
FROM
cabinet t0
LEFT JOIN primary_news t107 ON t107.accounting_firm_id = t0.id
LEFT JOIN parameters t113 ON t113.accounting_firm_id = t0.id
LEFT JOIN identite_visuelle t143 ON t143.accounting_firm_id = t0.id
WHERE
t0.host = ?
LIMIT
1
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.mail AS mail_3, t0.url AS url_4, t0.adresse AS adresse_5, t0.cp AS cp_6, t0.ville AS ville_7, t0.telephone AS telephone_8, t0.domain_activate AS domain_activate_9, t0.bAbonnementCalendrier AS bAbonnementCalendrier_10, t0.newsletterCouleur AS newsletterCouleur_11, t0.dateCreation AS dateCreation_12, t0.version AS version_13, t0.actuv2_token AS actuv2_token_14, t0.actuv2_referer AS actuv2_referer_15, t0.actuv2_widgetUrl AS actuv2_widgetUrl_16, t0.actuv2_colorPrimary AS actuv2_colorPrimary_17, t0.actuv2_colorSecondary AS actuv2_colorSecondary_18, t0.actuv2_urlContact AS actuv2_urlContact_19, t0.host AS host_20, t0.website_created_at AS website_created_at_21, t0.idsellsy AS idsellsy_22, t0.simulateur_token AS simulateur_token_23, t0.simulateur_widget_url AS simulateur_widget_url_24, t0.rgpd_token AS rgpd_token_25, t0.rgpd_widget_url AS rgpd_widget_url_26, t0.ce_token AS ce_token_27, t0.ce_widget_url AS ce_widget_url_28, t0.tous_en_ligne_token AS tous_en_ligne_token_29, t0.tous_en_ligne_widget_url AS tous_en_ligne_widget_url_30, t0.rgpd_sender AS rgpd_sender_31, t0.rgpd_sender_name AS rgpd_sender_name_32, t0.rgpd_expert_externe_use AS rgpd_expert_externe_use_33, t0.ce_sender AS ce_sender_34, t0.ce_sender_name AS ce_sender_name_35, t0.ce_expert_externe_use AS ce_expert_externe_use_36, t0.cir_sender AS cir_sender_37, t0.cir_sender_name AS cir_sender_name_38, t0.cir_expert_externe_use AS cir_expert_externe_use_39, t0.cir_token AS cir_token_40, t0.cir_widget_url AS cir_widget_url_41, t0.mailing_module AS mailing_module_42, t0.mailing_sender AS mailing_sender_43, t0.mailing_header AS mailing_header_44, t0.logo_cabinet AS logo_cabinet_45, t0.vcard_access AS vcard_access_46, t0.last_update AS last_update_47, t0.dark_theme AS dark_theme_48, t0.appelle_ton_ec_token AS appelle_ton_ec_token_49, t0.appelle_ton_ec_widget_url AS appelle_ton_ec_widget_url_50, t0.gmb_enable AS gmb_enable_51, t0.actuv2_not_ec AS actuv2_not_ec_52, t0.actuv2_only_podcast AS actuv2_only_podcast_53, t0.gmb_url AS gmb_url_54, t0.gmb_name AS gmb_name_55, t0.calendly_url AS calendly_url_56, t0.survey_client_requested AS survey_client_requested_57, t0.survey_client_activate AS survey_client_activate_58, t0.podcast_intro_filename AS podcast_intro_filename_59, t0.enable_podcast_private AS enable_podcast_private_60, t0.podcast_private_student AS podcast_private_student_61, t0.podcast_private_token AS podcast_private_token_62, t0.podcast_private_widget_url AS podcast_private_widget_url_63, t0.subscriber_podcast_private AS subscriber_podcast_private_64, t0.logo_pal_path AS logo_pal_path_65, t0.google_analytics_id AS google_analytics_id_66, t0.email_nl_actu_test AS email_nl_actu_test_67, t0.helpers_firms_token AS helpers_firms_token_68, t0.helpers_firms_widget_url AS helpers_firms_widget_url_69, t0.emailing_client_activate AS emailing_client_activate_70, t0.emailing_client_token_max AS emailing_client_token_max_71, t0.emailing_client_sender AS emailing_client_sender_72, t0.sms_client_activate AS sms_client_activate_73, t0.sms_client_credit_max AS sms_client_credit_max_74, t0.sms_client_sender AS sms_client_sender_75, t0.sms_client_sender_label AS sms_client_sender_label_76, t0.anniversaire_client_sender AS anniversaire_client_sender_77, t0.anniversaire_client_activate AS anniversaire_client_activate_78, t0.event_token AS event_token_79, t0.event_widget_url AS event_widget_url_80, t0.event_client_requested AS event_client_requested_81, t0.sponsorship_token AS sponsorship_token_82, t0.sponsorship_widget_url AS sponsorship_widget_url_83, t0.sponsorship_client_requested AS sponsorship_client_requested_84, t0.sponsorship_client_activate AS sponsorship_client_activate_85, t0.recommendation_token AS recommendation_token_86, t0.recommendation_widget_url AS recommendation_widget_url_87, t0.recommendation_client_requested AS recommendation_client_requested_88, t0.recommendation_client_activate AS recommendation_client_activate_89, t0.survey_token AS survey_token_90, t0.survey_widget_url AS survey_widget_url_91, t0.satisfaction_token AS satisfaction_token_92, t0.satisfaction_widget_url AS satisfaction_widget_url_93, t0.electronic_invoice_token AS electronic_invoice_token_94, t0.electronic_invoice_widget_url AS electronic_invoice_widget_url_95, t0.satisfaction_client_activate AS satisfaction_client_activate_96, t0.card_trello_event_create AS card_trello_event_create_97, t0.card_trello_satisfaction_create AS card_trello_satisfaction_create_98, t0.platform_enabled AS platform_enabled_99, t0.sepa_prelevement_date AS sepa_prelevement_date_100, t0.onboarding_replay_url AS onboarding_replay_url_101, t0.onboarding_replay_notified_at AS onboarding_replay_notified_at_102, t0.onboarding_replay_code AS onboarding_replay_code_103, t0.linkedin_username AS linkedin_username_104, t0.linkedin_password AS linkedin_password_105, t0.linkedin_password_updated_at AS linkedin_password_updated_at_106, t107.id AS id_108, t107.description AS description_109, t107.website AS website_110, t107.end_date_time AS end_date_time_111, t107.accounting_firm_id AS accounting_firm_id_112, t113.id AS id_114, t113.modules AS modules_115, t113.website_news_links AS website_news_links_116, t113.website_news_images AS website_news_images_117, t113.website_news_documents AS website_news_documents_118, t113.website_news_max_image_size AS website_news_max_image_size_119, t113.website_news_max_document_size AS website_news_max_document_size_120, t113.ebook_max_image_size AS ebook_max_image_size_121, t113.ebook_max_document_size AS ebook_max_document_size_122, t113.ebook_documents AS ebook_documents_123, t113.ebook_images AS ebook_images_124, t113.web_mail AS web_mail_125, t113.google_tag_manager AS google_tag_manager_126, t113.google_analytics AS google_analytics_127, t113.domain_type AS domain_type_128, t113.seo_meta_title AS seo_meta_title_129, t113.seo_meta_description AS seo_meta_description_130, t113.google_recaptcha_site_key AS google_recaptcha_site_key_131, t113.google_recaptcha_secret AS google_recaptcha_secret_132, t113.favicon AS favicon_133, t113.web_mail_recrutement AS web_mail_recrutement_134, t113.maintenance AS maintenance_135, t113.construction AS construction_136, t113.monetico_tpe AS monetico_tpe_137, t113.monetico_societe AS monetico_societe_138, t113.monetico_cle AS monetico_cle_139, t113.accounting_firm_id AS accounting_firm_id_140, t113.mailjetapi_id AS mailjetapi_id_141, t113.mailjetapi_recrutement_id AS mailjetapi_recrutement_id_142, t143.id AS id_144, t143.updated_at AS updated_at_145, t143.send_mail_acces_client_tmp AS send_mail_acces_client_tmp_146, t143.accounting_firm_id AS accounting_firm_id_147, t0.mailing_api_id AS mailing_api_id_148, t0.rgpd_expert_id AS rgpd_expert_id_149, t0.ce_expert_id AS ce_expert_id_150, t0.cir_expert_id AS cir_expert_id_151, t0.emailing_client_api_id AS emailing_client_api_id_152 FROM cabinet t0 LEFT JOIN primary_news t107 ON t107.accounting_firm_id = t0.id LEFT JOIN parameters t113 ON t113.accounting_firm_id = t0.id LEFT JOIN identite_visuelle t143 ON t143.accounting_firm_id = t0.id WHERE t0.host = 'vcard-frontdev.lagence.expert' LIMIT 1;
|
| 2 |
0.84 ms |
SELECT c0_.id AS id_0, c0_.nom AS nom_1, c0_.mail AS mail_2, c0_.url AS url_3, c0_.adresse AS adresse_4, c0_.cp AS cp_5, c0_.ville AS ville_6, c0_.telephone AS telephone_7, c0_.domain_activate AS domain_activate_8, c0_.bAbonnementCalendrier AS bAbonnementCalendrier_9, c0_.newsletterCouleur AS newsletterCouleur_10, c0_.dateCreation AS dateCreation_11, c0_.version AS version_12, c0_.actuv2_token AS actuv2_token_13, c0_.actuv2_referer AS actuv2_referer_14, c0_.actuv2_widgetUrl AS actuv2_widgetUrl_15, c0_.actuv2_colorPrimary AS actuv2_colorPrimary_16, c0_.actuv2_colorSecondary AS actuv2_colorSecondary_17, c0_.actuv2_urlContact AS actuv2_urlContact_18, c0_.host AS host_19, c0_.website_created_at AS website_created_at_20, c0_.idsellsy AS idsellsy_21, c0_.simulateur_token AS simulateur_token_22, c0_.simulateur_widget_url AS simulateur_widget_url_23, c0_.rgpd_token AS rgpd_token_24, c0_.rgpd_widget_url AS rgpd_widget_url_25, c0_.ce_token AS ce_token_26, c0_.ce_widget_url AS ce_widget_url_27, c0_.tous_en_ligne_token AS tous_en_ligne_token_28, c0_.tous_en_ligne_widget_url AS tous_en_ligne_widget_url_29, c0_.rgpd_sender AS rgpd_sender_30, c0_.rgpd_sender_name AS rgpd_sender_name_31, c0_.rgpd_expert_externe_use AS rgpd_expert_externe_use_32, c0_.ce_sender AS ce_sender_33, c0_.ce_sender_name AS ce_sender_name_34, c0_.ce_expert_externe_use AS ce_expert_externe_use_35, c0_.cir_sender AS cir_sender_36, c0_.cir_sender_name AS cir_sender_name_37, c0_.cir_expert_externe_use AS cir_expert_externe_use_38, c0_.cir_token AS cir_token_39, c0_.cir_widget_url AS cir_widget_url_40, c0_.mailing_module AS mailing_module_41, c0_.mailing_sender AS mailing_sender_42, c0_.mailing_header AS mailing_header_43, c0_.logo_cabinet AS logo_cabinet_44, c0_.vcard_access AS vcard_access_45, c0_.last_update AS last_update_46, c0_.dark_theme AS dark_theme_47, c0_.appelle_ton_ec_token AS appelle_ton_ec_token_48, c0_.appelle_ton_ec_widget_url AS appelle_ton_ec_widget_url_49, c0_.gmb_enable AS gmb_enable_50, c0_.actuv2_not_ec AS actuv2_not_ec_51, c0_.actuv2_only_podcast AS actuv2_only_podcast_52, c0_.gmb_url AS gmb_url_53, c0_.gmb_name AS gmb_name_54, c0_.calendly_url AS calendly_url_55, c0_.survey_client_requested AS survey_client_requested_56, c0_.survey_client_activate AS survey_client_activate_57, c0_.podcast_intro_filename AS podcast_intro_filename_58, c0_.enable_podcast_private AS enable_podcast_private_59, c0_.podcast_private_student AS podcast_private_student_60, c0_.podcast_private_token AS podcast_private_token_61, c0_.podcast_private_widget_url AS podcast_private_widget_url_62, c0_.subscriber_podcast_private AS subscriber_podcast_private_63, c0_.logo_pal_path AS logo_pal_path_64, c0_.google_analytics_id AS google_analytics_id_65, c0_.email_nl_actu_test AS email_nl_actu_test_66, c0_.helpers_firms_token AS helpers_firms_token_67, c0_.helpers_firms_widget_url AS helpers_firms_widget_url_68, c0_.emailing_client_activate AS emailing_client_activate_69, c0_.emailing_client_token_max AS emailing_client_token_max_70, c0_.emailing_client_sender AS emailing_client_sender_71, c0_.sms_client_activate AS sms_client_activate_72, c0_.sms_client_credit_max AS sms_client_credit_max_73, c0_.sms_client_sender AS sms_client_sender_74, c0_.sms_client_sender_label AS sms_client_sender_label_75, c0_.anniversaire_client_sender AS anniversaire_client_sender_76, c0_.anniversaire_client_activate AS anniversaire_client_activate_77, c0_.event_token AS event_token_78, c0_.event_widget_url AS event_widget_url_79, c0_.event_client_requested AS event_client_requested_80, c0_.sponsorship_token AS sponsorship_token_81, c0_.sponsorship_widget_url AS sponsorship_widget_url_82, c0_.sponsorship_client_requested AS sponsorship_client_requested_83, c0_.sponsorship_client_activate AS sponsorship_client_activate_84, c0_.recommendation_token AS recommendation_token_85, c0_.recommendation_widget_url AS recommendation_widget_url_86, c0_.recommendation_client_requested AS recommendation_client_requested_87, c0_.recommendation_client_activate AS recommendation_client_activate_88, c0_.survey_token AS survey_token_89, c0_.survey_widget_url AS survey_widget_url_90, c0_.satisfaction_token AS satisfaction_token_91, c0_.satisfaction_widget_url AS satisfaction_widget_url_92, c0_.electronic_invoice_token AS electronic_invoice_token_93, c0_.electronic_invoice_widget_url AS electronic_invoice_widget_url_94, c0_.satisfaction_client_activate AS satisfaction_client_activate_95, c0_.card_trello_event_create AS card_trello_event_create_96, c0_.card_trello_satisfaction_create AS card_trello_satisfaction_create_97, c0_.platform_enabled AS platform_enabled_98, c0_.sepa_prelevement_date AS sepa_prelevement_date_99, c0_.onboarding_replay_url AS onboarding_replay_url_100, c0_.onboarding_replay_notified_at AS onboarding_replay_notified_at_101, c0_.onboarding_replay_code AS onboarding_replay_code_102, c0_.linkedin_username AS linkedin_username_103, c0_.linkedin_password AS linkedin_password_104, c0_.linkedin_password_updated_at AS linkedin_password_updated_at_105, p1_.id AS id_106, p1_.modules AS modules_107, p1_.website_news_links AS website_news_links_108, p1_.website_news_images AS website_news_images_109, p1_.website_news_documents AS website_news_documents_110, p1_.website_news_max_image_size AS website_news_max_image_size_111, p1_.website_news_max_document_size AS website_news_max_document_size_112, p1_.ebook_max_image_size AS ebook_max_image_size_113, p1_.ebook_max_document_size AS ebook_max_document_size_114, p1_.ebook_documents AS ebook_documents_115, p1_.ebook_images AS ebook_images_116, p1_.web_mail AS web_mail_117, p1_.google_tag_manager AS google_tag_manager_118, p1_.google_analytics AS google_analytics_119, p1_.domain_type AS domain_type_120, p1_.seo_meta_title AS seo_meta_title_121, p1_.seo_meta_description AS seo_meta_description_122, p1_.google_recaptcha_site_key AS google_recaptcha_site_key_123, p1_.google_recaptcha_secret AS google_recaptcha_secret_124, p1_.favicon AS favicon_125, p1_.web_mail_recrutement AS web_mail_recrutement_126, p1_.maintenance AS maintenance_127, p1_.construction AS construction_128, p1_.monetico_tpe AS monetico_tpe_129, p1_.monetico_societe AS monetico_societe_130, p1_.monetico_cle AS monetico_cle_131, c0_.mailing_api_id AS mailing_api_id_132, c0_.rgpd_expert_id AS rgpd_expert_id_133, c0_.ce_expert_id AS ce_expert_id_134, c0_.cir_expert_id AS cir_expert_id_135, c0_.emailing_client_api_id AS emailing_client_api_id_136, p1_.accounting_firm_id AS accounting_firm_id_137, p1_.mailjetapi_id AS mailjetapi_id_138, p1_.mailjetapi_recrutement_id AS mailjetapi_recrutement_id_139 FROM cabinet c0_ LEFT JOIN parameters p1_ ON c0_.id = p1_.accounting_firm_id WHERE c0_.host = ?
Parameters: [
"vcard-frontdev.lagence.expert"
]
SELECT
c0_.id AS id_0,
c0_.nom AS nom_1,
c0_.mail AS mail_2,
c0_.url AS url_3,
c0_.adresse AS adresse_4,
c0_.cp AS cp_5,
c0_.ville AS ville_6,
c0_.telephone AS telephone_7,
c0_.domain_activate AS domain_activate_8,
c0_.bAbonnementCalendrier AS bAbonnementCalendrier_9,
c0_.newsletterCouleur AS newsletterCouleur_10,
c0_.dateCreation AS dateCreation_11,
c0_.version AS version_12,
c0_.actuv2_token AS actuv2_token_13,
c0_.actuv2_referer AS actuv2_referer_14,
c0_.actuv2_widgetUrl AS actuv2_widgetUrl_15,
c0_.actuv2_colorPrimary AS actuv2_colorPrimary_16,
c0_.actuv2_colorSecondary AS actuv2_colorSecondary_17,
c0_.actuv2_urlContact AS actuv2_urlContact_18,
c0_.host AS host_19,
c0_.website_created_at AS website_created_at_20,
c0_.idsellsy AS idsellsy_21,
c0_.simulateur_token AS simulateur_token_22,
c0_.simulateur_widget_url AS simulateur_widget_url_23,
c0_.rgpd_token AS rgpd_token_24,
c0_.rgpd_widget_url AS rgpd_widget_url_25,
c0_.ce_token AS ce_token_26,
c0_.ce_widget_url AS ce_widget_url_27,
c0_.tous_en_ligne_token AS tous_en_ligne_token_28,
c0_.tous_en_ligne_widget_url AS tous_en_ligne_widget_url_29,
c0_.rgpd_sender AS rgpd_sender_30,
c0_.rgpd_sender_name AS rgpd_sender_name_31,
c0_.rgpd_expert_externe_use AS rgpd_expert_externe_use_32,
c0_.ce_sender AS ce_sender_33,
c0_.ce_sender_name AS ce_sender_name_34,
c0_.ce_expert_externe_use AS ce_expert_externe_use_35,
c0_.cir_sender AS cir_sender_36,
c0_.cir_sender_name AS cir_sender_name_37,
c0_.cir_expert_externe_use AS cir_expert_externe_use_38,
c0_.cir_token AS cir_token_39,
c0_.cir_widget_url AS cir_widget_url_40,
c0_.mailing_module AS mailing_module_41,
c0_.mailing_sender AS mailing_sender_42,
c0_.mailing_header AS mailing_header_43,
c0_.logo_cabinet AS logo_cabinet_44,
c0_.vcard_access AS vcard_access_45,
c0_.last_update AS last_update_46,
c0_.dark_theme AS dark_theme_47,
c0_.appelle_ton_ec_token AS appelle_ton_ec_token_48,
c0_.appelle_ton_ec_widget_url AS appelle_ton_ec_widget_url_49,
c0_.gmb_enable AS gmb_enable_50,
c0_.actuv2_not_ec AS actuv2_not_ec_51,
c0_.actuv2_only_podcast AS actuv2_only_podcast_52,
c0_.gmb_url AS gmb_url_53,
c0_.gmb_name AS gmb_name_54,
c0_.calendly_url AS calendly_url_55,
c0_.survey_client_requested AS survey_client_requested_56,
c0_.survey_client_activate AS survey_client_activate_57,
c0_.podcast_intro_filename AS podcast_intro_filename_58,
c0_.enable_podcast_private AS enable_podcast_private_59,
c0_.podcast_private_student AS podcast_private_student_60,
c0_.podcast_private_token AS podcast_private_token_61,
c0_.podcast_private_widget_url AS podcast_private_widget_url_62,
c0_.subscriber_podcast_private AS subscriber_podcast_private_63,
c0_.logo_pal_path AS logo_pal_path_64,
c0_.google_analytics_id AS google_analytics_id_65,
c0_.email_nl_actu_test AS email_nl_actu_test_66,
c0_.helpers_firms_token AS helpers_firms_token_67,
c0_.helpers_firms_widget_url AS helpers_firms_widget_url_68,
c0_.emailing_client_activate AS emailing_client_activate_69,
c0_.emailing_client_token_max AS emailing_client_token_max_70,
c0_.emailing_client_sender AS emailing_client_sender_71,
c0_.sms_client_activate AS sms_client_activate_72,
c0_.sms_client_credit_max AS sms_client_credit_max_73,
c0_.sms_client_sender AS sms_client_sender_74,
c0_.sms_client_sender_label AS sms_client_sender_label_75,
c0_.anniversaire_client_sender AS anniversaire_client_sender_76,
c0_.anniversaire_client_activate AS anniversaire_client_activate_77,
c0_.event_token AS event_token_78,
c0_.event_widget_url AS event_widget_url_79,
c0_.event_client_requested AS event_client_requested_80,
c0_.sponsorship_token AS sponsorship_token_81,
c0_.sponsorship_widget_url AS sponsorship_widget_url_82,
c0_.sponsorship_client_requested AS sponsorship_client_requested_83,
c0_.sponsorship_client_activate AS sponsorship_client_activate_84,
c0_.recommendation_token AS recommendation_token_85,
c0_.recommendation_widget_url AS recommendation_widget_url_86,
c0_.recommendation_client_requested AS recommendation_client_requested_87,
c0_.recommendation_client_activate AS recommendation_client_activate_88,
c0_.survey_token AS survey_token_89,
c0_.survey_widget_url AS survey_widget_url_90,
c0_.satisfaction_token AS satisfaction_token_91,
c0_.satisfaction_widget_url AS satisfaction_widget_url_92,
c0_.electronic_invoice_token AS electronic_invoice_token_93,
c0_.electronic_invoice_widget_url AS electronic_invoice_widget_url_94,
c0_.satisfaction_client_activate AS satisfaction_client_activate_95,
c0_.card_trello_event_create AS card_trello_event_create_96,
c0_.card_trello_satisfaction_create AS card_trello_satisfaction_create_97,
c0_.platform_enabled AS platform_enabled_98,
c0_.sepa_prelevement_date AS sepa_prelevement_date_99,
c0_.onboarding_replay_url AS onboarding_replay_url_100,
c0_.onboarding_replay_notified_at AS onboarding_replay_notified_at_101,
c0_.onboarding_replay_code AS onboarding_replay_code_102,
c0_.linkedin_username AS linkedin_username_103,
c0_.linkedin_password AS linkedin_password_104,
c0_.linkedin_password_updated_at AS linkedin_password_updated_at_105,
p1_.id AS id_106,
p1_.modules AS modules_107,
p1_.website_news_links AS website_news_links_108,
p1_.website_news_images AS website_news_images_109,
p1_.website_news_documents AS website_news_documents_110,
p1_.website_news_max_image_size AS website_news_max_image_size_111,
p1_.website_news_max_document_size AS website_news_max_document_size_112,
p1_.ebook_max_image_size AS ebook_max_image_size_113,
p1_.ebook_max_document_size AS ebook_max_document_size_114,
p1_.ebook_documents AS ebook_documents_115,
p1_.ebook_images AS ebook_images_116,
p1_.web_mail AS web_mail_117,
p1_.google_tag_manager AS google_tag_manager_118,
p1_.google_analytics AS google_analytics_119,
p1_.domain_type AS domain_type_120,
p1_.seo_meta_title AS seo_meta_title_121,
p1_.seo_meta_description AS seo_meta_description_122,
p1_.google_recaptcha_site_key AS google_recaptcha_site_key_123,
p1_.google_recaptcha_secret AS google_recaptcha_secret_124,
p1_.favicon AS favicon_125,
p1_.web_mail_recrutement AS web_mail_recrutement_126,
p1_.maintenance AS maintenance_127,
p1_.construction AS construction_128,
p1_.monetico_tpe AS monetico_tpe_129,
p1_.monetico_societe AS monetico_societe_130,
p1_.monetico_cle AS monetico_cle_131,
c0_.mailing_api_id AS mailing_api_id_132,
c0_.rgpd_expert_id AS rgpd_expert_id_133,
c0_.ce_expert_id AS ce_expert_id_134,
c0_.cir_expert_id AS cir_expert_id_135,
c0_.emailing_client_api_id AS emailing_client_api_id_136,
p1_.accounting_firm_id AS accounting_firm_id_137,
p1_.mailjetapi_id AS mailjetapi_id_138,
p1_.mailjetapi_recrutement_id AS mailjetapi_recrutement_id_139
FROM
cabinet c0_
LEFT JOIN parameters p1_ ON c0_.id = p1_.accounting_firm_id
WHERE
c0_.host = ?
SELECT c0_.id AS id_0, c0_.nom AS nom_1, c0_.mail AS mail_2, c0_.url AS url_3, c0_.adresse AS adresse_4, c0_.cp AS cp_5, c0_.ville AS ville_6, c0_.telephone AS telephone_7, c0_.domain_activate AS domain_activate_8, c0_.bAbonnementCalendrier AS bAbonnementCalendrier_9, c0_.newsletterCouleur AS newsletterCouleur_10, c0_.dateCreation AS dateCreation_11, c0_.version AS version_12, c0_.actuv2_token AS actuv2_token_13, c0_.actuv2_referer AS actuv2_referer_14, c0_.actuv2_widgetUrl AS actuv2_widgetUrl_15, c0_.actuv2_colorPrimary AS actuv2_colorPrimary_16, c0_.actuv2_colorSecondary AS actuv2_colorSecondary_17, c0_.actuv2_urlContact AS actuv2_urlContact_18, c0_.host AS host_19, c0_.website_created_at AS website_created_at_20, c0_.idsellsy AS idsellsy_21, c0_.simulateur_token AS simulateur_token_22, c0_.simulateur_widget_url AS simulateur_widget_url_23, c0_.rgpd_token AS rgpd_token_24, c0_.rgpd_widget_url AS rgpd_widget_url_25, c0_.ce_token AS ce_token_26, c0_.ce_widget_url AS ce_widget_url_27, c0_.tous_en_ligne_token AS tous_en_ligne_token_28, c0_.tous_en_ligne_widget_url AS tous_en_ligne_widget_url_29, c0_.rgpd_sender AS rgpd_sender_30, c0_.rgpd_sender_name AS rgpd_sender_name_31, c0_.rgpd_expert_externe_use AS rgpd_expert_externe_use_32, c0_.ce_sender AS ce_sender_33, c0_.ce_sender_name AS ce_sender_name_34, c0_.ce_expert_externe_use AS ce_expert_externe_use_35, c0_.cir_sender AS cir_sender_36, c0_.cir_sender_name AS cir_sender_name_37, c0_.cir_expert_externe_use AS cir_expert_externe_use_38, c0_.cir_token AS cir_token_39, c0_.cir_widget_url AS cir_widget_url_40, c0_.mailing_module AS mailing_module_41, c0_.mailing_sender AS mailing_sender_42, c0_.mailing_header AS mailing_header_43, c0_.logo_cabinet AS logo_cabinet_44, c0_.vcard_access AS vcard_access_45, c0_.last_update AS last_update_46, c0_.dark_theme AS dark_theme_47, c0_.appelle_ton_ec_token AS appelle_ton_ec_token_48, c0_.appelle_ton_ec_widget_url AS appelle_ton_ec_widget_url_49, c0_.gmb_enable AS gmb_enable_50, c0_.actuv2_not_ec AS actuv2_not_ec_51, c0_.actuv2_only_podcast AS actuv2_only_podcast_52, c0_.gmb_url AS gmb_url_53, c0_.gmb_name AS gmb_name_54, c0_.calendly_url AS calendly_url_55, c0_.survey_client_requested AS survey_client_requested_56, c0_.survey_client_activate AS survey_client_activate_57, c0_.podcast_intro_filename AS podcast_intro_filename_58, c0_.enable_podcast_private AS enable_podcast_private_59, c0_.podcast_private_student AS podcast_private_student_60, c0_.podcast_private_token AS podcast_private_token_61, c0_.podcast_private_widget_url AS podcast_private_widget_url_62, c0_.subscriber_podcast_private AS subscriber_podcast_private_63, c0_.logo_pal_path AS logo_pal_path_64, c0_.google_analytics_id AS google_analytics_id_65, c0_.email_nl_actu_test AS email_nl_actu_test_66, c0_.helpers_firms_token AS helpers_firms_token_67, c0_.helpers_firms_widget_url AS helpers_firms_widget_url_68, c0_.emailing_client_activate AS emailing_client_activate_69, c0_.emailing_client_token_max AS emailing_client_token_max_70, c0_.emailing_client_sender AS emailing_client_sender_71, c0_.sms_client_activate AS sms_client_activate_72, c0_.sms_client_credit_max AS sms_client_credit_max_73, c0_.sms_client_sender AS sms_client_sender_74, c0_.sms_client_sender_label AS sms_client_sender_label_75, c0_.anniversaire_client_sender AS anniversaire_client_sender_76, c0_.anniversaire_client_activate AS anniversaire_client_activate_77, c0_.event_token AS event_token_78, c0_.event_widget_url AS event_widget_url_79, c0_.event_client_requested AS event_client_requested_80, c0_.sponsorship_token AS sponsorship_token_81, c0_.sponsorship_widget_url AS sponsorship_widget_url_82, c0_.sponsorship_client_requested AS sponsorship_client_requested_83, c0_.sponsorship_client_activate AS sponsorship_client_activate_84, c0_.recommendation_token AS recommendation_token_85, c0_.recommendation_widget_url AS recommendation_widget_url_86, c0_.recommendation_client_requested AS recommendation_client_requested_87, c0_.recommendation_client_activate AS recommendation_client_activate_88, c0_.survey_token AS survey_token_89, c0_.survey_widget_url AS survey_widget_url_90, c0_.satisfaction_token AS satisfaction_token_91, c0_.satisfaction_widget_url AS satisfaction_widget_url_92, c0_.electronic_invoice_token AS electronic_invoice_token_93, c0_.electronic_invoice_widget_url AS electronic_invoice_widget_url_94, c0_.satisfaction_client_activate AS satisfaction_client_activate_95, c0_.card_trello_event_create AS card_trello_event_create_96, c0_.card_trello_satisfaction_create AS card_trello_satisfaction_create_97, c0_.platform_enabled AS platform_enabled_98, c0_.sepa_prelevement_date AS sepa_prelevement_date_99, c0_.onboarding_replay_url AS onboarding_replay_url_100, c0_.onboarding_replay_notified_at AS onboarding_replay_notified_at_101, c0_.onboarding_replay_code AS onboarding_replay_code_102, c0_.linkedin_username AS linkedin_username_103, c0_.linkedin_password AS linkedin_password_104, c0_.linkedin_password_updated_at AS linkedin_password_updated_at_105, p1_.id AS id_106, p1_.modules AS modules_107, p1_.website_news_links AS website_news_links_108, p1_.website_news_images AS website_news_images_109, p1_.website_news_documents AS website_news_documents_110, p1_.website_news_max_image_size AS website_news_max_image_size_111, p1_.website_news_max_document_size AS website_news_max_document_size_112, p1_.ebook_max_image_size AS ebook_max_image_size_113, p1_.ebook_max_document_size AS ebook_max_document_size_114, p1_.ebook_documents AS ebook_documents_115, p1_.ebook_images AS ebook_images_116, p1_.web_mail AS web_mail_117, p1_.google_tag_manager AS google_tag_manager_118, p1_.google_analytics AS google_analytics_119, p1_.domain_type AS domain_type_120, p1_.seo_meta_title AS seo_meta_title_121, p1_.seo_meta_description AS seo_meta_description_122, p1_.google_recaptcha_site_key AS google_recaptcha_site_key_123, p1_.google_recaptcha_secret AS google_recaptcha_secret_124, p1_.favicon AS favicon_125, p1_.web_mail_recrutement AS web_mail_recrutement_126, p1_.maintenance AS maintenance_127, p1_.construction AS construction_128, p1_.monetico_tpe AS monetico_tpe_129, p1_.monetico_societe AS monetico_societe_130, p1_.monetico_cle AS monetico_cle_131, c0_.mailing_api_id AS mailing_api_id_132, c0_.rgpd_expert_id AS rgpd_expert_id_133, c0_.ce_expert_id AS ce_expert_id_134, c0_.cir_expert_id AS cir_expert_id_135, c0_.emailing_client_api_id AS emailing_client_api_id_136, p1_.accounting_firm_id AS accounting_firm_id_137, p1_.mailjetapi_id AS mailjetapi_id_138, p1_.mailjetapi_recrutement_id AS mailjetapi_recrutement_id_139 FROM cabinet c0_ LEFT JOIN parameters p1_ ON c0_.id = p1_.accounting_firm_id WHERE c0_.host = 'vcard-frontdev.lagence.expert';
|