1 resultaat gevonden
dinsdag 1 april 2025 Tot woensdag 2 april 2025
Aantal personen: 2, Aantal Kamers: 1
Resultaten 1 - 1 van 1
Hotel de Vlijt Coevorden Aanzicht

H Design Hotel Kasteel Coevorden

Coevorden, Drenthe, Nederland

 

  • Karakteristiek hotel gevestigd in 2 panden
  • Historisch kasteel en voormalig Graanpakhuis “De Vlijt”
  • Vestingstad Coevorden
  • Breng een bezoek aan Wildlands Adventure Zoo

 

8,1

Zeer god

80 beoordelingen

2-daags H Design King | Coevorden arrangement

vanaf
€4.999,50
per persoon
  • 1 of meerdere overnachtingen
  • Dagelijks uitgebreid ontbijt
  • Iedere avond een heerlijk 3-gangen diner
  • Gratis koffie- & theefaciliteiten op de kamer
  • Gratis wandel- & fietsroutes
  • Gratis WiFi & parkeren
excl. verblijfsbelasting à € 3,00 p.p.p.n. & reserveringskosten € 9,50 per boeking
Bekijk

Logies & ontbijt

vanaf
€4.999,50
per persoon
  • 1 of meerdere overnachtingen
  • Dagelijks uitgebreid ontbijt
  • Gratis koffie- & theefaciliteiten op de kamer
  • Gratis wandel- & fietsroutes
  • Gratis WiFi & parkeren
  • Gratis wandel- & fietsapp
