SQL = SELECT * FROM `baza` where `VIZIBIL` >= 1 and (MATCH (`OBIECT_ACTIVITATE`,`FIRMA`,`LOCALITATE`,`COD`) AGAINST (' stati* camio* 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: Consultanta de mediu, elaborare studii de mediu, laborator analize mediu si Toxicologie Industriala: emisii, imisii, analize apa si sol, nivel zgomot, noxe profesionale, Audit energetic ARCE
Expresii si cuvinte cheie: Turnuri de racire in circuit deschis, turnuri de racire in circuit inchis, condensatoare evaporative, pachete de umplere, separatoare de picaturi, echipa tehnica pentru reparatii si mentenanta