WE dégustation au Comptoir des Vignes de Montélimar

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'and post_status='publish' cm_comments WHERE comment_approved = '1' AND cm_pos...' at line 1]
SELECT ID, post_title, COUNT(cm_comments.comment_post_ID) AS 'stammy' FROM cm_posts, and post_status='publish' cm_comments WHERE comment_approved = '1' AND cm_posts.ID=cm_comments.comment_post_ID AND post_status = 'publish' AND post_date < '2024-04-26 06:40:47' AND post_date > '2023-04-26 06:40:47' AND comment_status = 'open' GROUP BY cm_comments.comment_post_ID ORDER BY stammy DESC LIMIT 3