get() SELECT COUNT(*) AS `no` FROM articles, autori WHERE articles.autor_id_fk=autori.autor_id AND ((articles.a_date IS NOT NULL && articles.a_date<=NOW())) AND(articles.a_title LIKE "%datorii%" OR articles.a_keywords LIKE "%datorii%" OR articles.a_text LIKE "%datorii%" OR autori.autor_nume LIKE "%datorii%" ) AND articles.a_type LIKE "FREE"