SQL = SELECT * FROM `baza` where `VIZIBIL` > 1 and `VIZIBIL` != 2801 and `COD` not like 'Timis' and (MATCH (`OBIECT_ACTIVITATE`,`FIRMA`,`LOCALITATE`,`COD`) AGAINST (' timisoar*' IN BOOLEAN MODE)) or ((`OBIECT_ACTIVITATE` like "man %" or `FIRMA` like "man %" or `OBIECT_ACTIVITATE` like "% man %" or `FIRMA` like "% man %") or (`OBIECT_ACTIVITATE` like "man,%" or `FIRMA` like "man,%" or `OBIECT_ACTIVITATE` like "% man,%" or `FIRMA` like "% man,%" or `OBIECT_ACTIVITATE` like "% man" or `FIRMA` like "% man")) order by `CREDITE` desc, `TVA` desc, `DATA` desc
CAUTARI FRECVENTE
