SQL = SELECT * FROM `baza` where `VIZIBIL` >= 1 and (MATCH (`OBIECT_ACTIVITATE`,`FIRMA`,`LOCALITATE`,`COD`) AGAINST (' agenti* plasar* fort* munc* strainatat* work* travel*' IN BOOLEAN MODE)) or ((`OBIECT_ACTIVITATE` like "and %" or `FIRMA` like "and %" or `OBIECT_ACTIVITATE` like "% and %" or `FIRMA` like "% and %") or (`OBIECT_ACTIVITATE` like "and,%" or `FIRMA` like "and,%" or `OBIECT_ACTIVITATE` like "% and,%" or `FIRMA` like "% and,%" or `OBIECT_ACTIVITATE` like "% and" or `FIRMA` like "% and")) or ((`OBIECT_ACTIVITATE` like "usa %" or `FIRMA` like "usa %" or `OBIECT_ACTIVITATE` like "% usa %" or `FIRMA` like "% usa %") or (`OBIECT_ACTIVITATE` like "usa,%" or `FIRMA` like "usa,%" or `OBIECT_ACTIVITATE` like "% usa,%" or `FIRMA` like "% usa,%" or `OBIECT_ACTIVITATE` like "% usa" or `FIRMA` like "% usa")) or ((`OBIECT_ACTIVITATE` like "dej %" or `FIRMA` like "dej %" or `OBIECT_ACTIVITATE` like "% dej %" or `FIRMA` like "% dej %") or (`OBIECT_ACTIVITATE` like "dej,%" or `FIRMA` like "dej,%" or `OBIECT_ACTIVITATE` like "% dej,%" or `FIRMA` like "% dej,%" or `OBIECT_ACTIVITATE` like "% dej" or `FIRMA` like "% dej")) and `COD` like 'Bihor%' order by `CREDITE` desc, `TVA` desc, `DATA` desc
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