SQL = SELECT * FROM `baza` where `VIZIBIL` >= 1 and (MATCH (`OBIECT_ACTIVITATE`,`FIRMA`,`LOCALITATE`,`COD`) AGAINST (' frizeri* solar*' IN BOOLEAN MODE)) or ((`OBIECT_ACTIVITATE` like "ana %" or `FIRMA` like "ana %" or `OBIECT_ACTIVITATE` like "% ana %" or `FIRMA` like "% ana %") or (`OBIECT_ACTIVITATE` like "ana,%" or `FIRMA` like "ana,%" or `OBIECT_ACTIVITATE` like "% ana,%" or `FIRMA` like "% ana,%" or `OBIECT_ACTIVITATE` like "% ana" or `FIRMA` like "% ana")) or ((`OBIECT_ACTIVITATE` like "bia %" or `FIRMA` like "bia %" or `OBIECT_ACTIVITATE` like "% bia %" or `FIRMA` like "% bia %") or (`OBIECT_ACTIVITATE` like "bia,%" or `FIRMA` like "bia,%" or `OBIECT_ACTIVITATE` like "% bia,%" or `FIRMA` like "% bia,%" or `OBIECT_ACTIVITATE` like "% bia" or `FIRMA` like "% bia")) and `COD` like 'Bihor%' order by `CREDITE` desc, `TVA` desc, `DATA` desc
Expresii si cuvinte cheie: Cazare Ocna Sugatag, pensiune, sala conferinte, terasa, restaurant, nunti, mese festive, turism, agroturism, excursii, vacante, concedii odihna, tratament balnear, plaja, piscine cu apa dulce si apa sarata, apa incalzita cu instalatie solara