Symfony Profiler

SELECT
  u0_.id AS id_0,
  u0_.public_id AS public_id_1,
  u0_.email AS email_2,
  u0_.pseudo AS pseudo_3,
  u0_.licence AS licence_4,
  u0_.id_dupr AS id_dupr_5,
  u0_.genre AS genre_6,
  u0_.nom AS nom_7,
  u0_.prenom AS prenom_8,
  u0_.date_de_naissance AS date_de_naissance_9,
  u0_.ville AS ville_10,
  u0_.description AS description_11,
  u0_.telephone AS telephone_12,
  u0_.instagram AS instagram_13,
  u0_.linkedin AS linkedin_14,
  u0_.tiktok AS tiktok_15,
  u0_.twitter AS twitter_16,
  u0_.facebook AS facebook_17,
  u0_.statut AS statut_18,
  u0_.roles AS roles_19,
  u0_.password AS password_20,
  u0_.indicateur AS indicateur_21,
  u0_.createur AS createur_22,
  u0_.stripe_account_id AS stripe_account_id_23,
  u0_.stripe_onboarding_complete AS stripe_onboarding_complete_24,
  u0_.stripe_account_created_at AS stripe_account_created_at_25,
  u0_.stripe_account_type AS stripe_account_type_26,
  u0_.is_admin AS is_admin_27,
  u0_.commission_defaut AS commission_defaut_28,
  u0_.dupr_user_token AS dupr_user_token_29,
  u0_.dupr_refresh_token AS dupr_refresh_token_30,
  u0_.dupr_token_expires_at AS dupr_token_expires_at_31,
  u0_.dupr_sso_connected_at AS dupr_sso_connected_at_32,
  u0_.dupr_rating_singles AS dupr_rating_singles_33,
  u0_.dupr_rating_doubles AS dupr_rating_doubles_34,
  u0_.dupr_ratings_updated_at AS dupr_ratings_updated_at_35,
  u0_.dupr_basic_entitlement AS dupr_basic_entitlement_36,
  u0_.dupr_entitlement_checked_at AS dupr_entitlement_checked_at_37,
  u0_.newsletter_consent AS newsletter_consent_38,
  u0_.newsletter_consent_date AS newsletter_consent_date_39,
  u0_.traitement_limite AS traitement_limite_40,
  u0_.traitement_limite_date AS traitement_limite_date_41,
  u0_.traitement_limite_motif AS traitement_limite_motif_42,
  u0_.pays_id AS pays_id_43,
  u0_.niveau_simple_id AS niveau_simple_id_44,
  u0_.niveau_double_id AS niveau_double_id_45,
  u0_.niveau_mixte_id AS niveau_mixte_id_46
FROM
  `user` u0_
WHERE
  u0_.public_id = ?

SELECT u0_.id AS id_0, u0_.public_id AS public_id_1, u0_.email AS email_2, u0_.pseudo AS pseudo_3, u0_.licence AS licence_4, u0_.id_dupr AS id_dupr_5, u0_.genre AS genre_6, u0_.nom AS nom_7, u0_.prenom AS prenom_8, u0_.date_de_naissance AS date_de_naissance_9, u0_.ville AS ville_10, u0_.description AS description_11, u0_.telephone AS telephone_12, u0_.instagram AS instagram_13, u0_.linkedin AS linkedin_14, u0_.tiktok AS tiktok_15, u0_.twitter AS twitter_16, u0_.facebook AS facebook_17, u0_.statut AS statut_18, u0_.roles AS roles_19, u0_.password AS password_20, u0_.indicateur AS indicateur_21, u0_.createur AS createur_22, u0_.stripe_account_id AS stripe_account_id_23, u0_.stripe_onboarding_complete AS stripe_onboarding_complete_24, u0_.stripe_account_created_at AS stripe_account_created_at_25, u0_.stripe_account_type AS stripe_account_type_26, u0_.is_admin AS is_admin_27, u0_.commission_defaut AS commission_defaut_28, u0_.dupr_user_token AS dupr_user_token_29, u0_.dupr_refresh_token AS dupr_refresh_token_30, u0_.dupr_token_expires_at AS dupr_token_expires_at_31, u0_.dupr_sso_connected_at AS dupr_sso_connected_at_32, u0_.dupr_rating_singles AS dupr_rating_singles_33, u0_.dupr_rating_doubles AS dupr_rating_doubles_34, u0_.dupr_ratings_updated_at AS dupr_ratings_updated_at_35, u0_.dupr_basic_entitlement AS dupr_basic_entitlement_36, u0_.dupr_entitlement_checked_at AS dupr_entitlement_checked_at_37, u0_.newsletter_consent AS newsletter_consent_38, u0_.newsletter_consent_date AS newsletter_consent_date_39, u0_.traitement_limite AS traitement_limite_40, u0_.traitement_limite_date AS traitement_limite_date_41, u0_.traitement_limite_motif AS traitement_limite_motif_42, u0_.pays_id AS pays_id_43, u0_.niveau_simple_id AS niveau_simple_id_44, u0_.niveau_double_id AS niveau_double_id_45, u0_.niveau_mixte_id AS niveau_mixte_id_46 FROM `user` u0_ WHERE u0_.public_id = 'b2e4bb73-342d-11f1-ae32-fa163e19c1c5';

