(total: 0,0117s, gain: 0.01170s, memory: 1270,23kB) string(30) "ChartersInfoModulesearchFormBM"
 (total: 0,0132s, gain: 0.00144s, memory: 1301,93kB) array(2) {
  ["location"] => array(1) {
    [0] => int(191)
  }
  ["boatType"] => array(1) {
    [0] => string(9) "Sail boat"
  }
}
 (total: 0,0138s, gain: 0.00068s, memory: 1303,59kB) array(0) {
}
 (total: 0,0341s, gain: 0.02031s, memory: 1810,19kB) string(30) "ChartersInfoModulesearchFormBM"
 (total: 0,2181s, gain: 0.18392s, memory: 2108,27kB) string(30) "ChartersInfoModuleidentifyCode"
 (total: 0,3872s, gain: 0.16919s, memory: 2127,4kB) string(43) "ChartersInfoModulechartersFirstLastMinuteBM"
 (total: 0,3874s, gain: 0.00012s, memory: 2128,1kB) string(10) "2021-06-26"
 (total: 0,3876s, gain: 0.00028s, memory: 2136,02kB) array(0) {
}
 (total: 0,3877s, gain: 0.00003s, memory: 2136,07kB) NULL
 (total: 0,389s, gain: 0.00128s, memory: 2150,77kB) string(4837) "
             SELECT r.id
             ,  r.`id` as '__id' , r.`companyid` as '__companyid' , r.`cgid` as '__cgid' , r.`created` as '__created' , r.`updated` as '__updated' , r.`resource_id` as '__resource_id' , r.`gid` as '__gid' , r.`name` as '__name' , r.`base` as '__base' , r.`model` as '__model' , r.`berths` as '__berths' , r.`berthsext` as '__berthsext' , r.`year` as '__year' , r.`length` as '__length' , r.`cabins` as '__cabins' , r.`cabinsext` as '__cabinsext' , r.`heads` as '__heads' , r.`watercapacity` as '__watercapacity' , r.`fuelcapacity` as '__fuelcapacity' , r.`engine` as '__engine' , r.`deposit` as '__deposit' , r.`depositwithwaiver` as '__depositwithwaiver' , r.`commissionpercentage` as '__commissionpercentage' , r.`kind` as '__kind' , r.`draught` as '__draught' , r.`beam` as '__beam' , r.`lengthatwaterline` as '__lengthatwaterline' , r.`maximumdiscount` as '__maximumdiscount' , r.`servicetype` as '__servicetype' , r.`discountshavesubtotals` as '__discountshavesubtotals' , r.`defaultcheckintime` as '__defaultcheckintime' , r.`defaultcheckouttime` as '__defaultcheckouttime' , r.`calculateagencydiscountwithoutvat` as '__calculateagencydiscountwithoutvat' , r.`taxableamount` as '__taxableamount' , r.`taxrate` as '__taxrate' , r.`genericresourcetypename` as '__genericresourcetypename' , r.`defaultcheckinday` as '__defaultcheckinday' , r.`codeid` as '__codeid' , r.`transitlog` as '__transitlog' , r.`defaultcleaningcost` as '__defaultcleaningcost' , r.`shipyardid` as '__shipyardid' , r.`saleprice` as '__saleprice' , r.`requiredskipperlicense` as '__requiredskipperlicense' , r.`ownerid` as '__ownerid' , r.`mainsail` as '__mainsail' , r.`genoa` as '__genoa' , r.`defaultbaseid` as '__defaultbaseid' , r.`maxPeopleOnBoard` as '__maxPeopleOnBoard' 
             , r.id as __boatid
             ,r.name as boatName
             ,r.model as name
             ,r.kind as boatKind
             ,r.year as built
             ,r.berths as berth
             ,b.country as __country
             ,b.name as ___base
             # ,CONCAT(IFNULL(country.name_cs,'-') , ' / ', IFNULL(region.name,'-'), ' / ', b.name) as location
             ,CONCAT(b.name, ' - ', IFNULL(region.name,'-'), ' - ', IFNULL(country.name_cs,'-')) as location
             # , region.name as location
             ,  (( a.blocksavailability ))  as __bookState
             ,c.name as __charterName
             ,CONCAT('/hledani2/', REPLACE( LOWER(r.kind),' ', '-'), '/neco/', r.id, '/') as __boatUri
             # , 0+( fp.price * 0.01 * (100 -  IF(r.commissionpercentage <= 17, 3, 6) ) ) as priceTotal
             , IF(0+( fp.price * 0.01 * (100 -  IF(r.commissionpercentage <= 17, 3, 6) ) ) <= 0 OR 0+( fp.price * 0.01 * (100 -  IF(r.commissionpercentage <= 17, 3, 6) ) ) IS NULL, 999999, 0+( fp.price * 0.01 * (100 -  IF(r.commissionpercentage <= 17, 3, 6) ) )) as priceTotal
             , IF(0+( fp.price * 0.01 * (100 -  IF(r.commissionpercentage <= 17, 3, 6) ) ) <= 0 OR 0+( fp.price * 0.01 * (100 -  IF(r.commissionpercentage <= 17, 3, 6) ) ) IS NULL, 999999, 0+( fp.price * 0.01 * (100 -  IF(r.commissionpercentage <= 17, 3, 6) ) )) as __priceSort
             , 0+( fp.startPrice ) as __priceWithoutDiscount
             ,  ((( fp.discountPercentage +  IF(r.commissionpercentage <= 17, 3, 6)  ))/1)  as __procenta

        FROM
        bm_resources r

        JOIN bm_companies c ON c.company_id = r.companyid
                                              JOIN bm_bases b
                                              ON b.base_id = r.base
                                              LEFT JOIN bm_bases_regions br
                                              ON br.base_id = b.id
                                              LEFT JOIN bm_regions region
                                              ON region.region_id = br.regionid
                                              LEFT JOIN bm_countries country
                                              ON country.country_id = b.countryid
                                                       LEFT JOIN bm_resource_availability_reservations a
                          ON a.blocksavailability = 1
                                                    AND ( a.datefrom <= '2021-07-02' AND a.dateto > '2021-06-26' )
                                                    AND a.resource_id = r.id 
                                                      
                               LEFT JOIN bm_resource_finalprices fp
                               ON fp.yachtId = r.resource_id
                                AND fp.dateFrom = '2021-06-26' AND fp.tripDuration = 7
                                                      WHERE 1
         AND r.kind = 'Sail boat'  AND b.countryid = 191 AND a.id IS NULL 


        GROUP BY r.id
         ORDER BY __procenta DESC LIMIT 2"
 (total: 0,3898s, gain: 0.00087s, memory: 2199,31kB) array(69) {
  ["id"] => string(5) "64455"
  ["__id"] => string(5) "64455"
  ["__companyid"] => string(4) "1557"
  ["__cgid"] => string(20) "28101135000010000042"
  ["__created"] => string(19) "2020-05-25 06:25:29"
  ["__updated"] => string(19) "2021-06-22 13:11:18"
  ["__resource_id"] => string(19) "1373561140000101557"
  ["__gid"] => string(18) "281011350000100000"
  ["__name"] => string(6) "CANCAN"
  ["__base"] => string(1) "6"
  ["__model"] => string(19) "Oceanis 45 (4 cabs)"
  ["__berths"] => string(1) "8"
  ["__berthsext"] => string(4) "8 +2"
  ["__year"] => string(4) "2018"
  ["__length"] => string(5) "13.85"
  ["__cabins"] => string(1) "4"
  ["__cabinsext"] => string(1) "4"
  ["__heads"] => string(1) "2"
  ["__watercapacity"] => string(8) "530.00 l"
  ["__fuelcapacity"] => string(8) "200.00 l"
  ["__engine"] => string(5) "54 HP"
  ["__deposit"] => string(7) "2000.00"
  ["__depositwithwaiver"] => string(4) "0.00"
  ["__commissionpercentage"] => string(5) "20.00"
  ["__kind"] => string(9) "Sail boat"
  ["__draught"] => string(4) "2.15"
  ["__beam"] => string(4) "4.49"
  ["__lengthatwaterline"] => string(5) "13.50"
  ["__maximumdiscount"] => string(5) "10.00"
  ["__servicetype"] => string(8) "Bareboat"
  ["__discountshavesubtotals"] => string(1) "1"
  ["__defaultcheckintime"] => string(5) "17:00"
  ["__defaultcheckouttime"] => string(5) "09:00"
  ["__calculateagencydiscountwithoutvat"] => string(1) "0"
  ["__taxableamount"] => string(6) "100.00"
  ["__taxrate"] => string(4) "0.00"
  ["__genericresourcetypename"] => string(13) "Oceanis 45[G]"
  ["__defaultcheckinday"] => string(1) "7"
  ["__codeid"] => string(2) "12"
  ["__transitlog"] => string(6) "150.00"
  ["__defaultcleaningcost"] => string(3) ".00"
  ["__shipyardid"] => string(1) "5"
  ["__saleprice"] => string(0) ""
  ["__requiredskipperlicense"] => string(1) "1"
  ["__ownerid"] => string(2) "-1"
  ["__mainsail"] => string(11) "Full batten"
  ["__genoa"] => string(7) "Furling"
  ["__defaultbaseid"] => string(1) "6"
  ["__maxPeopleOnBoard"] => string(2) "-1"
  ["__boatid"] => string(5) "64455"
  ["boatName"] => string(6) "CANCAN"
  ["name"] => string(19) "Oceanis 45 (4 cabs)"
  ["boatKind"] => string(9) "Sail boat"
  ["built"] => string(4) "2018"
  ["berth"] => string(1) "8"
  ["__country"] => string(2) "HR"
  ["___base"] => string(12) "Marina Punat"
  ["location"] => string(44) "Marina Punat - Istria / Kvarner - Chorvatsko"
  ["__bookState"] => NULL
  ["__charterName"] => string(11) "Simple Sail"
  ["__boatUri"] => string(51) "/pronajem-lodi/plachetnice/oceanis-45/64455-cancan/"
  ["priceTotal"] => string(7) "2162.00"
  ["__priceSort"] => string(7) "2162.00"
  ["__priceWithoutDiscount"] => string(4) "4600"
  ["__procenta"] => string(7) "56.0000"
  ["__cena"] => string(4) "4600"
  ["od"] => string(10) "2021-06-26"
  ["__doFW"] => string(10) "2021-07-02"
  ["__type"] => string(4) "last"
}
 (total: 0,3902s, gain: 0.00037s, memory: 2199,73kB) array(69) {
  ["id"] => string(5) "69388"
  ["__id"] => string(5) "69388"
  ["__companyid"] => string(3) "109"
  ["__cgid"] => string(18) "509322820000100000"
  ["__created"] => string(19) "2020-05-25 11:56:12"
  ["__updated"] => string(19) "2021-06-22 05:32:47"
  ["__resource_id"] => string(17) "74490210374800109"
  ["__gid"] => string(18) "509322820000100000"
  ["__name"] => string(4) "Moon"
  ["__base"] => string(2) "12"
  ["__model"] => string(17) "Bavaria 51 BT '17"
  ["__berths"] => string(2) "12"
  ["__berthsext"] => string(2) "12"
  ["__year"] => string(4) "2017"
  ["__length"] => string(5) "15.59"
  ["__cabins"] => string(1) "5"
  ["__cabinsext"] => string(1) "5"
  ["__heads"] => string(1) "3"
  ["__watercapacity"] => string(8) "560.00 l"
  ["__fuelcapacity"] => string(8) "280.00 l"
  ["__engine"] => string(17) "75 hp Volvo Penta"
  ["__deposit"] => string(7) "2000.00"
  ["__depositwithwaiver"] => string(4) "0.00"
  ["__commissionpercentage"] => string(5) "20.00"
  ["__kind"] => string(9) "Sail boat"
  ["__draught"] => string(4) "2.25"
  ["__beam"] => string(4) "4.67"
  ["__lengthatwaterline"] => string(0) ""
  ["__maximumdiscount"] => string(5) "30.00"
  ["__servicetype"] => string(8) "Bareboat"
  ["__discountshavesubtotals"] => string(1) "0"
  ["__defaultcheckintime"] => string(5) "17:00"
  ["__defaultcheckouttime"] => string(5) "09:00"
  ["__calculateagencydiscountwithoutvat"] => string(1) "1"
  ["__taxableamount"] => string(6) "100.00"
  ["__taxrate"] => string(5) "13.00"
  ["__genericresourcetypename"] => string(21) "Bavaria Cruiser 51[G]"
  ["__defaultcheckinday"] => string(1) "7"
  ["__codeid"] => string(5) "30007"
  ["__transitlog"] => string(1) "0"
  ["__defaultcleaningcost"] => string(3) ".00"
  ["__shipyardid"] => string(1) "1"
  ["__saleprice"] => string(0) ""
  ["__requiredskipperlicense"] => string(1) "1"
  ["__ownerid"] => string(2) "-1"
  ["__mainsail"] => string(7) "Furling"
  ["__genoa"] => string(7) "Furling"
  ["__defaultbaseid"] => string(2) "12"
  ["__maxPeopleOnBoard"] => string(2) "-1"
  ["__boatid"] => string(5) "69388"
  ["boatName"] => string(4) "Moon"
  ["name"] => string(17) "Bavaria 51 BT '17"
  ["boatKind"] => string(9) "Sail boat"
  ["built"] => string(4) "2017"
  ["berth"] => string(2) "12"
  ["__country"] => string(2) "HR"
  ["___base"] => string(24) "Marina D-Marin Dalmacija"
  ["location"] => string(45) "Marina D-Marin Dalmacija - Zadar - Chorvatsko"
  ["__bookState"] => NULL
  ["__charterName"] => string(16) "Adriatic Charter"
  ["__boatUri"] => string(49) "/pronajem-lodi/plachetnice/bavaria-51/69388-moon/"
  ["priceTotal"] => string(7) "2732.58"
  ["__priceSort"] => string(7) "2732.58"
  ["__priceWithoutDiscount"] => string(4) "5100"
  ["__procenta"] => string(7) "49.0000"
  ["__cena"] => string(4) "5100"
  ["od"] => string(10) "2021-06-26"
  ["__doFW"] => string(10) "2021-07-02"
  ["__type"] => string(4) "last"
}
 (total: 0,3903s, gain: 0.00014s, memory: 2181,85kB) array(2) {
  [0] => array(69) {
    ["id"] => string(5) "64455"
    ["__id"] => string(5) "64455"
    ["__companyid"] => string(4) "1557"
    ["__cgid"] => string(20) "28101135000010000042"
    ["__created"] => string(19) "2020-05-25 06:25:29"
    ["__updated"] => string(19) "2021-06-22 13:11:18"
    ["__resource_id"] => string(19) "1373561140000101557"
    ["__gid"] => string(18) "281011350000100000"
    ["__name"] => string(6) "CANCAN"
    ["__base"] => string(1) "6"
    ["__model"] => string(19) "Oceanis 45 (4 cabs)"
    ["__berths"] => string(1) "8"
    ["__berthsext"] => string(4) "8 +2"
    ["__year"] => string(4) "2018"
    ["__length"] => string(5) "13.85"
    ["__cabins"] => string(1) "4"
    ["__cabinsext"] => string(1) "4"
    ["__heads"] => string(1) "2"
    ["__watercapacity"] => string(8) "530.00 l"
    ["__fuelcapacity"] => string(8) "200.00 l"
    ["__engine"] => string(5) "54 HP"
    ["__deposit"] => string(7) "2000.00"
    ["__depositwithwaiver"] => string(4) "0.00"
    ["__commissionpercentage"] => string(5) "20.00"
    ["__kind"] => string(9) "Sail boat"
    ["__draught"] => string(4) "2.15"
    ["__beam"] => string(4) "4.49"
    ["__lengthatwaterline"] => string(5) "13.50"
    ["__maximumdiscount"] => string(5) "10.00"
    ["__servicetype"] => string(8) "Bareboat"
    ["__discountshavesubtotals"] => string(1) "1"
    ["__defaultcheckintime"] => string(5) "17:00"
    ["__defaultcheckouttime"] => string(5) "09:00"
    ["__calculateagencydiscountwithoutvat"] => string(1) "0"
    ["__taxableamount"] => string(6) "100.00"
    ["__taxrate"] => string(4) "0.00"
    ["__genericresourcetypename"] => string(13) "Oceanis 45[G]"
    ["__defaultcheckinday"] => string(1) "7"
    ["__codeid"] => string(2) "12"
    ["__transitlog"] => string(6) "150.00"
    ["__defaultcleaningcost"] => string(3) ".00"
    ["__shipyardid"] => string(1) "5"
    ["__saleprice"] => string(0) ""
    ["__requiredskipperlicense"] => string(1) "1"
    ["__ownerid"] => string(2) "-1"
    ["__mainsail"] => string(11) "Full batten"
    ["__genoa"] => string(7) "Furling"
    ["__defaultbaseid"] => string(1) "6"
    ["__maxPeopleOnBoard"] => string(2) "-1"
    ["__boatid"] => string(5) "64455"
    ["boatName"] => string(6) "CANCAN"
    ["name"] => string(19) "Oceanis 45 (4 cabs)"
    ["boatKind"] => string(9) "Sail boat"
    ["built"] => string(4) "2018"
    ["berth"] => string(1) "8"
    ["__country"] => string(2) "HR"
    ["___base"] => string(12) "Marina Punat"
    ["location"] => string(44) "Marina Punat - Istria / Kvarner - Chorvatsko"
    ["__bookState"] => NULL
    ["__charterName"] => string(11) "Simple Sail"
    ["__boatUri"] => string(51) "/pronajem-lodi/plachetnice/oceanis-45/64455-cancan/"
    ["priceTotal"] => string(7) "2162.00"
    ["__priceSort"] => string(7) "2162.00"
    ["__priceWithoutDiscount"] => string(4) "4600"
    ["__procenta"] => string(7) "56.0000"
    ["__cena"] => string(4) "4600"
    ["od"] => string(10) "2021-06-26"
    ["__doFW"] => string(10) "2021-07-02"
    ["__type"] => string(4) "last"
  }
  [1] => array(69) {
    ["id"] => string(5) "69388"
    ["__id"] => string(5) "69388"
    ["__companyid"] => string(3) "109"
    ["__cgid"] => string(18) "509322820000100000"
    ["__created"] => string(19) "2020-05-25 11:56:12"
    ["__updated"] => string(19) "2021-06-22 05:32:47"
    ["__resource_id"] => string(17) "74490210374800109"
    ["__gid"] => string(18) "509322820000100000"
    ["__name"] => string(4) "Moon"
    ["__base"] => string(2) "12"
    ["__model"] => string(17) "Bavaria 51 BT '17"
    ["__berths"] => string(2) "12"
    ["__berthsext"] => string(2) "12"
    ["__year"] => string(4) "2017"
    ["__length"] => string(5) "15.59"
    ["__cabins"] => string(1) "5"
    ["__cabinsext"] => string(1) "5"
    ["__heads"] => string(1) "3"
    ["__watercapacity"] => string(8) "560.00 l"
    ["__fuelcapacity"] => string(8) "280.00 l"
    ["__engine"] => string(17) "75 hp Volvo Penta"
    ["__deposit"] => string(7) "2000.00"
    ["__depositwithwaiver"] => string(4) "0.00"
    ["__commissionpercentage"] => string(5) "20.00"
    ["__kind"] => string(9) "Sail boat"
    ["__draught"] => string(4) "2.25"
    ["__beam"] => string(4) "4.67"
    ["__lengthatwaterline"] => string(0) ""
    ["__maximumdiscount"] => string(5) "30.00"
    ["__servicetype"] => string(8) "Bareboat"
    ["__discountshavesubtotals"] => string(1) "0"
    ["__defaultcheckintime"] => string(5) "17:00"
    ["__defaultcheckouttime"] => string(5) "09:00"
    ["__calculateagencydiscountwithoutvat"] => string(1) "1"
    ["__taxableamount"] => string(6) "100.00"
    ["__taxrate"] => string(5) "13.00"
    ["__genericresourcetypename"] => string(21) "Bavaria Cruiser 51[G]"
    ["__defaultcheckinday"] => string(1) "7"
    ["__codeid"] => string(5) "30007"
    ["__transitlog"] => string(1) "0"
    ["__defaultcleaningcost"] => string(3) ".00"
    ["__shipyardid"] => string(1) "1"
    ["__saleprice"] => string(0) ""
    ["__requiredskipperlicense"] => string(1) "1"
    ["__ownerid"] => string(2) "-1"
    ["__mainsail"] => string(7) "Furling"
    ["__genoa"] => string(7) "Furling"
    ["__defaultbaseid"] => string(2) "12"
    ["__maxPeopleOnBoard"] => string(2) "-1"
    ["__boatid"] => string(5) "69388"
    ["boatName"] => string(4) "Moon"
    ["name"] => string(17) "Bavaria 51 BT '17"
    ["boatKind"] => string(9) "Sail boat"
    ["built"] => string(4) "2017"
    ["berth"] => string(2) "12"
    ["__country"] => string(2) "HR"
    ["___base"] => string(24) "Marina D-Marin Dalmacija"
    ["location"] => string(45) "Marina D-Marin Dalmacija - Zadar - Chorvatsko"
    ["__bookState"] => NULL
    ["__charterName"] => string(16) "Adriatic Charter"
    ["__boatUri"] => string(49) "/pronajem-lodi/plachetnice/bavaria-51/69388-moon/"
    ["priceTotal"] => string(7) "2732.58"
    ["__priceSort"] => string(7) "2732.58"
    ["__priceWithoutDiscount"] => string(4) "5100"
    ["__procenta"] => string(7) "49.0000"
    ["__cena"] => string(4) "5100"
    ["od"] => string(10) "2021-06-26"
    ["__doFW"] => string(10) "2021-07-02"
    ["__type"] => string(4) "last"
  }
}
Pronájem lodí dovolená na jachtě - Aquadino.cz

