SQL = SELECT * FROM `baza` where `VIZIBIL` >= 1 and (MATCH (`OBIECT_ACTIVITATE`,`FIRMA`,`LOCALITATE`,`COD`) AGAINST (' +rosu* +hearer* +advertising* +agency*' IN BOOLEAN MODE)) and ((`OBIECT_ACTIVITATE` like "aud %" or `FIRMA` like "aud %" or `OBIECT_ACTIVITATE` like "% aud %" or `FIRMA` like "% aud %") or (`OBIECT_ACTIVITATE` like "aud,%" or `FIRMA` like "aud,%" or `OBIECT_ACTIVITATE` like "% aud,%" or `FIRMA` like "% aud,%" or `OBIECT_ACTIVITATE` like "% aud" or `FIRMA` like "% aud")) and ((`OBIECT_ACTIVITATE` like "the %" or `FIRMA` like "the %" or `OBIECT_ACTIVITATE` like "% the %" or `FIRMA` like "% the %") or (`OBIECT_ACTIVITATE` like "the,%" or `FIRMA` like "the,%" or `OBIECT_ACTIVITATE` like "% the,%" or `FIRMA` like "% the,%" or `OBIECT_ACTIVITATE` like "% the" or `FIRMA` like "% the")) and ((`OBIECT_ACTIVITATE` like "red %" or `FIRMA` like "red %" or `OBIECT_ACTIVITATE` like "% red %" or `FIRMA` like "% red %") or (`OBIECT_ACTIVITATE` like "red,%" or `FIRMA` like "red,%" or `OBIECT_ACTIVITATE` like "% red,%" or `FIRMA` like "% red,%" or `OBIECT_ACTIVITATE` like "% red" or `FIRMA` like "% red")) and `COD` like 'satu mare%' order by `CREDITE` desc, `TVA` desc, `DATA` desc