SELECT
  s.jour,
  COALESCE(
    SUM(
      CASE WHEN ep.is_simple = 1 THEN
        1
      ELSE
        0.5
      END
    ),
    0
  ) as total_teams
FROM
  user_selection us
  JOIN selection s ON us.selection_id = s.id
  JOIN config c ON s.config_id = c.id
  JOIN evenement e ON e.config_id = c.id
  JOIN epreuve ep ON s.id_epreuve_id = ep.id
WHERE
  us.paye = 1
  AND e.id = ?
  AND s.jour IS NOT NULL
GROUP BY
  s.jour

SELECT s.jour, COALESCE(SUM(
                CASE WHEN ep.is_simple = 1 THEN 1 ELSE 0.5 END
            ), 0) as total_teams
            FROM user_selection us
            JOIN selection s ON us.selection_id = s.id
            JOIN config c ON s.config_id = c.id
            JOIN evenement e ON e.config_id = c.id
            JOIN epreuve ep ON s.id_epreuve_id = ep.id
            WHERE us.paye = 1
            AND e.id = 28
            AND s.jour IS NOT NULL
            GROUP BY s.jour
        ;

SELECT
  COALESCE(
    SUM(
      CASE WHEN ep.is_simple = 1 THEN
        1
      ELSE
        0.5
      END
    ),
    0
  ) as total_teams
FROM
  user_selection us
  JOIN selection s ON us.selection_id = s.id
  JOIN config c ON s.config_id = c.id
  JOIN evenement e ON e.config_id = c.id
  JOIN epreuve ep ON s.id_epreuve_id = ep.id
WHERE
  us.paye = 1
  AND e.id = ?

SELECT COALESCE(SUM(
                CASE WHEN ep.is_simple = 1 THEN 1 ELSE 0.5 END
            ), 0) as total_teams
            FROM user_selection us
            JOIN selection s ON us.selection_id = s.id
            JOIN config c ON s.config_id = c.id
            JOIN evenement e ON e.config_id = c.id
            JOIN epreuve ep ON s.id_epreuve_id = ep.id
            WHERE us.paye = 1
            AND e.id = 28
        ;