excl. verblijfsbelasting à € 3,00 p.p.p.n. & reserveringskosten € 9,50 per boeking
Bekijk
Toon alle
J! InfoRequestSessionProfileQueries79Log
33.76MBMemory Usage3.48sRequest Duration
Joomla! Version4.4.4
PHP Version8.1.31
Identityguest
Response200
Templatej-travel
Database
Server
mysql
Version
10.6.19-MariaDB-log
Collation
utf8mb3_general_ci
Conn Collation
utf8mb4_general_ci
$_GET
[]
$_POST
[]
$_SESSION
array:2 [ "userData" => {#1011 +"searchType": "" +"keyword": "" +"start_date": "2025-0...
$_COOKIE
[]
$_SERVER
array:109 [ "USER" => "goedve01" "HOME" => "/var/www/vhosts/goedverblijf.nl" "SCRIPT_NAME" => ...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1743550695 "last" => 1743550695...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
plg_system_languagefilter
array:1 [ "language" => "nl-NL" ]
  • afterLoad (4.2MB) (36.72ms)
  • afterInitialise (13.86MB) (140ms)
  • afterRoute (1.99MB) (51.71ms)
  • beforeRenderComponent com_jhotelreservation (508.19KB) (7.18ms)
  • Before Access::preloadComponents (all components) (3.5MB) (1.61s)
  • After Access::preloadComponents (all components) (112.55KB) (751μs)
  • Before Access::getAssetRules (id:1 name:root.1) (3.73KB) (25μs)
  • After Access::getAssetRules (id:1 name:root.1) (29.45KB) (521μs)
  • beforeRenderRawModule mod_jhotelreservation (JHotelReservation) (688.53KB) (1.52s)
  • afterRenderRawModule mod_jhotelreservation (JHotelReservation) (520.36KB) (19.76ms)
  • beforeRenderModule mod_jhotelreservation (JHotelReservation) (736B) (13μs)
  • afterRenderModule mod_jhotelreservation (JHotelReservation) (397.3KB) (1.56ms)
  • afterRenderComponent com_jhotelreservation (454.44KB) (6.47ms)
  • afterDispatch (115.63KB) (1.86ms)
  • beforeRenderRawModule mod_jhotelreservation (Hotel top search) (3.09MB) (39.92ms)
  • afterRenderRawModule mod_jhotelreservation (Hotel top search) (303.86KB) (14.07ms)
  • beforeRenderModule mod_jhotelreservation (Hotel top search) (736B) (14μs)
  • afterRenderModule mod_jhotelreservation (Hotel top search) (374.64KB) (3.66ms)
  • afterRender (1.48MB) (22.43ms)
  • 1 x Before Access::preloadComponents (all components) (3.5MB) (46.32%)
    1.61s
    1 x beforeRenderRawModule mod_jhotelreservation (JHotelReservation) (688.53KB) (43.66%)
    1.52s
    1 x afterInitialise (13.86MB) (4.01%)
    139.58ms
    1 x afterRoute (1.99MB) (1.49%)
    51.71ms
    1 x beforeRenderRawModule mod_jhotelreservation (Hotel top search) (3.09MB) (1.15%)
    39.92ms
    1 x afterLoad (4.2MB) (1.06%)
    36.72ms
    1 x afterRender (1.48MB) (0.64%)
    22.43ms
    1 x afterRenderRawModule mod_jhotelreservation (JHotelReservation) (520.36KB) (0.57%)
    19.76ms
    1 x afterRenderRawModule mod_jhotelreservation (Hotel top search) (303.86KB) (0.4%)
    14.07ms
    1 x beforeRenderComponent com_jhotelreservation (508.19KB) (0.21%)
    7.18ms
    1 x afterRenderComponent com_jhotelreservation (454.44KB) (0.19%)
    6.47ms
    1 x afterRenderModule mod_jhotelreservation (Hotel top search) (374.64KB) (0.11%)
    3.66ms
    1 x afterDispatch (115.63KB) (0.05%)
    1.86ms
    1 x afterRenderModule mod_jhotelreservation (JHotelReservation) (397.3KB) (0.04%)
    1.56ms
    1 x After Access::preloadComponents (all components) (112.55KB) (0.02%)
    751μs
    1 x After Access::getAssetRules (id:1 name:root.1) (29.45KB) (0.01%)
    521μs
    1 x Before Access::getAssetRules (id:1 name:root.1) (3.73KB) (0%)
    25μs
    1 x beforeRenderModule mod_jhotelreservation (Hotel top search) (736B) (0%)
    14μs
    1 x beforeRenderModule mod_jhotelreservation (JHotelReservation) (736B) (0%)
    13μs
79 statements were executed, 36 of which were duplicates, 43 unique3.09s4.21MB
UniquesDuplicates 1Duplicates 2Duplicates 3Duplicates 4Duplicates 5
  • SELECT @@SESSION.sql_mode;129μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `jos_session` WHERE `session_id` = ?1.01ms1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `jos_session` WHERE `session_id` = :session_id LIMIT 1159μs1.61KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `jos_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)1.43ms944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `jos_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 188μs2.36KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `jos_viewlevels`76μs944B/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `jos_usergroups` AS `a` LEFT JOIN `jos_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest70μs1.63KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM `jos_extensions` WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1) ORDER BY `ordering`85μs3.02KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT `template` FROM `jos_template_styles` WHERE `client_id` = 0 AND `home` = 1269μs2.09KB/components/com_sppagebuilder/parser/addon-parser.php:1320Copy
  • SELECT * FROM `jos_languages` WHERE `published` = 1 ORDER BY `ordering` ASC111μs2.25KB/libraries/src/Language/LanguageHelper.php:142Copy
  • SELECT `element`,`name`,`client_id`,`extension_id` FROM `jos_extensions` WHERE `type` = 'language' AND `state` = 0 AND `enabled` = 164μs1.11KB/libraries/src/Language/LanguageHelper.php:213Copy
  • SELECT `m`.`id`,`m`.`menutype`,`m`.`title`,`m`.`alias`,`m`.`note`,`m`.`link`,`m`.`type`,`m`.`level`,`m`.`language`,`m`.`browserNav`,`m`.`access`,`m`.`params`,`m`.`home`,`m`.`img`,`m`.`template_style_id`,`m`.`component_id`,`m`.`parent_id`,`m`.`path` AS `route`,`e`.`element` AS `component` FROM `jos_menu` AS `m` LEFT JOIN `jos_extensions` AS `e` ON `m`.`component_id` = `e`.`extension_id` WHERE ( (`m`.`published` = 1 AND `m`.`parent_id` > 0 AND `m`.`client_id` = 0) AND (`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :currentDate1)) AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :currentDate2) ORDER BY `m`.`lft`2.56ms184.55KBParams/libraries/src/Menu/SiteMenu.php:166Copy
  • SELECT fas.* FROM jos_hotelreservation_application_settings fas107μs2.8KB/components/com_jhotelreservation/helpers/utils.php:81Copy
  • SELECT fas.* FROM jos_hotelreservation_date_formats fas WHERE fas.id ='3'72μs1.06KB/components/com_jhotelreservation/helpers/utils.php:92Copy
  • select * from jos_hotelreservation_offers off inner join jos_hotelreservation_offers_vouchers hov on off.offer_id = hov.offerId where REPLACE(hov.voucher,'-',' ') = 'Coevorden' group by off.offer_id LIMIT 117.42ms7.73KB/plugins/system/hotelurltranslator/jhprouter.php:264Copy
  • SELECT * FROM `jos_hotelreservation_hotels` WHERE REPLACE(hotel_city,'-',' ') = 'Coevorden'1.35ms7.34KB/plugins/system/hotelurltranslator/jhprouter.php:168Copy
  • select * from jos_hotelreservation_offers off inner join jos_hotelreservation_offers_vouchers hov on off.offer_id = hov.offerId where REPLACE(hov.voucher,'-',' ') = 'Coevorden' group by off.offer_id LIMIT 1181μs10.23KB/plugins/system/hotelurltranslator/jhprouter.php:264Copy
  • SELECT * FROM `jos_hotelreservation_hotels` WHERE REPLACE(hotel_city,'-',' ') = 'Coevorden'153μs7.34KB/plugins/system/hotelurltranslator/jhprouter.php:168Copy
  • SELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent` FROM `jos_template_styles` AS `s` LEFT JOIN `jos_extensions` AS `e` ON `e`.`element` = `s`.`template` AND `e`.`type` = 'template' AND `e`.`client_id` = `s`.`client_id` WHERE `s`.`client_id` = 0 AND `e`.`enabled` = 1291μs129.42KB/administrator/components/com_templates/src/Model/StyleModel.php:773Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'131μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT `c2`.`language`,`c2`.`id` FROM `jos_menu` AS `c` INNER JOIN `jos_associations` AS `a` ON `a`.`id` = `c`.`id` AND `a`.`context` = :context INNER JOIN `jos_associations` AS `a2` ON `a`.`key` = `a2`.`key` INNER JOIN `jos_menu` AS `c2` ON `a2`.`id` = `c2`.`id` WHERE `c`.`id` = :id124μs1.73KBParams/libraries/src/Language/Associations.php:145Copy
  • SELECT * FROM jos_hotelreservation_hotel_facilities ORDER BY name89μs2.19KB/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT * FROM jos_hotelreservation_hotel_types ORDER BY name53μs1.06KB/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT * FROM jos_hotelreservation_hotel_accommodation_types ORDER BY name55μs1.38KB/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT * FROM jos_hotelreservation_hotel_environments ORDER BY name51μs1KB/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT * FROM jos_hotelreservation_hotel_regions ORDER BY name68μs2.38KB/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT * FROM jos_hotelreservation_offers_themes ORDER BY name61μs1.5KB/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SHOW FULL COLUMNS FROM `jos_hotelreservation_hotels`613μs2.52KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SET SESSION group_concat_max_len = 100000047μs0B/administrator/components/com_jhotelreservation/tables/hotels.php:477Copy
  • select h.hotel_id, h.hotel_name,h.hotel_alias,h.hotel_short_description as hotel_short_description, h.hotel_county, h.hotel_city, h.hotel_address, h.hotel_zipcode, h.hotel_website, h.hotel_stars, h.hotel_rating_score, h.featured, h.hotel_selling_points, h.recommended, h.hotel_phone, h.hotel_number,h.hotel_latitude,h.hotel_longitude, h.hotel_stars as hstars,hinf.city_tax,hinf.city_tax_percent,hh10.room_min_rate lowest_hotel_price ,hh10.totalRoomsAvailable,hh10.searchRoomIds,hc.totalReserved, (hh10.totalRoomsAvailable-IFNULL(hc.totalReserved,0)) as roomsLeft, currency_symbol, hc.noBookings, noReviews, c1.country_name, c2.description AS hotel_currency, hotel_picture_path,hotel_picture_info,hotel_pictures_count, hlt.content as hotel_description, accommodationTypes, regions,themes,noReviews,facilities,types from jos_hotelreservation_hotels as h left join jos_hotelreservation_hotel_informations hinf on h.hotel_id = hinf.hotel_id left join (select hotelId, GROUP_CONCAT(facilityId) as facilities from jos_hotelreservation_hotel_facility_relation where 1 group by hotelId ) as fr on h.hotel_id = fr.hotelId left join (select atr.hotelId, GROUP_CONCAT(atr.accommodationTypeId) as accommodationTypes from jos_hotelreservation_hotel_accommodation_type_relation atr left join jos_hotelreservation_hotel_accommodation_types as hat on hat.id = atr.accommodationtypeId where 1 group by atr.hotelId ) as atr on h.hotel_id = atr.hotelId left join ( select rl.hotelId, GROUP_CONCAT(rl.regionId) as regions from jos_hotelreservation_hotel_region_relation as rl left join jos_hotelreservation_hotel_regions as hr on hr.id = rl.regionId where 1 group by hotelId ) as rl on h.hotel_id=rl.hotelId left join (select hotelId, GROUP_CONCAT(tr.typeId) as types from jos_hotelreservation_hotel_type_relation as tr left join jos_hotelreservation_hotel_types ht on ht.id=tr.typeId where 1 group by hotelId ) tr on h.hotel_id = tr.hotelId left join ( select hotel_id, GROUP_CONCAT(hotr.themeId) as themes from jos_hotelreservation_offers hof left join jos_hotelreservation_offers_themes_relation hotr on hotr.offerId=hof.offer_id left join jos_hotelreservation_offers_themes hot on hot.id = hotr.themeId where 1 group by hotel_id ) hof on h.hotel_id = hof.hotel_id left join (select hotel_id, count(hrt.review_id) as noReviews from jos_hotelreservation_review_customers hrt where hrt.published = 1 group by hotel_id ) as hrc on h.hotel_id = hrc.hotel_id left join jos_hotelreservation_countries c1 USING (country_id) left join jos_hotelreservation_currencies c2 USING (currency_id) left join ( select hc.hotel_id,count(hcr.confirmation_room_id) as totalReserved,count(distinct hc.confirmation_id) as noBookings from jos_hotelreservation_confirmations hc inner join jos_hotelreservation_confirmations_rooms hcr on hc.confirmation_id = hcr.confirmation_id where ((hc.start_date <'2025-04-02' and '2025-04-02' <= hc.end_date) or (hc.start_date <='2025-04-01' and '2025-04-01' < hc.end_date)) and hc.reservation_status NOT IN (2) group by hc.hotel_id )as hc on h.hotel_id=hc.hotel_id left join ( select a.hotel_id,a.hotel_picture_path, a.hotel_picture_info,b.hotel_pictures_count from jos_hotelreservation_hotel_pictures a inner join (SELECT hp.hotel_id, min(hp.hotel_picture_id) as hotel_main_picture_id, count(hp.hotel_picture_id) as hotel_pictures_count FROM jos_hotelreservation_hotel_pictures AS hp group by hotel_id ) b on a.hotel_picture_id = b.hotel_main_picture_id )as hh12 on hh12.hotel_id = h.hotel_id left join ( select * from jos_hotelreservation_language_translations where type = 1 and language_tag = 'nl-NL' )as hlt on hlt.object_id = h.hotel_id left join ( select hotel_id, 1 as room_available, min(room_rate) as room_min_rate, GROUP_CONCAT(hh110.room_id) as searchRoomIds, sum(hh110.availability) as totalRoomsAvailable, GROUP_CONCAT(room_name,'|',room_id,'|',room_rate) as room_details from ( select hr.room_name, hr.room_id, hr.hotel_id, max(IFNULL(hrrp.rate_closed,0)) rate_closed, sum(IFNULL(hra.availability,hr.availability*1)) availability, if(min(hrrp.price), min(hrrp.price), min(least(hrr.price_1, hrr.price_2, hrr.price_3, hrr.price_4, hrr.price_5, hrr.price_6, hrr.price_7))) as room_rate from jos_hotelreservation_rooms as hr left join jos_hotelreservation_rooms_rates as hrr on hr.room_id=hrr.room_id left join (select room_id,availability from jos_hotelreservation_room_availability where date between '2025-04-01' and '2025-04-01') hra on hr.room_id = hra.room_id left join (select rate_id,rate_closed,price from jos_hotelreservation_rooms_rate_prices where date between '2025-04-01' and '2025-04-01') as hrrp on hrr.id=hrrp.rate_id where hr.is_available=1 group by hr.room_id having rate_closed<>1 ) hh110 group by hotel_id ) as hh10 on h.hotel_id=hh10.hotel_id WHERE 1 and h.is_available = 1 and h.hotel_city = 'Coevorden' order by noBookings desc LIMIT 1001.56s7.44KB/administrator/components/com_jhotelreservation/tables/hotels.php:485Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `jos_assets` WHERE `name` IN (:preparedArray1,:preparedArray2,:preparedArray3,:preparedArray4,:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10,:preparedArray11,:preparedArray12,:preparedArray13,:preparedArray14,:preparedArray15,:preparedArray16,:preparedArray17,:preparedArray18,:preparedArray19,:preparedArray20,:preparedArray21,:preparedArray22,:preparedArray23,:preparedArray24,:preparedArray25,:preparedArray26,:preparedArray27,:preparedArray28,:preparedArray29,:preparedArray30,:preparedArray31,:preparedArray32,:preparedArray33,:preparedArray34,:preparedArray35,:preparedArray36,:preparedArray37,:preparedArray38,:preparedArray39,:preparedArray40,:preparedArray41,:preparedArray42,:preparedArray43,:preparedArray44,:preparedArray45)228μs8.12KBParams/libraries/src/Access/Access.php:357Copy
  • SHOW FULL COLUMNS FROM `jos_hotelreservation_language_translations`504μs1.97KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SHOW FULL COLUMNS FROM `jos_hotelreservation_offers`640μs13.52KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • select * from jos_hotelreservation_language_translations where type=6 and language_tag = 'nl-NL'2.1ms1.25MB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:66Copy
  • select * from jos_hotelreservation_language_translations where type=17 and language_tag = 'nl-NL'693μs249.05KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:66Copy
  • select * from jos_hotelreservation_language_translations where type=23 and language_tag = 'nl-NL'80μs1.05KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:66Copy
  • select hof.offer_name,offerTags, hof.offer_content, hof.offer_id, hof.hotel_id as hotel_id,offer_reservation_cost_val, GREATEST(IFNULL(max(orp.min_days),hof.offer_min_nights),hof.offer_min_nights) as offer_min_nights, IFNULL(min(if(orp.max_days=0,999,orp.max_days)),hof.offer_max_nights) as offer_max_nights, hof.last_minute as last_minute, hof.featured as featured, hof.offer_initial_price as offer_initial_price, ofr.base_adults, ofr.price_type, ofr.price_type_day, ofrr.room_id as offer_room_id, min(IFNULL(orp.rate_closed,0)) rate_closed, if(ofr.price_type_day=1 , if ( min(orp.price), min(orp.price), min(least(ofr.price_1, ofr.price_2, ofr.price_3, ofr.price_4, ofr.price_5, ofr.price_6, ofr.price_7))) , if ( min(orp.price), min(orp.price), min(least(ofr.price_1, ofr.price_2, ofr.price_3, ofr.price_4, ofr.price_5, ofr.price_6, ofr.price_7))) * hof.offer_min_nights ) as offer_rate from jos_hotelreservation_offers hof inner join jos_hotelreservation_offers_rooms ofrr on ofrr.offer_id = hof.offer_id inner join jos_hotelreservation_offers_rates ofr on ofr.offer_id = hof.offer_id and ofr.room_id = ofrr.room_id left join jos_hotelreservation_offers_rate_prices orp on orp.rate_id = ofr.id and orp.date>='2025-04-01' and orp.date<='2025-04-02' left join jos_hotelreservation_offers_vouchers hov on hof.offer_id = hov.offerId left join (select oftr.offerId, GROUP_CONCAT(DISTINCT oft.name order by oftr.ordering asc SEPARATOR '|') as offerTags from jos_hotelreservation_offers_tags_relation oftr left join jos_hotelreservation_offers_tags oft ON oft.id = oftr.tagId group by oftr.offerId ) oftr ON oftr.offerId = hof.offer_id where hof.is_available = 1 and ('2025-04-01' between hof.offer_datas and hof.offer_datae) and IF(hof.offer_dataef <> '0000-00-00',CURDATE() BETWEEN hof.offer_datasf AND hof.offer_dataef, CURDATE() >= hof.offer_datasf) and (hof.public=1) and hotel_id = 91 group by hof.offer_id order by hotel_id,offer_rate asc79.26ms3.67KB/administrator/components/com_jhotelreservation/tables/offers.php:436Copy
  • select hcr.room_id, c.start_date, c.end_date from jos_hotelreservation_confirmations_rooms hcr inner join jos_hotelreservation_confirmations c on c.confirmation_id= hcr.confirmation_id where (c.start_date <'2025-04-02' and c.end_date >='2025-04-01') and c.reservation_status <> 2 and c.hotel_id = 911.6ms960B/components/com_jhotelreservation/classes/services/BookingService.php:149Copy
  • select distinct hr.room_id, hr.hotel_id, hr.availability, ra.availability as day_availability, ra.date as availability_date from jos_hotelreservation_offers_rooms ofrr inner join jos_hotelreservation_rooms as hr on hr.room_id = ofrr.room_id left join (select * from jos_hotelreservation_room_availability where date<'2025-04-02' and date >='2025-04-01') as ra on ra.room_id = hr.room_id inner join jos_hotelreservation_offers hof on ofrr.offer_id = hof.offer_id where hr.is_available=1 and hof.is_available=1 and hof.offer_id in (4910,6823,6833,8253) and hof.hotel_id = 91 union select distinct hr.room_id, hr.hotel_id, hr.availability, ra.availability as day_availability, ra.date as availability_date from jos_hotelreservation_rooms as hr left join (select * from jos_hotelreservation_room_availability where date<'2025-04-02' and date >='2025-04-01') as ra on ra.room_id = hr.room_id where hr.is_available=1 and hr.front_display=1 and hr.room_id in (962,145,969) and hr.hotel_id = 9122.94ms1.09KB/components/com_jhotelreservation/classes/services/BookingService.php:179Copy
  • SHOW FULL COLUMNS FROM `jos_hotelreservation_rating_classification`568μs1.98KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT id,name FROM `jos_hotelreservation_rating_classification` WHERE min_rate<=8.07 and max_rate>=8.07143μs912B/administrator/components/com_jhotelreservation/tables/ratingclassifications.php:49Copy
  • select * from jos_hotelreservation_language_translations where type=21 and object_id=2 and language_tag='nl-NL'62μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • select h.hotel_id, h.hotel_name,h.hotel_alias,h.hotel_short_description as hotel_short_description, h.hotel_county, h.hotel_city, h.hotel_address, h.hotel_zipcode, h.hotel_website, h.hotel_stars, h.hotel_rating_score, h.featured, h.hotel_selling_points, h.recommended, h.hotel_phone, h.hotel_number,h.hotel_latitude,h.hotel_longitude, h.hotel_stars as hstars,hinf.city_tax,hinf.city_tax_percent,hh10.room_min_rate lowest_hotel_price ,hh10.totalRoomsAvailable,hh10.searchRoomIds,hc.totalReserved, (hh10.totalRoomsAvailable-IFNULL(hc.totalReserved,0)) as roomsLeft, currency_symbol, hc.noBookings, noReviews, c1.country_name, c2.description AS hotel_currency, hotel_picture_path,hotel_picture_info,hotel_pictures_count, hlt.content as hotel_description, accommodationTypes, regions,themes,noReviews,facilities,types from jos_hotelreservation_hotels as h left join jos_hotelreservation_hotel_informations hinf on h.hotel_id = hinf.hotel_id left join (select hotelId, GROUP_CONCAT(facilityId) as facilities from jos_hotelreservation_hotel_facility_relation where 1 group by hotelId ) as fr on h.hotel_id = fr.hotelId left join (select atr.hotelId, GROUP_CONCAT(atr.accommodationTypeId) as accommodationTypes from jos_hotelreservation_hotel_accommodation_type_relation atr left join jos_hotelreservation_hotel_accommodation_types as hat on hat.id = atr.accommodationtypeId where 1 group by atr.hotelId ) as atr on h.hotel_id = atr.hotelId left join ( select rl.hotelId, GROUP_CONCAT(rl.regionId) as regions from jos_hotelreservation_hotel_region_relation as rl left join jos_hotelreservation_hotel_regions as hr on hr.id = rl.regionId where 1 group by hotelId ) as rl on h.hotel_id=rl.hotelId left join (select hotelId, GROUP_CONCAT(tr.typeId) as types from jos_hotelreservation_hotel_type_relation as tr left join jos_hotelreservation_hotel_types ht on ht.id=tr.typeId where 1 group by hotelId ) tr on h.hotel_id = tr.hotelId left join ( select hotel_id, GROUP_CONCAT(hotr.themeId) as themes from jos_hotelreservation_offers hof left join jos_hotelreservation_offers_themes_relation hotr on hotr.offerId=hof.offer_id left join jos_hotelreservation_offers_themes hot on hot.id = hotr.themeId where 1 group by hotel_id ) hof on h.hotel_id = hof.hotel_id left join (select hotel_id, count(hrt.review_id) as noReviews from jos_hotelreservation_review_customers hrt where hrt.published = 1 group by hotel_id ) as hrc on h.hotel_id = hrc.hotel_id left join jos_hotelreservation_countries c1 USING (country_id) left join jos_hotelreservation_currencies c2 USING (currency_id) left join ( select hc.hotel_id,count(hcr.confirmation_room_id) as totalReserved,count(distinct hc.confirmation_id) as noBookings from jos_hotelreservation_confirmations hc inner join jos_hotelreservation_confirmations_rooms hcr on hc.confirmation_id = hcr.confirmation_id where ((hc.start_date <'2025-04-02' and '2025-04-02' <= hc.end_date) or (hc.start_date <='2025-04-01' and '2025-04-01' < hc.end_date)) and hc.reservation_status NOT IN (2) group by hc.hotel_id )as hc on h.hotel_id=hc.hotel_id left join ( select a.hotel_id,a.hotel_picture_path, a.hotel_picture_info,b.hotel_pictures_count from jos_hotelreservation_hotel_pictures a inner join (SELECT hp.hotel_id, min(hp.hotel_picture_id) as hotel_main_picture_id, count(hp.hotel_picture_id) as hotel_pictures_count FROM jos_hotelreservation_hotel_pictures AS hp group by hotel_id ) b on a.hotel_picture_id = b.hotel_main_picture_id )as hh12 on hh12.hotel_id = h.hotel_id left join ( select * from jos_hotelreservation_language_translations where type = 1 and language_tag = 'nl-NL' )as hlt on hlt.object_id = h.hotel_id left join ( select hotel_id, 1 as room_available, min(room_rate) as room_min_rate, GROUP_CONCAT(hh110.room_id) as searchRoomIds, sum(hh110.availability) as totalRoomsAvailable, GROUP_CONCAT(room_name,'|',room_id,'|',room_rate) as room_details from ( select hr.room_name, hr.room_id, hr.hotel_id, max(IFNULL(hrrp.rate_closed,0)) rate_closed, sum(IFNULL(hra.availability,hr.availability*1)) availability, if(min(hrrp.price), min(hrrp.price), min(least(hrr.price_1, hrr.price_2, hrr.price_3, hrr.price_4, hrr.price_5, hrr.price_6, hrr.price_7))) as room_rate from jos_hotelreservation_rooms as hr left join jos_hotelreservation_rooms_rates as hrr on hr.room_id=hrr.room_id left join (select room_id,availability from jos_hotelreservation_room_availability where date between '2025-04-01' and '2025-04-01') hra on hr.room_id = hra.room_id left join (select rate_id,rate_closed,price from jos_hotelreservation_rooms_rate_prices where date between '2025-04-01' and '2025-04-01') as hrrp on hrr.id=hrrp.rate_id where hr.is_available=1 group by hr.room_id having rate_closed<>1 ) hh110 group by hotel_id ) as hh10 on h.hotel_id=hh10.hotel_id WHERE 1 and h.is_available = 1 and h.hotel_city = 'Coevorden' order by noBookings desc1.39s7.44KB/administrator/components/com_jhotelreservation/tables/hotels.php:497Copy
  • SELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid` FROM `jos_modules` AS `m` LEFT JOIN `jos_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id` LEFT JOIN `jos_extensions` AS `e` ON `e`.`element` = `m`.`module` AND `e`.`client_id` = `m`.`client_id` WHERE ( ( (`m`.`published` = 1 AND `e`.`enabled` = 1 AND `m`.`client_id` = :clientId AND `m`.`access` IN (:preparedArray1)) AND (`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :publishUp)) AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :publishDown)) AND (`mm`.`menuid` = :itemId OR `mm`.`menuid` <= 0) AND `m`.`language` IN (:preparedArray2,:preparedArray3) ORDER BY `m`.`position`,`m`.`ordering`941μs2.2KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT h.*, min(hp.hotel_picture_id), hotel_picture_path FROM jos_hotelreservation_hotels h left join jos_hotelreservation_hotel_pictures hp on h.hotel_id=hp.hotel_id WHERE h.is_available=1 and LENGTH(h.hotel_latitude) > 3 group by h.hotel_id496μs271.39KB/modules/mod_jhotelreservation/helper.php:41Copy
  • select * from jos_hotelreservation_language_translations where type=1 and language_tag = 'nl-NL'755μs425.05KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:66Copy
  • select distinct c.country_name,hotel_county,hr.name as region_name from jos_hotelreservation_hotels h inner join jos_hotelreservation_countries c on h.country_id=c.country_id inner join jos_hotelreservation_hotel_region_relation hrr on h.hotel_id = hrr.hotelId inner join jos_hotelreservation_hotel_regions hr on hr.id = hrr.regionId order by c.country_name,h.hotel_county,hr.name92μs2.94KB/administrator/components/com_jhotelreservation/tables/hotels.php:100Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'106μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'78μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'74μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'73μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT `language`,`id` FROM `jos_menu` WHERE `home` = '1' AND `published` = 1 AND `client_id` = 065μs960B/libraries/src/Language/Multilanguage.php:123Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'116μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'78μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'76μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'72μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'95μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'104μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'99μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'114μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'93μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT h.*, min(hp.hotel_picture_id), hotel_picture_path FROM jos_hotelreservation_hotels h left join jos_hotelreservation_hotel_pictures hp on h.hotel_id=hp.hotel_id WHERE h.is_available=1 and LENGTH(h.hotel_latitude) > 3 group by h.hotel_id508μs271.39KB/modules/mod_jhotelreservation/helper.php:41Copy
  • select * from jos_hotelreservation_language_translations where type=1 and language_tag = 'nl-NL'577μs425.05KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:66Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'101μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'119μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'73μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'73μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'78μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'78μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'71μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'72μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'103μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'75μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'81μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'72μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'84μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'108μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT `session_id` FROM `jos_session` WHERE `session_id` = ?304μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `jos_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?3.22ms912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy