SELECTa0_.idASid_0,a0_.contentAScontent_1,a0_.activeASactive_2,a0_.reply_notification_readASreply_notification_read_3,a0_.moderation_statusASmoderation_status_4,a0_.moderation_reasonASmoderation_reason_5,a0_.moderated_by_nameASmoderated_by_name_6,a0_.moderated_atASmoderated_at_7,a0_.created_atAScreated_at_8,s1_.idASid_9,s1_.usernameASusername_10,s1_.rolesASroles_11,s1_.passwordASpassword_12,s1_.emailASemail_13,s1_.telephoneAStelephone_14,s1_.cguAScgu_15,s1_.actifASactif_16,s1_.code_verifAScode_verif_17,s1_.date_creaASdate_crea_18,s1_.date_modifASdate_modif_19,s1_.code_tel_verifAScode_tel_verif_20,s1_.prefASpref_21,s1_.change_passASchange_pass_22,s1_.fermetureASfermeture_23,s1_.nicknameASnickname_24,s1_.nomASnom_25,s1_.prenomASprenom_26,s1_.date_naissanceASdate_naissance_27,s1_.avatarASavatar_28,s1_.comment_reply_email_enabledAScomment_reply_email_enabled_29,a2_.idASid_30,a2_.contentAScontent_31,a2_.activeASactive_32,a2_.reply_notification_readASreply_notification_read_33,a2_.moderation_statusASmoderation_status_34,a2_.moderation_reasonASmoderation_reason_35,a2_.moderated_by_nameASmoderated_by_name_36,a2_.moderated_atASmoderated_at_37,a2_.created_atAScreated_at_38,s3_.idASid_39,s3_.usernameASusername_40,s3_.rolesASroles_41,s3_.passwordASpassword_42,s3_.emailASemail_43,s3_.telephoneAStelephone_44,s3_.cguAScgu_45,s3_.actifASactif_46,s3_.code_verifAScode_verif_47,s3_.date_creaASdate_crea_48,s3_.date_modifASdate_modif_49,s3_.code_tel_verifAScode_tel_verif_50,s3_.prefASpref_51,s3_.change_passASchange_pass_52,s3_.fermetureASfermeture_53,s3_.nicknameASnickname_54,s3_.nomASnom_55,s3_.prenomASprenom_56,s3_.date_naissanceASdate_naissance_57,s3_.avatarASavatar_58,s3_.comment_reply_email_enabledAScomment_reply_email_enabled_59,a0_.article_idASarticle_id_60,a0_.user_idASuser_id_61,a0_.parent_idASparent_id_62,a2_.article_idASarticle_id_63,a2_.user_idASuser_id_64,a2_.parent_idASparent_id_65FROMarticle_commenta0_LEFT JOINsecur_users1_ONa0_.user_id=s1_.idLEFT JOINarticle_commenta2_ONa0_.id=a2_.parent_idAND (a2_.active=1AND (a2_.moderation_status=?)) LEFT JOINsecur_users3_ONa2_.user_id=s3_.idWHEREa0_.article_id=?ANDa0_.parent_idISNULLANDa0_.active=1AND (a0_.moderation_status=?) ORDER BYa0_.created_atDESC,a2_.created_atASC
SELECTa0_.idASid_0,a0_.contentAScontent_1,a0_.activeASactive_2,a0_.reply_notification_readASreply_notification_read_3,a0_.moderation_statusASmoderation_status_4,a0_.moderation_reasonASmoderation_reason_5,a0_.moderated_by_nameASmoderated_by_name_6,a0_.moderated_atASmoderated_at_7,a0_.created_atAScreated_at_8,s1_.idASid_9,s1_.usernameASusername_10,s1_.rolesASroles_11,s1_.passwordASpassword_12,s1_.emailASemail_13,s1_.telephoneAStelephone_14,s1_.cguAScgu_15,s1_.actifASactif_16,s1_.code_verifAScode_verif_17,s1_.date_creaASdate_crea_18,s1_.date_modifASdate_modif_19,s1_.code_tel_verifAScode_tel_verif_20,s1_.prefASpref_21,s1_.change_passASchange_pass_22,s1_.fermetureASfermeture_23,s1_.nicknameASnickname_24,s1_.nomASnom_25,s1_.prenomASprenom_26,s1_.date_naissanceASdate_naissance_27,s1_.avatarASavatar_28,s1_.comment_reply_email_enabledAScomment_reply_email_enabled_29,a2_.idASid_30,a2_.contentAScontent_31,a2_.activeASactive_32,a2_.reply_notification_readASreply_notification_read_33,a2_.moderation_statusASmoderation_status_34,a2_.moderation_reasonASmoderation_reason_35,a2_.moderated_by_nameASmoderated_by_name_36,a2_.moderated_atASmoderated_at_37,a2_.created_atAScreated_at_38,s3_.idASid_39,s3_.usernameASusername_40,s3_.rolesASroles_41,s3_.passwordASpassword_42,s3_.emailASemail_43,s3_.telephoneAStelephone_44,s3_.cguAScgu_45,s3_.actifASactif_46,s3_.code_verifAScode_verif_47,s3_.date_creaASdate_crea_48,s3_.date_modifASdate_modif_49,s3_.code_tel_verifAScode_tel_verif_50,s3_.prefASpref_51,s3_.change_passASchange_pass_52,s3_.fermetureASfermeture_53,s3_.nicknameASnickname_54,s3_.nomASnom_55,s3_.prenomASprenom_56,s3_.date_naissanceASdate_naissance_57,s3_.avatarASavatar_58,s3_.comment_reply_email_enabledAScomment_reply_email_enabled_59,a0_.article_idASarticle_id_60,a0_.user_idASuser_id_61,a0_.parent_idASparent_id_62,a2_.article_idASarticle_id_63,a2_.user_idASuser_id_64,a2_.parent_idASparent_id_65FROMarticle_commenta0_LEFT JOINsecur_users1_ONa0_.user_id=s1_.idLEFT JOINarticle_commenta2_ONa0_.id=a2_.parent_idAND (
a2_.active=1AND (a2_.moderation_status=?)
)
LEFT JOINsecur_users3_ONa2_.user_id=s3_.idWHEREa0_.article_id=?ANDa0_.parent_idISNULLANDa0_.active=1AND (a0_.moderation_status=?)
ORDER BYa0_.created_atDESC,a2_.created_atASC
SELECTa0_.idASid_0,a0_.contentAScontent_1,a0_.activeASactive_2,a0_.reply_notification_readASreply_notification_read_3,a0_.moderation_statusASmoderation_status_4,a0_.moderation_reasonASmoderation_reason_5,a0_.moderated_by_nameASmoderated_by_name_6,a0_.moderated_atASmoderated_at_7,a0_.created_atAScreated_at_8,s1_.idASid_9,s1_.usernameASusername_10,s1_.rolesASroles_11,s1_.passwordASpassword_12,s1_.emailASemail_13,s1_.telephoneAStelephone_14,s1_.cguAScgu_15,s1_.actifASactif_16,s1_.code_verifAScode_verif_17,s1_.date_creaASdate_crea_18,s1_.date_modifASdate_modif_19,s1_.code_tel_verifAScode_tel_verif_20,s1_.prefASpref_21,s1_.change_passASchange_pass_22,s1_.fermetureASfermeture_23,s1_.nicknameASnickname_24,s1_.nomASnom_25,s1_.prenomASprenom_26,s1_.date_naissanceASdate_naissance_27,s1_.avatarASavatar_28,s1_.comment_reply_email_enabledAScomment_reply_email_enabled_29,a2_.idASid_30,a2_.contentAScontent_31,a2_.activeASactive_32,a2_.reply_notification_readASreply_notification_read_33,a2_.moderation_statusASmoderation_status_34,a2_.moderation_reasonASmoderation_reason_35,a2_.moderated_by_nameASmoderated_by_name_36,a2_.moderated_atASmoderated_at_37,a2_.created_atAScreated_at_38,s3_.idASid_39,s3_.usernameASusername_40,s3_.rolesASroles_41,s3_.passwordASpassword_42,s3_.emailASemail_43,s3_.telephoneAStelephone_44,s3_.cguAScgu_45,s3_.actifASactif_46,s3_.code_verifAScode_verif_47,s3_.date_creaASdate_crea_48,s3_.date_modifASdate_modif_49,s3_.code_tel_verifAScode_tel_verif_50,s3_.prefASpref_51,s3_.change_passASchange_pass_52,s3_.fermetureASfermeture_53,s3_.nicknameASnickname_54,s3_.nomASnom_55,s3_.prenomASprenom_56,s3_.date_naissanceASdate_naissance_57,s3_.avatarASavatar_58,s3_.comment_reply_email_enabledAScomment_reply_email_enabled_59,a0_.article_idASarticle_id_60,a0_.user_idASuser_id_61,a0_.parent_idASparent_id_62,a2_.article_idASarticle_id_63,a2_.user_idASuser_id_64,a2_.parent_idASparent_id_65FROMarticle_commenta0_LEFT JOINsecur_users1_ONa0_.user_id=s1_.idLEFT JOINarticle_commenta2_ONa0_.id=a2_.parent_idAND (a2_.active=1AND (a2_.moderation_status='approved')) LEFT JOINsecur_users3_ONa2_.user_id=s3_.idWHEREa0_.article_id=2ANDa0_.parent_idISNULLANDa0_.active=1AND (a0_.moderation_status='approved') ORDER BYa0_.created_atDESC,a2_.created_atASC;
SELECTa0_.idASid_0,a0_.auteurASauteur_1,a0_.date_creaASdate_crea_2,a0_.date_modifASdate_modif_3,a0_.date_publiASdate_publi_4,a0_.actifASactif_5,a0_.latitudeASlatitude_6,a0_.longitudeASlongitude_7,a0_.views_countASviews_count_8,a0_.titre_idAStitre_id_9,a0_.texte_idAStexte_id_10,a0_.user_crea_idASuser_crea_id_11,a0_.user_modif_idASuser_modif_id_12,a0_.visuel_idASvisuel_id_13FROMarticlesa0_WHEREa0_.actif=1AND ((a0_.date_publiISNULLORa0_.date_publi<=?)) ORDER BYa0_.date_publiDESC,a0_.date_creaDESCLIMIT5
SELECTa0_.idASid_0,a0_.auteurASauteur_1,a0_.date_creaASdate_crea_2,a0_.date_modifASdate_modif_3,a0_.date_publiASdate_publi_4,a0_.actifASactif_5,a0_.latitudeASlatitude_6,a0_.longitudeASlongitude_7,a0_.views_countASviews_count_8,a0_.titre_idAStitre_id_9,a0_.texte_idAStexte_id_10,a0_.user_crea_idASuser_crea_id_11,a0_.user_modif_idASuser_modif_id_12,a0_.visuel_idASvisuel_id_13FROMarticlesa0_WHEREa0_.actif=1AND (
(
a0_.date_publiISNULLORa0_.date_publi<=?
)
)
ORDER BYa0_.date_publiDESC,a0_.date_creaDESCLIMIT5
SELECTa0_.idASid_0,a0_.auteurASauteur_1,a0_.date_creaASdate_crea_2,a0_.date_modifASdate_modif_3,a0_.date_publiASdate_publi_4,a0_.actifASactif_5,a0_.latitudeASlatitude_6,a0_.longitudeASlongitude_7,a0_.views_countASviews_count_8,a0_.titre_idAStitre_id_9,a0_.texte_idAStexte_id_10,a0_.user_crea_idASuser_crea_id_11,a0_.user_modif_idASuser_modif_id_12,a0_.visuel_idASvisuel_id_13FROMarticlesa0_WHEREa0_.actif=1AND ((a0_.date_publiISNULLORa0_.date_publi<='2026-10-13 20:48:02')) ORDER BYa0_.date_publiDESC,a0_.date_creaDESCLIMIT5;