Blog

Unable to run pageCount (1)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 YEAR(ArticleDate)='2023'' at line 1SELECT count(DISTINCT a.id) as recCount FROM articles a INNER JOIN article_areas aa ON (a.ArticleAreaID=aa.id AND aa.Deleted=0) WHERE 1 AND a.`Deleted`=0 AND ArticleAreaID= AND YEAR(ArticleDate)='2023'