SQL = SELECT * FROM `baza` where `VIZIBIL` >= 1 and (MATCH (`OBIECT_ACTIVITATE`,`FIRMA`,`LOCALITATE`,`COD`) AGAINST (' cabinet* stomatologic* dent*' IN BOOLEAN MODE)) or ((`OBIECT_ACTIVITATE` like "meg %" or `FIRMA` like "meg %" or `OBIECT_ACTIVITATE` like "% meg %" or `FIRMA` like "% meg %") or (`OBIECT_ACTIVITATE` like "meg,%" or `FIRMA` like "meg,%" or `OBIECT_ACTIVITATE` like "% meg,%" or `FIRMA` like "% meg,%" or `OBIECT_ACTIVITATE` like "% meg" or `FIRMA` like "% meg")) 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 'Bihor%' order by `CREDITE` desc, `TVA` desc, `DATA` desc
Expresii si cuvinte cheie: Consultatii medicina muncii, analize laborator, analize medicale, control medical la angajare, control periodic, eliberarea fisei de aptitudine, supravegherea sanatatii angajatilor firmelor beneficiare, avize medicale periodice pentru incadrare in munca
Expresii si cuvinte cheie: servicii complete de medicina muncii. Asigur�m si deplas�ri la sediul clientului prin echipa noastr� mobil�, recoltarea de probe biologice si transportul acestora la laborator