SQL = SELECT * FROM `baza` where `VIZIBIL` > 1 and `VIZIBIL` != 2801 and `COD` not like 'Timis' and (MATCH (`OBIECT_ACTIVITATE`,`FIRMA`,`LOCALITATE`,`COD`) AGAINST (' tabl* tigl*' IN BOOLEAN MODE)) or ((`OBIECT_ACTIVITATE` like "tip %" or `FIRMA` like "tip %" or `OBIECT_ACTIVITATE` like "% tip %" or `FIRMA` like "% tip %") or (`OBIECT_ACTIVITATE` like "tip,%" or `FIRMA` like "tip,%" or `OBIECT_ACTIVITATE` like "% tip,%" or `FIRMA` like "% tip,%" or `OBIECT_ACTIVITATE` like "% tip" or `FIRMA` like "% tip")) 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: Instalatii electrice si automatizari instalatii detectie si alarmare incendiu instalatii de compensare a energiei reactive Proiectarea instalatiilor de detectie si alarmare la incendiu Executia si verificarea prizelor de pamant Revizia si intretinerea instalatiilor electrice