SELECT
  e0_.id AS id_0,
  e0_.ordre_circuit AS ordre_circuit_1,
  e0_.is_master_final AS is_master_final_2,
  e0_.sur_invitation AS sur_invitation_3,
  e0_.points_assiduite AS points_assiduite_4,
  e0_.titre AS titre_5,
  e0_.description AS description_6,
  e0_.creation AS creation_7,
  e0_.termine AS termine_8,
  e0_.date_creation AS date_creation_9,
  e0_.encours AS encours_10,
  e0_.publier AS publier_11,
  e0_.inscriptions_ouvertes AS inscriptions_ouvertes_12,
  e0_.homologuer_fft AS homologuer_fft_13,
  e0_.demander_id_dupr AS demander_id_dupr_14,
  e0_.require_dupr_plus AS require_dupr_plus_15,
  e0_.require_dupr_verified AS require_dupr_verified_16,
  e0_.inscription_privee AS inscription_privee_17,
  e0_.code_pin_inscription AS code_pin_inscription_18,
  e0_.etat_actuel AS etat_actuel_19,
  e0_.commission_plateforme AS commission_plateforme_20,
  p1_.id AS id_21,
  p1_.url AS url_22,
  p1_.description AS description_23,
  p1_.created_at AS created_at_24,
  p1_.updated_at AS updated_at_25,
  p1_.nom AS nom_26,
  p1_.extension AS extension_27,
  c2_.id AS id_28,
  c2_.date_debut AS date_debut_29,
  c2_.fin_inscription AS fin_inscription_30,
  c2_.nb_joueur AS nb_joueur_31,
  c2_.date_fin AS date_fin_32,
  c2_.adresse AS adresse_33,
  c2_.complement AS complement_34,
  c2_.cp AS cp_35,
  c2_.ville AS ville_36,
  c2_.pays AS pays_37,
  c2_.map AS map_38,
  c2_.nb_joueur_max AS nb_joueur_max_39,
  c2_.nb_equipe_max AS nb_equipe_max_40,
  c2_.terrain_interieur AS terrain_interieur_41,
  c2_.terrain_exterieur AS terrain_exterieur_42,
  c2_.type_balle AS type_balle_43,
  c2_.nb_joueur_par_equipe AS nb_joueur_par_equipe_44,
  c2_.montant_repas AS montant_repas_45,
  c2_.devise AS devise_46,
  c2_.nb_journee_previsionnel AS nb_journee_previsionnel_47,
  c2_.prizepool AS prizepool_48,
  c2_.nb_match_par_rencontre AS nb_match_par_rencontre_49,
  c2_.datas_victoire AS datas_victoire_50,
  c2_.points_victoire AS points_victoire_51,
  c2_.points_defaite AS points_defaite_52,
  c2_.points_nul AS points_nul_53,
  c2_.categorie AS categorie_54,
  e0_.config_id AS config_id_55,
  e0_.organisateur_id AS organisateur_id_56,
  e0_.style_id AS style_id_57,
  e0_.circuit_id AS circuit_id_58,
  p1_.evenement_id AS evenement_id_59,
  p1_.joueur_id AS joueur_id_60
FROM
  evenement e0_
  LEFT JOIN photo p1_ ON e0_.id = p1_.evenement_id
  LEFT JOIN config c2_ ON e0_.config_id = c2_.id
  LEFT JOIN style s3_ ON e0_.style_id = s3_.id
WHERE
  e0_.publier = ?
  AND c2_.date_debut >= ?
  AND (
    s3_.nom <> ?
    OR s3_.nom IS NULL
  )
ORDER BY
  c2_.date_debut ASC
LIMIT
  6

SELECT e0_.id AS id_0, e0_.ordre_circuit AS ordre_circuit_1, e0_.is_master_final AS is_master_final_2, e0_.sur_invitation AS sur_invitation_3, e0_.points_assiduite AS points_assiduite_4, e0_.titre AS titre_5, e0_.description AS description_6, e0_.creation AS creation_7, e0_.termine AS termine_8, e0_.date_creation AS date_creation_9, e0_.encours AS encours_10, e0_.publier AS publier_11, e0_.inscriptions_ouvertes AS inscriptions_ouvertes_12, e0_.homologuer_fft AS homologuer_fft_13, e0_.demander_id_dupr AS demander_id_dupr_14, e0_.require_dupr_plus AS require_dupr_plus_15, e0_.require_dupr_verified AS require_dupr_verified_16, e0_.inscription_privee AS inscription_privee_17, e0_.code_pin_inscription AS code_pin_inscription_18, e0_.etat_actuel AS etat_actuel_19, e0_.commission_plateforme AS commission_plateforme_20, p1_.id AS id_21, p1_.url AS url_22, p1_.description AS description_23, p1_.created_at AS created_at_24, p1_.updated_at AS updated_at_25, p1_.nom AS nom_26, p1_.extension AS extension_27, c2_.id AS id_28, c2_.date_debut AS date_debut_29, c2_.fin_inscription AS fin_inscription_30, c2_.nb_joueur AS nb_joueur_31, c2_.date_fin AS date_fin_32, c2_.adresse AS adresse_33, c2_.complement AS complement_34, c2_.cp AS cp_35, c2_.ville AS ville_36, c2_.pays AS pays_37, c2_.map AS map_38, c2_.nb_joueur_max AS nb_joueur_max_39, c2_.nb_equipe_max AS nb_equipe_max_40, c2_.terrain_interieur AS terrain_interieur_41, c2_.terrain_exterieur AS terrain_exterieur_42, c2_.type_balle AS type_balle_43, c2_.nb_joueur_par_equipe AS nb_joueur_par_equipe_44, c2_.montant_repas AS montant_repas_45, c2_.devise AS devise_46, c2_.nb_journee_previsionnel AS nb_journee_previsionnel_47, c2_.prizepool AS prizepool_48, c2_.nb_match_par_rencontre AS nb_match_par_rencontre_49, c2_.datas_victoire AS datas_victoire_50, c2_.points_victoire AS points_victoire_51, c2_.points_defaite AS points_defaite_52, c2_.points_nul AS points_nul_53, c2_.categorie AS categorie_54, e0_.config_id AS config_id_55, e0_.organisateur_id AS organisateur_id_56, e0_.style_id AS style_id_57, e0_.circuit_id AS circuit_id_58, p1_.evenement_id AS evenement_id_59, p1_.joueur_id AS joueur_id_60 FROM evenement e0_ LEFT JOIN photo p1_ ON e0_.id = p1_.evenement_id LEFT JOIN config c2_ ON e0_.config_id = c2_.id LEFT JOIN style s3_ ON e0_.style_id = s3_.id WHERE e0_.publier = 1 AND c2_.date_debut >= '2026-04-20 00:00:00' AND (s3_.nom <> 'Circuit' OR s3_.nom IS NULL) ORDER BY c2_.date_debut ASC LIMIT 6;

