Erreur SQL !
SELECT p.id_blog_post, pl.title, pl.excerpt, pl.link_rewrite, p.date_on, p.allow_comments FROM ps_blog_post p, ps_blog_post_lang pl WHERE pl.id_blog_post = p.id_blog_post AND pl.id_lang = 2 AND p.status = "published" AND NOW()>=p.date_on ORDER BY p.date_on DESC, p.id_blog_post DESC LIMIT 0, 10