SQL = SELECT * FROM `baza` where `VIZIBIL` >= 1 and (MATCH (`OBIECT_ACTIVITATE`,`FIRMA`,`LOCALITATE`,`COD`) AGAINST (' sticl* reflexiv* protecti* solar* negrest*' IN BOOLEAN MODE)) or ((`OBIECT_ACTIVITATE` like "oas %" or `FIRMA` like "oas %" or `OBIECT_ACTIVITATE` like "% oas %" or `FIRMA` like "% oas %") or (`OBIECT_ACTIVITATE` like "oas,%" or `FIRMA` like "oas,%" or `OBIECT_ACTIVITATE` like "% oas,%" or `FIRMA` like "% oas,%" or `OBIECT_ACTIVITATE` like "% oas" or `FIRMA` like "% oas")) and `COD` like 'Bihor%' order by `CREDITE` desc, `TVA` desc, `DATA` desc
Expresii si cuvinte cheie: Hale metalice cu sisteme ASTRON, constructii industriale si civile, lucrari de geniu, instalatii, electrice, pompe caldura, panouri solare, incalzire in pardoseala
Expresii si cuvinte cheie: Mountain bike, biciclete MERIDA, MONGOOSE, service biciclete, reparatii biciclete, sport extrem, maraton, test bike, articole ciclism, piese biciclete, accesorii biciclete, lubrifianti, anvelope, gel energizant, echipament protectie, rucsaci
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