SQL = SELECT * FROM `baza` where `VIZIBIL` > 1 and `VIZIBIL` != 2801 and `COD` not like 'Timis' and (MATCH (`OBIECT_ACTIVITATE`,`FIRMA`,`LOCALITATE`,`COD`) AGAINST (' corporatio*' IN BOOLEAN MODE)) or ((`OBIECT_ACTIVITATE` like "inp %" or `FIRMA` like "inp %" or `OBIECT_ACTIVITATE` like "% inp %" or `FIRMA` like "% inp %") or (`OBIECT_ACTIVITATE` like "inp,%" or `FIRMA` like "inp,%" or `OBIECT_ACTIVITATE` like "% inp,%" or `FIRMA` like "% inp,%" or `OBIECT_ACTIVITATE` like "% inp" or `FIRMA` like "% inp")) 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: Certificat SR EN ISO 9001:2001, constructii civile, instalatii incalzire, electrice, constructii, termoizolatii fatade, acoperisuri, confectii metalice, case la cheie, sedii firme, amenajari exterioare, modernizari imobile, consolidari si restaurari cladiri, finisaje