SQL = SELECT * FROM `baza` where `VIZIBIL` >= 1 and (MATCH (`OBIECT_ACTIVITATE`,`FIRMA`,`LOCALITATE`,`COD`) AGAINST (' corrado* electric*' IN BOOLEAN MODE)) 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")) and `COD` like 'Valcea%' order by `CREDITE` desc, `TVA` desc, `DATA` desc
Expresii si cuvinte cheie: Tehnico-Sanitare, Termo-Ventilatii, Climatizare, Electrice de Joasa si Medie Tensiune, Hidraulice sub Presiune, Tehnologice, Avertizare si Stingere Incendiu, Anti-Efractie, Sonorizare, Voce-Date, Traducere Simultana