select count(*) as total from ((articles a), articles_to_topics a2t) left join topics_description td on a2t.topics_id = td.topics_id left join authors au on a.authors_id = au.authors_id, articles_description ad where (a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) and a.articles_id = a2t.articles_id and a.articles_status = '1' and a.articles_id = ad.articles_id and ad.language_id = '2' and td.language_id = '2' and a.articles_date_added > SUBDATE(now( ), INTERVAL 'NEW_ARTICLES_DAYS_DISPLAY' DAY)
