SQL = SELECT * FROM `baza` where `VIZIBIL` >= 1 and (MATCH (`OBIECT_ACTIVITATE`,`FIRMA`,`LOCALITATE`,`COD`) AGAINST (' sector* bucurest*' IN BOOLEAN MODE)) or ((`OBIECT_ACTIVITATE` like "itp %" or `FIRMA` like "itp %" or `OBIECT_ACTIVITATE` like "% itp %" or `FIRMA` like "% itp %") or (`OBIECT_ACTIVITATE` like "itp,%" or `FIRMA` like "itp,%" or `OBIECT_ACTIVITATE` like "% itp,%" or `FIRMA` like "% itp,%" or `OBIECT_ACTIVITATE` like "% itp" or `FIRMA` like "% itp")) and `COD` like 'Bihor%' order by `CREDITE` desc, `TVA` desc, `DATA` desc
Expresii si cuvinte cheie: instalatii incalzire, instalatii electrice, instalatii de gaz, instalatii sanitare, instalatii alimentare cu apa, climatizare si ventilatie.
Expresii si cuvinte cheie: Sisteme de securitate, sisteme de alarma, afisaje electronice pentru transport, telefoane pentru convorbiri criptate, Solutii IT & Retelistica, GSMK CRYPTOPHONE, Mobitec, Thoreb