SELECT
  DISTINCT s.jour
FROM
  selection s
  JOIN config c ON s.config_id = c.id
  JOIN evenement e ON e.config_id = c.id
WHERE
  e.id = ?
  AND s.jour IS NOT NULL
ORDER BY
  s.jour ASC

SELECT DISTINCT s.jour
            FROM selection s
            JOIN config c ON s.config_id = c.id
            JOIN evenement e ON e.config_id = c.id
            WHERE e.id = 28
            AND s.jour IS NOT NULL
            ORDER BY s.jour ASC
        ;

SELECT
  COUNT(DISTINCT s.jour) as nb_jours
FROM
  selection s
  JOIN config c ON s.config_id = c.id
  JOIN evenement e ON e.config_id = c.id
WHERE
  e.id = ?
  AND s.jour IS NOT NULL

SELECT COUNT(DISTINCT s.jour) as nb_jours
            FROM selection s
            JOIN config c ON s.config_id = c.id
            JOIN evenement e ON e.config_id = c.id
            WHERE e.id = 28
            AND s.jour IS NOT NULL
        ;

SELECT
  a0_.id AS id_0,
  a0_.note AS note_1,
  a0_.commentaire AS commentaire_2,
  a0_.categories AS categories_3,
  a0_.note_plateforme AS note_plateforme_4,
  a0_.commentaire_plateforme AS commentaire_plateforme_5,
  a0_.categories_plateforme AS categories_plateforme_6,
  a0_.consentement_marketing AS consentement_marketing_7,
  a0_.consentement_marketing_date AS consentement_marketing_date_8,
  a0_.statut AS statut_9,
  a0_.statut_plateforme AS statut_plateforme_10,
  a0_.mis_en_avant AS mis_en_avant_11,
  a0_.mis_en_avant_plateforme AS mis_en_avant_plateforme_12,
  a0_.date_moderation AS date_moderation_13,
  a0_.reponse_organisateur AS reponse_organisateur_14,
  a0_.date_reponse AS date_reponse_15,
  a0_.created_at AS created_at_16,
  a0_.updated_at AS updated_at_17,
  u1_.id AS id_18,
  u1_.public_id AS public_id_19,
  u1_.email AS email_20,
  u1_.pseudo AS pseudo_21,
  u1_.licence AS licence_22,
  u1_.id_dupr AS id_dupr_23,
  u1_.genre AS genre_24,
  u1_.nom AS nom_25,
  u1_.prenom AS prenom_26,
  u1_.date_de_naissance AS date_de_naissance_27,
  u1_.ville AS ville_28,
  u1_.description AS description_29,
  u1_.telephone AS telephone_30,
  u1_.instagram AS instagram_31,
  u1_.linkedin AS linkedin_32,
  u1_.tiktok AS tiktok_33,
  u1_.twitter AS twitter_34,
  u1_.facebook AS facebook_35,
  u1_.statut AS statut_36,
  u1_.roles AS roles_37,
  u1_.password AS password_38,
  u1_.indicateur AS indicateur_39,
  u1_.createur AS createur_40,
  u1_.stripe_account_id AS stripe_account_id_41,
  u1_.stripe_onboarding_complete AS stripe_onboarding_complete_42,
  u1_.stripe_account_created_at AS stripe_account_created_at_43,
  u1_.stripe_account_type AS stripe_account_type_44,
  u1_.is_admin AS is_admin_45,
  u1_.commission_defaut AS commission_defaut_46,
  u1_.dupr_user_token AS dupr_user_token_47,
  u1_.dupr_refresh_token AS dupr_refresh_token_48,
  u1_.dupr_token_expires_at AS dupr_token_expires_at_49,
  u1_.dupr_sso_connected_at AS dupr_sso_connected_at_50,
  u1_.dupr_rating_singles AS dupr_rating_singles_51,
  u1_.dupr_rating_doubles AS dupr_rating_doubles_52,
  u1_.dupr_ratings_updated_at AS dupr_ratings_updated_at_53,
  u1_.dupr_basic_entitlement AS dupr_basic_entitlement_54,
  u1_.dupr_entitlement_checked_at AS dupr_entitlement_checked_at_55,
  u1_.newsletter_consent AS newsletter_consent_56,
  u1_.newsletter_consent_date AS newsletter_consent_date_57,
  u1_.traitement_limite AS traitement_limite_58,
  u1_.traitement_limite_date AS traitement_limite_date_59,
  u1_.traitement_limite_motif AS traitement_limite_motif_60,
  e2_.id AS id_61,
  e2_.ordre_circuit AS ordre_circuit_62,
  e2_.is_master_final AS is_master_final_63,
  e2_.sur_invitation AS sur_invitation_64,
  e2_.points_assiduite AS points_assiduite_65,
  e2_.titre AS titre_66,
  e2_.description AS description_67,
  e2_.creation AS creation_68,
  e2_.termine AS termine_69,
  e2_.date_creation AS date_creation_70,
  e2_.encours AS encours_71,
  e2_.publier AS publier_72,
  e2_.inscriptions_ouvertes AS inscriptions_ouvertes_73,
  e2_.homologuer_fft AS homologuer_fft_74,
  e2_.demander_id_dupr AS demander_id_dupr_75,
  e2_.require_dupr_plus AS require_dupr_plus_76,
  e2_.require_dupr_verified AS require_dupr_verified_77,
  e2_.inscription_privee AS inscription_privee_78,
  e2_.code_pin_inscription AS code_pin_inscription_79,
  e2_.etat_actuel AS etat_actuel_80,
  e2_.commission_plateforme AS commission_plateforme_81,
  a0_.auteur_id AS auteur_id_82,
  a0_.evenement_id AS evenement_id_83,
  a0_.modere_par_id AS modere_par_id_84,
  u1_.pays_id AS pays_id_85,
  u1_.niveau_simple_id AS niveau_simple_id_86,
  u1_.niveau_double_id AS niveau_double_id_87,
  u1_.niveau_mixte_id AS niveau_mixte_id_88,
  e2_.config_id AS config_id_89,
  e2_.organisateur_id AS organisateur_id_90,
  e2_.style_id AS style_id_91,
  e2_.circuit_id AS circuit_id_92
