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