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