Hledání lodí dle parametru
 
* Povinné pole

Pronájem lodí, plachetnic, jachet a kapitánské zkoušky

Hledáte pronájem jachty? Na našich stránkách naleznete tisíce dostupných jachet k pronájmu! Zajistíme Vám pronájem lodí v Řecku, Chorvatsku, Turecku, Karibiku a v mnoha dalších destinacích.

Pronájem plachetnic, katamaránů a motorových člunů zajišťujeme přes naše partnery jako jsou společnosti Kiriacoulis, Adriatic Charter, Asta Yachting a přes mnoho dalších profesionálů, kteří Vám zajistí pohodovou dovolenou na lodi!

Pokud nevlastníte kapitánský průkaz , Aquadino Vás připraví na kapitánskou zkoušku na jednom ze svých kapitánských kurzů!

Poznávejte krásu z druhé strany pláže, užívejte si svobodu, kterou Vám charter jachty nabízí! Užíjte si dovolenou na jachtě!

  • Oceanis 45 (4 cabs) CANCAN
    Místo: Marina Punat - Istria / Kvarner - Chorvatsko
    Termín od: 26.06.2021 do: 02.07.2021
    Sleva z: 4600€ na 2162€
  • Bavaria 51 BT '17 Moon
    Místo: Marina D-Marin Dalmacija - Zadar - Chorvatsko
    Termín od: 26.06.2021 do: 02.07.2021
    Sleva z: 5100€ na 2733€

Další lodě se slevou

AKTUÁLNĚ 10.7.-11.7.2021 školení na české C V Jablonci nad Nisou
Rezervace na novou sezonu jsou v plném proudu!
Aktuální nabídka kapitánských kurzů na sezonu 2021



Fultextové vyhledávání
* Povinné pole

Při poskytování našich služeb nám pomáhají soubory cookie. Využíváním našich služeb s jejich používáním souhlasíte. Další informace