FROM
  avis a0_
  LEFT JOIN `user` u1_ ON a0_.auteur_id = u1_.id
  LEFT JOIN evenement e2_ ON a0_.evenement_id = e2_.id
WHERE
  a0_.statut = ?
  AND a0_.mis_en_avant = 1
  AND a0_.consentement_marketing = 1
ORDER BY
  a0_.note DESC,
  a0_.created_at DESC
LIMIT
  100

SELECT a0_.id AS id_0, a0_.note AS note_1, a0_.commentaire AS commentaire_2, a0_.categories AS categories_3, a0_.note_plateforme AS note_plateforme_4, a0_.commentaire_plateforme AS commentaire_plateforme_5, a0_.categories_plateforme AS categories_plateforme_6, a0_.consentement_marketing AS consentement_marketing_7, a0_.consentement_marketing_date AS consentement_marketing_date_8, a0_.statut AS statut_9, a0_.statut_plateforme AS statut_plateforme_10, a0_.mis_en_avant AS mis_en_avant_11, a0_.mis_en_avant_plateforme AS mis_en_avant_plateforme_12, a0_.date_moderation AS date_moderation_13, a0_.reponse_organisateur AS reponse_organisateur_14, a0_.date_reponse AS date_reponse_15, a0_.created_at AS created_at_16, a0_.updated_at AS updated_at_17, u1_.id AS id_18, u1_.public_id AS public_id_19, u1_.email AS email_20, u1_.pseudo AS pseudo_21, u1_.licence AS licence_22, u1_.id_dupr AS id_dupr_23, u1_.genre AS genre_24, u1_.nom AS nom_25, u1_.prenom AS prenom_26, u1_.date_de_naissance AS date_de_naissance_27, u1_.ville AS ville_28, u1_.description AS description_29, u1_.telephone AS telephone_30, u1_.instagram AS instagram_31, u1_.linkedin AS linkedin_32, u1_.tiktok AS tiktok_33, u1_.twitter AS twitter_34, u1_.facebook AS facebook_35, u1_.statut AS statut_36, u1_.roles AS roles_37, u1_.password AS password_38, u1_.indicateur AS indicateur_39, u1_.createur AS createur_40, u1_.stripe_account_id AS stripe_account_id_41, u1_.stripe_onboarding_complete AS stripe_onboarding_complete_42, u1_.stripe_account_created_at AS stripe_account_created_at_43, u1_.stripe_account_type AS stripe_account_type_44, u1_.is_admin AS is_admin_45, u1_.commission_defaut AS commission_defaut_46, u1_.dupr_user_token AS dupr_user_token_47, u1_.dupr_refresh_token AS dupr_refresh_token_48, u1_.dupr_token_expires_at AS dupr_token_expires_at_49, u1_.dupr_sso_connected_at AS dupr_sso_connected_at_50, u1_.dupr_rating_singles AS dupr_rating_singles_51, u1_.dupr_rating_doubles AS dupr_rating_doubles_52, u1_.dupr_ratings_updated_at AS dupr_ratings_updated_at_53, u1_.dupr_basic_entitlement AS dupr_basic_entitlement_54, u1_.dupr_entitlement_checked_at AS dupr_entitlement_checked_at_55, u1_.newsletter_consent AS newsletter_consent_56, u1_.newsletter_consent_date AS newsletter_consent_date_57, u1_.traitement_limite AS traitement_limite_58, u1_.traitement_limite_date AS traitement_limite_date_59, u1_.traitement_limite_motif AS traitement_limite_motif_60, e2_.id AS id_61, e2_.ordre_circuit AS ordre_circuit_62, e2_.is_master_final AS is_master_final_63, e2_.sur_invitation AS sur_invitation_64, e2_.points_assiduite AS points_assiduite_65, e2_.titre AS titre_66, e2_.description AS description_67, e2_.creation AS creation_68, e2_.termine AS termine_69, e2_.date_creation AS date_creation_70, e2_.encours AS encours_71, e2_.publier AS publier_72, e2_.inscriptions_ouvertes AS inscriptions_ouvertes_73, e2_.homologuer_fft AS homologuer_fft_74, e2_.demander_id_dupr AS demander_id_dupr_75, e2_.require_dupr_plus AS require_dupr_plus_76, e2_.require_dupr_verified AS require_dupr_verified_77, e2_.inscription_privee AS inscription_privee_78, e2_.code_pin_inscription AS code_pin_inscription_79, e2_.etat_actuel AS etat_actuel_80, e2_.commission_plateforme AS commission_plateforme_81, a0_.auteur_id AS auteur_id_82, a0_.evenement_id AS evenement_id_83, a0_.modere_par_id AS modere_par_id_84, u1_.pays_id AS pays_id_85, u1_.niveau_simple_id AS niveau_simple_id_86, u1_.niveau_double_id AS niveau_double_id_87, u1_.niveau_mixte_id AS niveau_mixte_id_88, e2_.config_id AS config_id_89, e2_.organisateur_id AS organisateur_id_90, e2_.style_id AS style_id_91, e2_.circuit_id AS circuit_id_92 FROM avis a0_ LEFT JOIN `user` u1_ ON a0_.auteur_id = u1_.id LEFT JOIN evenement e2_ ON a0_.evenement_id = e2_.id WHERE a0_.statut = 'valide' AND a0_.mis_en_avant = 1 AND a0_.consentement_marketing = 1 ORDER BY a0_.note DESC, a0_.created_at DESC LIMIT 100;

