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 edecision_post P, edecision_categorie C, edecision_user U ,edecision_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 = "www.ipup.fr" AND P.cat_id <= 16 AND P.post_dt <= NOW() AND post_pub = 1 ORDER BY post_dt DESC LIMIT -12,12