SELECT P.post_id, post_chapo, post_chapo_wiki, post_content, post_content_wiki, post_notes, post_titre, post_titre_url, post_dt, post_upddt, post_creadt, post_pub, post_open_comment, post_open_tb, nb_comment, nb_trackback, post_lang, post_selected, U.user_id, U.user_nom, U.user_prenom, U.user_pseudo, U.user_email, DATE_FORMAT(post_dt,"%Y%m%d") AS postdate, DATE_FORMAT(post_dt,"%H:%i") AS posthour, DATE_FORMAT(post_dt,"%d") AS postday, DATE_FORMAT(post_dt,"%m") AS postmonth, DATE_FORMAT(post_dt,"%Y") AS postyear, P.cat_id, C.cat_libelle, C.cat_libelle_url FROM dc_post P LEFT OUTER JOIN dc_user U ON U.user_id = P.user_id LEFT OUTER JOIN dc_post_meta M ON P.post_id = M.post_id LEFT OUTER JOIN dc_categorie C ON P.cat_id = C.cat_id WHERE p.post_id > 1 AND meta_key = "tag" AND meta_value = "critique" AND P.post_dt <= '2013-05-19 18:02:47' AND C.cat_libelle_url != 'Videos-photos-sport-sexy' AND post_pub = 1 ORDER BY post_dt DESC LIMIT 0,7