SELECT COUNT(*) AS `no` FROM articles INNER JOIN cat_articole ON cat_articole.id_cat=articles.art_categ LEFT JOIN autori ON articles.autor_id_fk=autori.autor_id WHERE articles.a_activ LIKE "Da" AND (articles.a_title LIKE "%anre%" OR articles.a_text LIKE "%anre%" OR articles.a_author LIKE "%anre%" OR autori.autor_nume LIKE "%anre%" OR articles.a_keywords LIKE "%anre%" OR articles.a_metatitle LIKE "%anre%" )