Strona główna › Wyjazdy

Panel użytkownika

User:
Hasło:
Utwórz konto

Aktualne wyjazdy

Studenckie Ferie - luty

Francja, Studenckie ferie w Risoul vol.1
2012-02-03 - 2011-02-12 za 1299 Francja, Studenckie ferie w Risoul!
2012-02-10 - 2012-02-19 za 1399 Włochy, Studenckie Ferie w Val di Sole
2012-02-10 - 2012-02-19 za 699

Studenckie Free-Ski

Francja, Studenckie Les Orres - marcowy śnieg
2012-03-16 - 2012-03-25 za 1249 Włochy, Studenckie FreeSki w Val di Sole - VIP
2012-03-23 - 2012-04-01 za 1499 Włochy, Studenckie FreeSki w Val di Sole - Daolasa
2012-03-23 - 2012-04-01 za 1299 Włochy, Studenckie FreeSki w Val di Sole
2012-03-23 - 2012-04-01 za 1199 Włochy, Imprezowe Free Ski w Val di Sole!
2012-03-23 - 2012-04-01 za 1399

GRUPA na facebook'u


Studenckie ferie w Risoul vol.1 za 1299 pln!

Francja 2012-02-03 - 2011-02-12

Pozostało wolnych miejsc: lista rez.

Wysokość zaliczki: 500 pln

kultowe miejsce, skipass w cenie!

Więcej »

Studenckie ferie w Risoul! za 1399 pln!

Francja 2012-02-10 - 2012-02-19

Pozostało wolnych miejsc: lista rez.

Wysokość zaliczki: 500 pln

najlepsze stoki, gwarantowana pogoda, skipass w cenie!

Więcej »

Studenckie Ferie w Val di Sole za 699 pln!

Włochy 2012-02-10 - 2012-02-19

Pozostało wolnych miejsc: 4

Wysokość zaliczki: 500 pln

Włoskie słońce, aromatyczne espresso i białe szaleństwo!

Więcej »

Studenckie Les Orres - marcowy śnieg za 1249 pln!

Francja 2012-03-16 - 2012-03-25

Pozostało wolnych miejsc: TAK

Wysokość zaliczki: 500 pln

Skipass w cenie, basen

Więcej »

Studenckie FreeSki w Val di Sole za 1199 pln!

Włochy 2012-03-23 - 2012-04-01

Pozostało wolnych miejsc: Lista rez.

Wysokość zaliczki: 600 pln

Skipass w cenie, a do tego słoneczna pogoda i idealnie przygotowane 380km tras

Więcej »

Studenckie FreeSki w Val di Sole - VIP za 1499 pln!

Włochy 2012-03-23 - 2012-04-01

Pozostało wolnych miejsc: lista rez.

Wysokość zaliczki: 600 pln

Skipas SuperSkiRama w cenie, SPA w cenie

Więcej »

Studenckie FreeSki w Val di Sole - Daolasa za 1299 pln!

Włochy 2012-03-23 - 2012-04-01

Pozostało wolnych miejsc: TAK

Wysokość zaliczki: 600 pln

Skipass SuperSkiRama w cenie, miejsca przy wyciągach

Więcej »

Imprezowe Free Ski w Val di Sole! za 1399 pln!

Włochy 2012-03-23 - 2012-04-01

Pozostało wolnych miejsc: ponizej 5

Wysokość zaliczki: 600 pln

słońce, zabawa i karnet w cenie!

Więcej »

Strona 1 z 1. Pokazano 8 wyników z 8 wszystkich, zaczynając od wyniku 1, a kończąc na 8

<< poprzednie | | nastepne >>
  1. ››
  2. Newsy
  3. /
  4. Wyjazdy
  5. /
  6. Miejsca
  7. |
  8. Galeria
  9. \
  10. O nas
  11. \
  12. Kontakt
  13. 790738219, 692624392
  14. ‹‹
