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, dc_categorie C, dc_user U ,dc_post_meta M WHERE P.cat_id = C.cat_id AND U.user_id = P.user_id AND P.post_id = M.post_id AND meta_key = "tag" AND meta_value = "mail" AND post_pub = 1 ORDER BY post_dt DESC LIMIT 0,10