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:Agentia noastra va pune la dispozitie:
- cazari in hoteluri de toate categoriile din Turcia, Grecia, Spania, Italia, Egipt, Tunisia, Croatia, si litoralul Romanesc, la cele mai mici preturi.
- transport sigur si confortabil (Bilete de avion si bilete autocar).
- circuite turistice interne.
- asistenta turistica si asigurari medicale
CAUTARI FRECVENTE
inapoi 
1 2 3 4 5 6 7 8 9 10 
inainte 
urmatoarele