Notice: Undefined offset: 0 in /raid5/home/btttrave/public_html/modules/oferte-promotionale/actions.php on line 54

Notice: Undefined offset: 0 in /raid5/home/btttrave/public_html/modules/oferte-promotionale/actions.php on line 91
(SELECT s.id, s.nume, s.poza, s.descriere, s.pret_baza AS pret, s.url, 'sejur' AS tip FROM sejur s, tip_oferta t WHERE s.inex='' AND s.id_oferte_speciale=) UNION (SELECT s.id, s.nume, s.poza, s.descriere, s.pret_baza AS pret, s.url, 'pentru_tineri' AS tip FROM pentru_tineri s, tip_oferta t WHERE s.inex='' AND s.id_oferte_speciale=) UNION (SELECT s.id, s.nume, s.poza, s.descriere, s.pret_baza AS pret, s.url, 'circuit' AS tip FROM circuit s, tip_oferta t WHERE s.inex='' AND s.id_oferte_speciale=) UNION (SELECT o.id, o.nume, o.poza, o.descriere, o.pret_baza AS pret, o.url, 'oferta_cazare' AS tip FROM oferta_cazare o, cazare c, tip_oferta t WHERE o.inex='' AND o.id_oferte_speciale=)(SELECT s.inex, s.id, s.nume, s.poza, s.descriere, s.pret_baza AS pret, s.url, 'sejur' AS tip FROM sejur s, tip_oferta t WHERE s.inex='' AND s.id_oferte_speciale=) UNION (SELECT s.inex, s.id, s.nume, s.poza, s.descriere, s.pret_baza AS pret, s.url, 'pentru_tineri' AS tip FROM pentru_tineri s, tip_oferta t WHERE s.inex='' AND s.id_oferte_speciale=) UNION (SELECT s.inex, s.id, s.nume, s.poza, s.descriere, s.pret_baza AS pret, s.url, 'circuit' AS tip FROM circuit s, tip_oferta t WHERE s.inex='' AND s.id_oferte_speciale=) UNION (SELECT o.inex, o.id, o.nume, o.poza, o.descriere, o.pret_baza AS pret, o.url, 'oferta_cazare' AS tip FROM oferta_cazare o, cazare c, tip_oferta t WHERE o.inex='' AND o.id_oferte_speciale=) ORDER BY nume LIMIT 0, 9 (SELECT distinct(l.nume), l.id_oras FROM orase l, sejur s WHERE l.id_oras=s.id_oras AND s.inex='extern' AND s.id_oferte_speciale= ORDER BY l.nume) UNION (SELECT distinct(l.nume), l.id_oras FROM orase l, circuit s WHERE l.id_oras=s.id_oras AND s.inex='extern' AND s.id_oferte_speciale= ORDER BY l.nume) UNION (SELECT distinct(l.nume), l.id_oras FROM orase l, oferta_cazare o, cazare x WHERE l.id_oras=x.id_oras AND x.id=o.id_cazare AND o.inex='extern' AND o.id_oferte_speciale= ORDER BY l.nume)(SELECT distinct(l.nume), l.id_oras FROM orase l, sejur s WHERE l.id_oras=s.id_oras AND s.inex='extern' AND s.id_oferte_speciale= ORDER BY l.nume) UNION (SELECT distinct(l.nume), l.id_oras FROM orase l, circuit s WHERE l.id_oras=s.id_oras AND s.inex='extern' AND s.id_oferte_speciale= ORDER BY l.nume) UNION (SELECT distinct(l.nume), l.id_oras FROM orase l, oferta_cazare o, cazare x WHERE l.id_oras=x.id_oras AND x.id=o.id_cazare AND o.inex='extern' AND o.id_oferte_speciale= ORDER BY l.nume) LIMIT 10 vara - Oferte Promotionale - Agentia de turism BTT Travel


Campurile marcate cu * sunt obligatorii

Vara-2012

Oferte Promotionale

Filtru oferte:

1 rezultat

|

Sortare dupa:

Afiseaza:

  • 1
e

e

e

tarif / persoana:

e

  • 1