SQL = SELECT * FROM `baza` where `VIZIBIL` >= 1 and (MATCH (`OBIECT_ACTIVITATE`,`FIRMA`,`LOCALITATE`,`COD`) AGAINST (' juli* star* impex*' IN BOOLEAN MODE)) 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 'satu mare%' order by `CREDITE` desc, `TVA` desc, `DATA` desc
Expresii si cuvinte cheie: Proiectare instalatii, instalatii constructii, service instalatii, service centrale termice si instalatii aer conditionat, autorizatii ISCIR, executie instalatii termice, instalatii si retele canalizare, instalatii apa, instalatii gaz, instalatii sanitare, instalatii ventilatie, instalatii panouri solare, service centrale termice, service microcentrale, service aer conditionat
Expresii si cuvinte cheie: Camin batrani, camin batrani, ingrijire batrani, casa batrani, azil, azil batrani, centru ingrijire batrani, sanatoriu, ingrijire boli paliative, recuperare medicala batrani, ingrigrijire persoane cu handicap, alzheimer, dementa, stare vegetativa, autism, schizofrenie