SELECT
  COUNT(DISTINCT e0_.id) AS sclr_0
FROM
  evenement e0_
  INNER JOIN config c1_ ON e0_.config_id = c1_.id
  INNER JOIN selection s2_ ON c1_.id = s2_.config_id
  INNER JOIN poule p3_ ON (p3_.selection_id = s2_.id)
  INNER JOIN game_match g4_ ON (g4_.poule_id = p3_.id)
WHERE
  e0_.termine = 1
  AND (
    e0_.publier = 0
    OR e0_.publier IS NULL
  )

SELECT COUNT(DISTINCT e0_.id) AS sclr_0 FROM evenement e0_ INNER JOIN config c1_ ON e0_.config_id = c1_.id INNER JOIN selection s2_ ON c1_.id = s2_.config_id INNER JOIN poule p3_ ON (p3_.selection_id = s2_.id) INNER JOIN game_match g4_ ON (g4_.poule_id = p3_.id) WHERE e0_.termine = 1 AND (e0_.publier = 0 OR e0_.publier IS NULL);

SELECT
  COUNT(u0_.id) AS sclr_0
FROM
  user_selection u0_
WHERE
  u0_.paye = 1

SELECT COUNT(u0_.id) AS sclr_0 FROM user_selection u0_ WHERE u0_.paye = 1;

