SELECT count(tn.news_id) FROM `{DB_PREFIX}news` WHERE AS tn
LEFT OUTER JOIN {DB_PREFIX}news_cats AS tc ON tn.news_cat=tc.news_cat_id
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 'AS tn
LEFT OUTER JOIN bs_news_cats AS tc ON tn.news_cat=tc.news_cat_id' at line 1