SQL = SELECT * FROM `baza` where `VIZIBIL` > 1 and `VIZIBIL` != 2801 and `COD` not like 'Timis' and (MATCH (`OBIECT_ACTIVITATE`,`FIRMA`,`LOCALITATE`,`COD`) AGAINST (' leader* company*' IN BOOLEAN MODE)) or ((`OBIECT_ACTIVITATE` like "rom %" or `FIRMA` like "rom %" or `OBIECT_ACTIVITATE` like "% rom %" or `FIRMA` like "% rom %") or (`OBIECT_ACTIVITATE` like "rom,%" or `FIRMA` like "rom,%" or `OBIECT_ACTIVITATE` like "% rom,%" or `FIRMA` like "% rom,%" or `OBIECT_ACTIVITATE` like "% rom" or `FIRMA` like "% rom")) or ((`OBIECT_ACTIVITATE` like "ltd %" or `FIRMA` like "ltd %" or `OBIECT_ACTIVITATE` like "% ltd %" or `FIRMA` like "% ltd %") or (`OBIECT_ACTIVITATE` like "ltd,%" or `FIRMA` like "ltd,%" or `OBIECT_ACTIVITATE` like "% ltd,%" or `FIRMA` like "% ltd,%" or `OBIECT_ACTIVITATE` like "% ltd" or `FIRMA` like "% ltd")) or ((`OBIECT_ACTIVITATE` like "srl %" or `FIRMA` like "srl %" or `OBIECT_ACTIVITATE` like "% srl %" or `FIRMA` like "% srl %") or (`OBIECT_ACTIVITATE` like "srl,%" or `FIRMA` like "srl,%" or `OBIECT_ACTIVITATE` like "% srl,%" or `FIRMA` like "% srl,%" or `OBIECT_ACTIVITATE` like "% srl" or `FIRMA` like "% srl")) order by `CREDITE` desc, `TVA` desc, `DATA` desc
Expresii si cuvinte cheie: Consultanta pentru afaceri, implementare sisteme de management, consultanta, consiliere pentru acreditare CoNAS spitale, alte forme de invatamant