SELECT
  COUNT(u0_.id) AS sclr_0
FROM
  `user` u0_

SELECT COUNT(u0_.id) AS sclr_0 FROM `user` u0_;

SELECT
  a0_.id AS id_0,
  a0_.note AS note_1,
  a0_.commentaire AS commentaire_2,
  a0_.categories AS categories_3,
  a0_.note_plateforme AS note_plateforme_4,
  a0_.commentaire_plateforme AS commentaire_plateforme_5,
  a0_.categories_plateforme AS categories_plateforme_6,
  a0_.consentement_marketing AS consentement_marketing_7,
  a0_.consentement_marketing_date AS consentement_marketing_date_8,
  a0_.statut AS statut_9,
  a0_.statut_plateforme AS statut_plateforme_10,
  a0_.mis_en_avant AS mis_en_avant_11,
  a0_.mis_en_avant_plateforme AS mis_en_avant_plateforme_12,
  a0_.date_moderation AS date_moderation_13,
  a0_.reponse_organisateur AS reponse_organisateur_14,
  a0_.date_reponse AS date_reponse_15,
  a0_.created_at AS created_at_16,
  a0_.updated_at AS updated_at_17,
  u1_.id AS id_18,
  u1_.public_id AS public_id_19,
  u1_.email AS email_20,
  u1_.pseudo AS pseudo_21,
  u1_.licence AS licence_22,
  u1_.id_dupr AS id_dupr_23,
  u1_.genre AS genre_24,
  u1_.nom AS nom_25,
  u1_.prenom AS prenom_26,
  u1_.date_de_naissance AS date_de_naissance_27,
  u1_.ville AS ville_28,
  u1_.description AS description_29,
  u1_.telephone AS telephone_30,
  u1_.instagram AS instagram_31,
  u1_.linkedin AS linkedin_32,
  u1_.tiktok AS tiktok_33,
  u1_.twitter AS twitter_34,
  u1_.facebook AS facebook_35,
  u1_.statut AS statut_36,
  u1_.roles AS roles_37,
  u1_.password AS password_38,
  u1_.indicateur AS indicateur_39,
  u1_.createur AS createur_40,
  u1_.stripe_account_id AS stripe_account_id_41,
  u1_.stripe_onboarding_complete AS stripe_onboarding_complete_42,
  u1_.stripe_account_created_at AS stripe_account_created_at_43,
  u1_.stripe_account_type AS stripe_account_type_44,
  u1_.is_admin AS is_admin_45,
  u1_.commission_defaut AS commission_defaut_46,
  u1_.dupr_user_token AS dupr_user_token_47,
  u1_.dupr_refresh_token AS dupr_refresh_token_48,
  u1_.dupr_token_expires_at AS dupr_token_expires_at_49,
  u1_.dupr_sso_connected_at AS dupr_sso_connected_at_50,
  u1_.dupr_rating_singles AS dupr_rating_singles_51,
  u1_.dupr_rating_doubles AS dupr_rating_doubles_52,
  u1_.dupr_ratings_updated_at AS dupr_ratings_updated_at_53,
  u1_.dupr_basic_entitlement AS dupr_basic_entitlement_54,
  u1_.dupr_entitlement_checked_at AS dupr_entitlement_checked_at_55,
  u1_.newsletter_consent AS newsletter_consent_56,
  u1_.newsletter_consent_date AS newsletter_consent_date_57,
  u1_.traitement_limite AS traitement_limite_58,
  u1_.traitement_limite_date AS traitement_limite_date_59,
  u1_.traitement_limite_motif AS traitement_limite_motif_60,
  a0_.auteur_id AS auteur_id_61,
  a0_.evenement_id AS evenement_id_62,
  a0_.modere_par_id AS modere_par_id_63,
  u1_.pays_id AS pays_id_64,
  u1_.niveau_simple_id AS niveau_simple_id_65,
  u1_.niveau_double_id AS niveau_double_id_66,
  u1_.niveau_mixte_id AS niveau_mixte_id_67
