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