(default) 30 queries took 13 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT COUNT(*) AS `count` FROM `jaunts` AS `Jaunt` LEFT JOIN `placesflags` AS `Placesflag` ON (`Jaunt`.`placesflag_id` = `Placesflag`.`id`) WHERE `is_visible` = 1 110
2SELECT `Jaunt`.`id`, `Jaunt`.`title`, `Jaunt`.`sub_title`, `Jaunt`.`promotion_banner`, `Jaunt`.`is_visible`, `Jaunt`.`price_real`, `Jaunt`.`price_fake`, `Jaunt`.`free_steads_fake`, `Jaunt`.`2nd_payment`, `Jaunt`.`date_start`, `Jaunt`.`date_end`, `Jaunt`.`pre_payment`, `Placesflag`.`id`, `Placesflag`.`country`, `Placesflag`.`flag_img` FROM `jaunts` AS `Jaunt` LEFT JOIN `placesflags` AS `Placesflag` ON (`Jaunt`.`placesflag_id` = `Placesflag`.`id`) WHERE `is_visible` = 1 ORDER BY `Jaunt`.`date_start` asc LIMIT 20880
3SELECT `Sites`.`id`, `Sites`.`name`, `Sites`.`domain`, `Sites`.`is_active`, `Sites`.`layout_folder` FROM `sites` AS `Sites` WHERE `domain` = 'grupa.info' LIMIT 11112
4SELECT `Jauntsgroup`.`id`, `Jauntsgroup`.`name` FROM `jauntsgroups` AS `Jauntsgroup` WHERE 1 = 1 10100
5SELECT `Jauntsgrouplist`.`id`, `Jauntsgrouplist`.`jaunt_id`, `Jauntsgrouplist`.`jauntsgroup_id`, `Jaunt`.`id`, `Jaunt`.`title`, `Jaunt`.`site_id`, `Jaunt`.`date_start`, `Jaunt`.`is_visible`, `Jaunt`.`placesflag_id`, `Jaunt`.`date_end`, `Jaunt`.`price_real` FROM `jauntsgrouplists` AS `Jauntsgrouplist` LEFT JOIN `jaunts` AS `Jaunt` ON (`Jauntsgrouplist`.`jaunt_id` = `Jaunt`.`id`) WHERE `Jauntsgrouplist`.`jauntsgroup_id` = 1 AND `Jaunt`.`site_id` IN (1, 'zima', 'grupa.info', 1, 'zima_statyczna') AND `Jaunt`.`is_visible` = 1 ORDER BY `Jaunt`.`date_start` asc 001
6SELECT `Jauntsgrouplist`.`id`, `Jauntsgrouplist`.`jaunt_id`, `Jauntsgrouplist`.`jauntsgroup_id`, `Jaunt`.`id`, `Jaunt`.`title`, `Jaunt`.`site_id`, `Jaunt`.`date_start`, `Jaunt`.`is_visible`, `Jaunt`.`placesflag_id`, `Jaunt`.`date_end`, `Jaunt`.`price_real` FROM `jauntsgrouplists` AS `Jauntsgrouplist` LEFT JOIN `jaunts` AS `Jaunt` ON (`Jauntsgrouplist`.`jaunt_id` = `Jaunt`.`id`) WHERE `Jauntsgrouplist`.`jauntsgroup_id` = 2 AND `Jaunt`.`site_id` IN (1, 'zima', 'grupa.info', 1, 'zima_statyczna') AND `Jaunt`.`is_visible` = 1 ORDER BY `Jaunt`.`date_start` asc 000
7SELECT `Jauntsgrouplist`.`id`, `Jauntsgrouplist`.`jaunt_id`, `Jauntsgrouplist`.`jauntsgroup_id`, `Jaunt`.`id`, `Jaunt`.`title`, `Jaunt`.`site_id`, `Jaunt`.`date_start`, `Jaunt`.`is_visible`, `Jaunt`.`placesflag_id`, `Jaunt`.`date_end`, `Jaunt`.`price_real` FROM `jauntsgrouplists` AS `Jauntsgrouplist` LEFT JOIN `jaunts` AS `Jaunt` ON (`Jauntsgrouplist`.`jaunt_id` = `Jaunt`.`id`) WHERE `Jauntsgrouplist`.`jauntsgroup_id` = 3 AND `Jaunt`.`site_id` IN (1, 'zima', 'grupa.info', 1, 'zima_statyczna') AND `Jaunt`.`is_visible` = 1 ORDER BY `Jaunt`.`date_start` asc 000
8SELECT `Jauntsgrouplist`.`id`, `Jauntsgrouplist`.`jaunt_id`, `Jauntsgrouplist`.`jauntsgroup_id`, `Jaunt`.`id`, `Jaunt`.`title`, `Jaunt`.`site_id`, `Jaunt`.`date_start`, `Jaunt`.`is_visible`, `Jaunt`.`placesflag_id`, `Jaunt`.`date_end`, `Jaunt`.`price_real` FROM `jauntsgrouplists` AS `Jauntsgrouplist` LEFT JOIN `jaunts` AS `Jaunt` ON (`Jauntsgrouplist`.`jaunt_id` = `Jaunt`.`id`) WHERE `Jauntsgrouplist`.`jauntsgroup_id` = 5 AND `Jaunt`.`site_id` IN (1, 'zima', 'grupa.info', 1, 'zima_statyczna') AND `Jaunt`.`is_visible` = 1 ORDER BY `Jaunt`.`date_start` asc 000
9SELECT `Jauntsgrouplist`.`id`, `Jauntsgrouplist`.`jaunt_id`, `Jauntsgrouplist`.`jauntsgroup_id`, `Jaunt`.`id`, `Jaunt`.`title`, `Jaunt`.`site_id`, `Jaunt`.`date_start`, `Jaunt`.`is_visible`, `Jaunt`.`placesflag_id`, `Jaunt`.`date_end`, `Jaunt`.`price_real` FROM `jauntsgrouplists` AS `Jauntsgrouplist` LEFT JOIN `jaunts` AS `Jaunt` ON (`Jauntsgrouplist`.`jaunt_id` = `Jaunt`.`id`) WHERE `Jauntsgrouplist`.`jauntsgroup_id` = 6 AND `Jaunt`.`site_id` IN (1, 'zima', 'grupa.info', 1, 'zima_statyczna') AND `Jaunt`.`is_visible` = 1 ORDER BY `Jaunt`.`date_start` asc 000
10SELECT `Jauntsgrouplist`.`id`, `Jauntsgrouplist`.`jaunt_id`, `Jauntsgrouplist`.`jauntsgroup_id`, `Jaunt`.`id`, `Jaunt`.`title`, `Jaunt`.`site_id`, `Jaunt`.`date_start`, `Jaunt`.`is_visible`, `Jaunt`.`placesflag_id`, `Jaunt`.`date_end`, `Jaunt`.`price_real` FROM `jauntsgrouplists` AS `Jauntsgrouplist` LEFT JOIN `jaunts` AS `Jaunt` ON (`Jauntsgrouplist`.`jaunt_id` = `Jaunt`.`id`) WHERE `Jauntsgrouplist`.`jauntsgroup_id` = 7 AND `Jaunt`.`site_id` IN (1, 'zima', 'grupa.info', 1, 'zima_statyczna') AND `Jaunt`.`is_visible` = 1 ORDER BY `Jaunt`.`date_start` asc 000
11SELECT `Jauntsgrouplist`.`id`, `Jauntsgrouplist`.`jaunt_id`, `Jauntsgrouplist`.`jauntsgroup_id`, `Jaunt`.`id`, `Jaunt`.`title`, `Jaunt`.`site_id`, `Jaunt`.`date_start`, `Jaunt`.`is_visible`, `Jaunt`.`placesflag_id`, `Jaunt`.`date_end`, `Jaunt`.`price_real` FROM `jauntsgrouplists` AS `Jauntsgrouplist` LEFT JOIN `jaunts` AS `Jaunt` ON (`Jauntsgrouplist`.`jaunt_id` = `Jaunt`.`id`) WHERE `Jauntsgrouplist`.`jauntsgroup_id` = 8 AND `Jaunt`.`site_id` IN (1, 'zima', 'grupa.info', 1, 'zima_statyczna') AND `Jaunt`.`is_visible` = 1 ORDER BY `Jaunt`.`date_start` asc 000
12SELECT `Jauntsgrouplist`.`id`, `Jauntsgrouplist`.`jaunt_id`, `Jauntsgrouplist`.`jauntsgroup_id`, `Jaunt`.`id`, `Jaunt`.`title`, `Jaunt`.`site_id`, `Jaunt`.`date_start`, `Jaunt`.`is_visible`, `Jaunt`.`placesflag_id`, `Jaunt`.`date_end`, `Jaunt`.`price_real` FROM `jauntsgrouplists` AS `Jauntsgrouplist` LEFT JOIN `jaunts` AS `Jaunt` ON (`Jauntsgrouplist`.`jaunt_id` = `Jaunt`.`id`) WHERE `Jauntsgrouplist`.`jauntsgroup_id` = 9 AND `Jaunt`.`site_id` IN (1, 'zima', 'grupa.info', 1, 'zima_statyczna') AND `Jaunt`.`is_visible` = 1 ORDER BY `Jaunt`.`date_start` asc 000
13SELECT `Jauntsgrouplist`.`id`, `Jauntsgrouplist`.`jaunt_id`, `Jauntsgrouplist`.`jauntsgroup_id`, `Jaunt`.`id`, `Jaunt`.`title`, `Jaunt`.`site_id`, `Jaunt`.`date_start`, `Jaunt`.`is_visible`, `Jaunt`.`placesflag_id`, `Jaunt`.`date_end`, `Jaunt`.`price_real` FROM `jauntsgrouplists` AS `Jauntsgrouplist` LEFT JOIN `jaunts` AS `Jaunt` ON (`Jauntsgrouplist`.`jaunt_id` = `Jaunt`.`id`) WHERE `Jauntsgrouplist`.`jauntsgroup_id` = 10 AND `Jaunt`.`site_id` IN (1, 'zima', 'grupa.info', 1, 'zima_statyczna') AND `Jaunt`.`is_visible` = 1 ORDER BY `Jaunt`.`date_start` asc 330
14SELECT `Jaunt`.`id`, `Jaunt`.`title`, `Jaunt`.`site_id`, `Jaunt`.`date_start`, `Jaunt`.`is_visible`, `Jaunt`.`placesflag_id`, `Jaunt`.`date_end`, `Jaunt`.`price_real` FROM `jaunts` AS `Jaunt` WHERE `Jaunt`.`id` = 60 110
15SELECT `Placesflag`.`country`, `Placesflag`.`id`, `Placesflag`.`flag_img` FROM `placesflags` AS `Placesflag` WHERE `Placesflag`.`id` = 1 110
16SELECT `Jaunt`.`id`, `Jaunt`.`title`, `Jaunt`.`site_id`, `Jaunt`.`date_start`, `Jaunt`.`is_visible`, `Jaunt`.`placesflag_id`, `Jaunt`.`date_end`, `Jaunt`.`price_real` FROM `jaunts` AS `Jaunt` WHERE `Jaunt`.`id` = 52 110
17SELECT `Placesflag`.`country`, `Placesflag`.`id`, `Placesflag`.`flag_img` FROM `placesflags` AS `Placesflag` WHERE `Placesflag`.`id` = 1 110
18SELECT `Jaunt`.`id`, `Jaunt`.`title`, `Jaunt`.`site_id`, `Jaunt`.`date_start`, `Jaunt`.`is_visible`, `Jaunt`.`placesflag_id`, `Jaunt`.`date_end`, `Jaunt`.`price_real` FROM `jaunts` AS `Jaunt` WHERE `Jaunt`.`id` = 55 110
19SELECT `Placesflag`.`country`, `Placesflag`.`id`, `Placesflag`.`flag_img` FROM `placesflags` AS `Placesflag` WHERE `Placesflag`.`id` = 2 110
20SELECT `Jauntsgrouplist`.`id`, `Jauntsgrouplist`.`jaunt_id`, `Jauntsgrouplist`.`jauntsgroup_id`, `Jaunt`.`id`, `Jaunt`.`title`, `Jaunt`.`site_id`, `Jaunt`.`date_start`, `Jaunt`.`is_visible`, `Jaunt`.`placesflag_id`, `Jaunt`.`date_end`, `Jaunt`.`price_real` FROM `jauntsgrouplists` AS `Jauntsgrouplist` LEFT JOIN `jaunts` AS `Jaunt` ON (`Jauntsgrouplist`.`jaunt_id` = `Jaunt`.`id`) WHERE `Jauntsgrouplist`.`jauntsgroup_id` = 11 AND `Jaunt`.`site_id` IN (1, 'zima', 'grupa.info', 1, 'zima_statyczna') AND `Jaunt`.`is_visible` = 1 ORDER BY `Jaunt`.`date_start` asc 550
21SELECT `Jaunt`.`id`, `Jaunt`.`title`, `Jaunt`.`site_id`, `Jaunt`.`date_start`, `Jaunt`.`is_visible`, `Jaunt`.`placesflag_id`, `Jaunt`.`date_end`, `Jaunt`.`price_real` FROM `jaunts` AS `Jaunt` WHERE `Jaunt`.`id` = 66 110
22SELECT `Placesflag`.`country`, `Placesflag`.`id`, `Placesflag`.`flag_img` FROM `placesflags` AS `Placesflag` WHERE `Placesflag`.`id` = 1 110
23SELECT `Jaunt`.`id`, `Jaunt`.`title`, `Jaunt`.`site_id`, `Jaunt`.`date_start`, `Jaunt`.`is_visible`, `Jaunt`.`placesflag_id`, `Jaunt`.`date_end`, `Jaunt`.`price_real` FROM `jaunts` AS `Jaunt` WHERE `Jaunt`.`id` = 62 110
24SELECT `Placesflag`.`country`, `Placesflag`.`id`, `Placesflag`.`flag_img` FROM `placesflags` AS `Placesflag` WHERE `Placesflag`.`id` = 2 110
25SELECT `Jaunt`.`id`, `Jaunt`.`title`, `Jaunt`.`site_id`, `Jaunt`.`date_start`, `Jaunt`.`is_visible`, `Jaunt`.`placesflag_id`, `Jaunt`.`date_end`, `Jaunt`.`price_real` FROM `jaunts` AS `Jaunt` WHERE `Jaunt`.`id` = 69 110
26SELECT `Placesflag`.`country`, `Placesflag`.`id`, `Placesflag`.`flag_img` FROM `placesflags` AS `Placesflag` WHERE `Placesflag`.`id` = 2 110
27SELECT `Jaunt`.`id`, `Jaunt`.`title`, `Jaunt`.`site_id`, `Jaunt`.`date_start`, `Jaunt`.`is_visible`, `Jaunt`.`placesflag_id`, `Jaunt`.`date_end`, `Jaunt`.`price_real` FROM `jaunts` AS `Jaunt` WHERE `Jaunt`.`id` = 56 110
28SELECT `Placesflag`.`country`, `Placesflag`.`id`, `Placesflag`.`flag_img` FROM `placesflags` AS `Placesflag` WHERE `Placesflag`.`id` = 2 110
29SELECT `Jaunt`.`id`, `Jaunt`.`title`, `Jaunt`.`site_id`, `Jaunt`.`date_start`, `Jaunt`.`is_visible`, `Jaunt`.`placesflag_id`, `Jaunt`.`date_end`, `Jaunt`.`price_real` FROM `jaunts` AS `Jaunt` WHERE `Jaunt`.`id` = 71 110
30SELECT `Placesflag`.`country`, `Placesflag`.`id`, `Placesflag`.`flag_img` FROM `placesflags` AS `Placesflag` WHERE `Placesflag`.`id` = 2 110