SQL = SELECT * FROM `baza` where `VIZIBIL` >= 1 and (MATCH (`OBIECT_ACTIVITATE`,`FIRMA`,`LOCALITATE`,`COD`) AGAINST (' auto* pies* dube* dezmembrar*' IN BOOLEAN MODE)) or ((`OBIECT_ACTIVITATE` like "sdg %" or `FIRMA` like "sdg %" or `OBIECT_ACTIVITATE` like "% sdg %" or `FIRMA` like "% sdg %") or (`OBIECT_ACTIVITATE` like "sdg,%" or `FIRMA` like "sdg,%" or `OBIECT_ACTIVITATE` like "% sdg,%" or `FIRMA` like "% sdg,%" or `OBIECT_ACTIVITATE` like "% sdg" or `FIRMA` like "% sdg")) or ((`OBIECT_ACTIVITATE` like "din %" or `FIRMA` like "din %" or `OBIECT_ACTIVITATE` like "% din %" or `FIRMA` like "% din %") or (`OBIECT_ACTIVITATE` like "din,%" or `FIRMA` like "din,%" or `OBIECT_ACTIVITATE` like "% din,%" or `FIRMA` like "% din,%" or `OBIECT_ACTIVITATE` like "% din" or `FIRMA` like "% din")) and `COD` like 'Bihor%' 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