FROM
  avis a0_
  LEFT JOIN `user` u1_ ON a0_.auteur_id = u1_.id
WHERE
  a0_.note_plateforme IS NOT NULL
  AND a0_.statut_plateforme = ?
  AND a0_.mis_en_avant_plateforme = 1
ORDER BY
  a0_.note_plateforme DESC,
  a0_.created_at DESC
LIMIT
  100

SELECT a0_.id AS id_0, a0_.note AS note_1, a0_.commentaire AS commentaire_2, a0_.categories AS categories_3, a0_.note_plateforme AS note_plateforme_4, a0_.commentaire_plateforme AS commentaire_plateforme_5, a0_.categories_plateforme AS categories_plateforme_6, a0_.consentement_marketing AS consentement_marketing_7, a0_.consentement_marketing_date AS consentement_marketing_date_8, a0_.statut AS statut_9, a0_.statut_plateforme AS statut_plateforme_10, a0_.mis_en_avant AS mis_en_avant_11, a0_.mis_en_avant_plateforme AS mis_en_avant_plateforme_12, a0_.date_moderation AS date_moderation_13, a0_.reponse_organisateur AS reponse_organisateur_14, a0_.date_reponse AS date_reponse_15, a0_.created_at AS created_at_16, a0_.updated_at AS updated_at_17, u1_.id AS id_18, u1_.public_id AS public_id_19, u1_.email AS email_20, u1_.pseudo AS pseudo_21, u1_.licence AS licence_22, u1_.id_dupr AS id_dupr_23, u1_.genre AS genre_24, u1_.nom AS nom_25, u1_.prenom AS prenom_26, u1_.date_de_naissance AS date_de_naissance_27, u1_.ville AS ville_28, u1_.description AS description_29, u1_.telephone AS telephone_30, u1_.instagram AS instagram_31, u1_.linkedin AS linkedin_32, u1_.tiktok AS tiktok_33, u1_.twitter AS twitter_34, u1_.facebook AS facebook_35, u1_.statut AS statut_36, u1_.roles AS roles_37, u1_.password AS password_38, u1_.indicateur AS indicateur_39, u1_.createur AS createur_40, u1_.stripe_account_id AS stripe_account_id_41, u1_.stripe_onboarding_complete AS stripe_onboarding_complete_42, u1_.stripe_account_created_at AS stripe_account_created_at_43, u1_.stripe_account_type AS stripe_account_type_44, u1_.is_admin AS is_admin_45, u1_.commission_defaut AS commission_defaut_46, u1_.dupr_user_token AS dupr_user_token_47, u1_.dupr_refresh_token AS dupr_refresh_token_48, u1_.dupr_token_expires_at AS dupr_token_expires_at_49, u1_.dupr_sso_connected_at AS dupr_sso_connected_at_50, u1_.dupr_rating_singles AS dupr_rating_singles_51, u1_.dupr_rating_doubles AS dupr_rating_doubles_52, u1_.dupr_ratings_updated_at AS dupr_ratings_updated_at_53, u1_.dupr_basic_entitlement AS dupr_basic_entitlement_54, u1_.dupr_entitlement_checked_at AS dupr_entitlement_checked_at_55, u1_.newsletter_consent AS newsletter_consent_56, u1_.newsletter_consent_date AS newsletter_consent_date_57, u1_.traitement_limite AS traitement_limite_58, u1_.traitement_limite_date AS traitement_limite_date_59, u1_.traitement_limite_motif AS traitement_limite_motif_60, a0_.auteur_id AS auteur_id_61, a0_.evenement_id AS evenement_id_62, a0_.modere_par_id AS modere_par_id_63, u1_.pays_id AS pays_id_64, u1_.niveau_simple_id AS niveau_simple_id_65, u1_.niveau_double_id AS niveau_double_id_66, u1_.niveau_mixte_id AS niveau_mixte_id_67 FROM avis a0_ LEFT JOIN `user` u1_ ON a0_.auteur_id = u1_.id WHERE a0_.note_plateforme IS NOT NULL AND a0_.statut_plateforme = 'valide' AND a0_.mis_en_avant_plateforme = 1 ORDER BY a0_.note_plateforme DESC, a0_.created_at DESC LIMIT 100;