SQL = SELECT * FROM `baza` where `VIZIBIL` >= 1 and (MATCH (`OBIECT_ACTIVITATE`,`FIRMA`,`LOCALITATE`,`COD`) AGAINST (' program* gestiun* restaurant* program* gestiun* magazi*' IN BOOLEAN MODE)) or ((`OBIECT_ACTIVITATE` like "bar %" or `FIRMA` like "bar %" or `OBIECT_ACTIVITATE` like "% bar %" or `FIRMA` like "% bar %") or (`OBIECT_ACTIVITATE` like "bar,%" or `FIRMA` like "bar,%" or `OBIECT_ACTIVITATE` like "% bar,%" or `FIRMA` like "% bar,%" or `OBIECT_ACTIVITATE` like "% bar" or `FIRMA` like "% bar")) and `COD` like 'Bihor%' order by `CREDITE` desc, `TVA` desc, `DATA` desc
Expresii si cuvinte cheie: Hotel, aproape de gara si 800m stadion fotbal CFR, camere cu TV si internet, camere nefumatori, parcare gratuita, restaurant si bar (orar 7-22), mese festive, nunti, botezuri, evenimente business, receptii, intalniri afaceri, conferinte, seminarii, sala conferinta, cazare ieftina Cluj, regim hostel, hostel, hotel cluj
Expresii si cuvinte cheie: Autogara BETA Cluj Napoca, transport calatori, curse regulate spre Baia Mare, Oradea, Botosani, Deva, Brasov, Bucuresti - rute interne si Ungaria, Germania, Spania, Italia, Franta - rute internationale