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 "%studii de caz e-transport%" OR articles.a_keywords LIKE "%studii de caz e-transport%" OR articles.a_text LIKE "%studii de caz e-transport%" OR autori.autor_nume LIKE "%studii de caz e-transport%" ) AND articles.a_type LIKE "FREE"