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: Cablare structurata, automatizari instalatii electrice, alarme, sisteme alarma, sisteme securitate, paza si protectie, case inteligente, building management, tablouri de automatizare, aparate de masura si control
Expresii si cuvinte cheie: Lucrari de foraje orizontale pentru subtraversari de drumuri si cai ferate cu instalatie de foraj orizontal prin percutie . Diametre foraje orizontale 100 - 800 mm .