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:Cabinet RECUPERARE, recuperare MEDICALA, medicina FIZICA, balneologie si climatologie, terapii si tratamente recuperatorii, reabilitare posttraumatica, reumatologica, respiratorie, cardiovasculara, recuperare diverse dizabilitati, persoane cu handicap
Expresii si cuvinte cheie: FizioTERAPIE, FIZIOterapie inalta - medie si joasa frecventa, terapie laser sau LASERterapie, masaj si kinetoterapie, termoterapie, fototerapie, terapii si tratamente recuperatorii, reabilitare posttraumatica, reumatologica, respiratorie, cardiovasculara, recuperare diverse dizabilitati, persoane cu handicap
Expresii si cuvinte cheie: Control medical la angajare si periodic, eliberarea fisei de aptitudine, supravegherea sanatatii angajatilor firmelor beneficiare, avize medicale periodice pentru incadrare in munca, cabinet medical dr. OPRIS IOAN SERGIU