Midweek breaks
Check Availability
If you’re not quite sure of your plans, chose this rate and you can cancel up to 4pm on the day of arrival free of charge. Room only rate, unless you, wish to enhance your stay? This is a Fully Flexible rate plan and full details applied as per terms and conditionsssss.
dsfsdsdfsddfd
This is the other side of the form.
If you’re not quite sure of your plans, chose this rate and you can cancel up to 4pm on the day of arrival free of charge. Room only rate, unless you, wish to enhance your stay? This is a Fully Flexible rate plan and full details applied as per terms and conditionsssss.
dsfsdsdfsddfd
This is the other side of the form.
| April 2026 | ||||||
| Mo | Tu | We | Th | Fr | Sa | Su |
|---|---|---|---|---|---|---|
| 01 | 02 | 03 | 04 | 05 | ||
| 06 | 07 | 08 | 09 | 10 | 11 | 12 |
| 13 | 14 | 15 | 16 | 17 | 18 | 19 |
| 20 | 21 | 22 | 23 | 24 | 25 | 26 |
| 27 | 28 | 29 | 30 | |||
| May 2026 | ||||||
| Mo | Tu | We | Th | Fr | Sa | Su |
|---|---|---|---|---|---|---|
| 01 | 02 | 03 | ||||
| 04 | 05 | 06 | 07 | 08 | 09 | 10 |
| 11 | 12 | 13 | 14 | 15 | 16 | 17 |
| 18 | 19 | 20 | 21 | 22 | 23 | 24 |
| 25 | 26 | 27 | 28 | 29 | 30 | 31 |
Promo Code: DIRECT
Use Promo Code DIRECT & save 10%
Best Rate Guarantee
Book on our website and get the best rate
Free Parking
Parking is free when booking online
Drink on Arrival
Receive a drink on us on your arrival
$VAR1 = {};
%Params = (
'realex_dcc_v' => 0,
'ajax_autobooking' => 1,
'fb_vouchers_tab' => 0,
'cubilis_ips' => '217.21.187.196|46.7.75.205',
'cross_packages6' => 0,
'flag_comm_addition' => 0,
'flag_pciproxy' => 1,
'app_icon' => undef,
'sbox_mshort' => 1,
'ingenico_api_password' => undef,
'sagepay_vendorname_v' => undef,
'chav_grid_days' => 7,
'flag_ratecode_alert' => 1,
'logo_width' => 300,
'omit_review' => undef,
'text_specials_title' => 'Specials',
'chav_enhancement_max' => 5,
'enh_sel_type' => 0,
'flag_price_breakdown' => 0,
'chav_gridview_showlonger' => 0,
'flag_emailfromus' => 0,
'flag_cash_payment' => 0,
'facebook_num_comments' => 8,
'css' => '',
'eec' => 1,
'flag_diffcom_banquet' => 0,
'google_tag_manager' => '',
'id' => 1444,
'flag_form_tokens' => 0,
'hotel_idcountry' => 1,
'cross_packages5' => 1,
'text_crosssell_meta_descr' => undef,
'vouchers_realexpayments' => 0,
'chav_event_max' => 8,
'flag_weddings_content' => 1,
'testing' => 0,
'chav_limit_gridresults' => 99,
'specials_cal_open' => 1,
'flag_vouchers_add_addition' => 0,
'recaptcha_private' => '6LdrowwdAAAAAP0XS_DwR3BcgACVPKTMqWmkxLzq"',
'text_packages2_title' => 'Midweek breaks',
'show_fullsite_link' => 0,
'chav_showspecials' => 0,
'special_requirements' => undef,
'picture_mobile' => undef,
'signup1_title' => '',
'action_bar_text' => undef,
'trinity' => 1,
'chav_noavlookahead' => 7,
'check_in' => '12:00 hjlkj',
'chav_maxrooms' => 5,
'hotelcontacturl' => 'https://david.bketest.office.netaffinity.net/bookings/checkavailability',
'idcountry' => 1,
'spec_rss' => 20,
'parityrate_username' => 'rtwtetwtrw',
'text_packages6_title' => 'Summer Getaways',
'voucher_click_collect_days' => '1',
'facebook_page_url' => '',
'google_analytics_showdomain' => 1,
'flag_cancelbooking' => 1,
'how_found' => 0,
'url_ip' => undef,
'flag_specials_calendar' => 1,
'contactemail' => 'david.e@netaffinity.com',
'mobile_facebook_tab' => 1,
'reviews_long_perpage' => 5,
'action_bar_button_link' => undef,
'chav_noavlookback' => 3,
'flag_dev_repo' => 0,
'booking_abandonment_leave_trigger' => 1,
'vouchers_mail_costregistered' => '0',
'text_packages2_meta_keywords' => '',
'google_api' => 1,
'text_specials_meta_keywords' => 'test keywords',
'flag_vouchers_click_collect' => '0',
'ajax_autovoucherorder' => 1,
'ingenico_passphrase_out' => undef,
'ingenico_api_user' => undef,
'mobile_vouchers_tab' => 1,
'flag_wedding_content' => 1,
'events_short' => 3,
'stripe_public_key' => 'pk_test_DW4hFObRlb3YUWjIsiptHK1z',
'fb_specials_tab' => 0,
'flag_cubilis' => 0,
'pagetitle' => 'Midweek breaks',
'flag_https' => 0,
'cookies_policy' => "COOKIE POLICY
Latest Version: 25th of April 2018
Dublin Skylon Hotel
The Dublin Skylon Hotel is committed to protecting and respecting your data. The Dublin Skylon Hotel website users cookies in order to make our website function properly and by continuing to access our website, you agree that we can place the cookies described below on your device.
What is a cookie?
You can find more information about cookies at www.allaboutcookies.org and www.youronlinechoices.eu.
What are the regulations?
Recital 30 of the EU General Data Protection Regulation 2016 (GDPR) states: “Natural persons may be associated with online identifiers […] such as internet protocol addresses, cookie identifiers or other identifiers […]. This may leave traces which, in particular when combined with unique identifiers and other information received by the servers, may be used to create profiles of the natural persons and identify them.” In order to meet the legal requirements of EU Law, the minimum requirement is that clear communication is provided to the user as to what he/she is being asked to consent to in terms of cookies usage and a means of giving or refusing consent is required. âÂÂÂÂÂ\x{c2}\x{96}ª Communications) Regulations 2011 (\"SI 336/2011\") âÂÂÂÂÂ\x{c2}\x{96}ª EU General Data Protection Regulation 2016 (“GDPR”) We reserve the right to amend this Privacy Statement at any time and from time to time without notice by publishing a new version on our website. Please refer to the top of this document to see date of the latest version in force.
Cookies used on this Website
A list of all the cookies used on the Website by category is set out below.
Technical details on our cookies:
| Name | Purpose | Type | LifecycJe |
| Google Analytics | |||
| _utma | for google analytics tracking | third party | 2 years |
| _utmb | for google analytics tracking | third party | 30 minutes |
| _utmc | for google analytics tracking | third party | expires at the end of the session |
| _utmz | for googJe analytics rracking | third party | 6 months |
| Other Performance cookies | |||
| crm | to provide counts of new and repeat visits | first party | expires in two weeks |
| _qsst | For Qubit analytics tracking | third party | expires at the end of the session |
| _qst | For Qubit analytics tracking | third party | 1 year |
| _qubitTracker | For Qubit analytics tracking | third party | 1 year |
| For Qubit analytics tracking | third party | expires at the end of the session | |
| _qubitTracker_s | |||
| Strictly Necessary | |||
| CSSID | to hold the session_id for this transaction | first party | expires at the end of the session |
How to Disable our Cookies:
Our website is designed to function optimally with cookies – as detailed above – enabled to provide a seamless, enhanced and more personal experience. However, should you wish to disable cookies on our website whilst browsing, this can be controlled through your browser settings and it is possible to stop your browser accepting cookies.
Important Note: If you do deactivate cookies on our website, it may result in some of the website features become disabled and you may lose some functionality. This may have a detrimental impact on your browsing experience and mean that you may have limited access to personalised areas of the website. It is important to bear in mind that with cookies disabled, a very tiny amount of information will continue to be retrieved from your web browser.
How to Manage all Cookies:
As outlined above in the section “How to disable our cookies” whilst you have the ability to disable our cookies it is also possible to block or delete some, or all cookies that have already been set on your device by the web browser you have chosen to use. If you wish to restrict or delete some or all of the web browser cookies set on your device, you can do so through your browser settings. The “Help” function within the web browser on your device will explain how to amend the cookie settings.
Further information on can be found on either of the sites below and both contain comprehensive information on how to manage cookies on a wide variety of desktop browsers. • https://www.aboutcookies.org • https://ico.org.uk/for-the-public/online/cookies/
Who We Are:
This is the Cookie Policy of the Dublin Skylon Hotel. Our registered office is Upper Drumcondra Road, Drumcondra Dublin 9. If you have any questions about our Cookie Policy, you may contact us at reservations\@dublinskylonhotel.com , or send a letter to Dublin Skylon Hotel, Upper Drumcondra Road, Drumcondra Dublin 9.
", 'text_events_meta_descr' => 'Whether an intimate wedding, product launch or a private dinner, the luxurious event facilities at The Fitzwilliam Hotel provide the perfect setting to ensure your event will be a success. With facilities catering from 8 to 80 persons, the hotel offers a number of options each with its own contemporary backdrop and unique features. ', 'ingenico_api_user_v' => undef, 'ingenico_passphrase' => undef, 'flag_extended_date' => 0, 'text_packages7_meta_keywords' => '', 'navigation_color' => undef, 'flag_html_email' => 1, 'chav_expand_first_only' => 0, 'text_packages7_meta_title' => 'testing', 'max_noav_rooms' => 5, 'traffic_report_link' => 'https://datastudio.google.com/s/rS6p_thM_xk', 'flag_diffcom_corporate' => 0, 'thmwidth' => 115, 'text_packages4_meta_descr' => '', 'chav_lookahead' => 0, 'mobile_twitter_tab' => 1, 'flag_spa_content' => 1, 'flag_enhancements_open' => 0, 'vouchers_realex' => 0, 'hotsoft_port' => '103', 'mobile_hotelinfo_tab' => 1, 'facebook_show_comments' => 0, 'text_packagesfb_meta_title' => undef, 'pageimageurl' => '//david.bketest.office.netaffinity.net/bookings/showimage?type=9&id=3FAEF3C21AB0F9D48F9F737D84A44ED2', 'flag_golf_content' => 1, 'text_packages6_meta_title' => 'Summer??????', 'footer_color' => undef, 'dining_content' => 'this is a swell place to eat', 'meetings_content' => 'meet here', 'twitter' => 'FitzwilliamBEL', 'flag_gridview_remove_noavail_rateplans' => 1, 'text_packages4_title' => 'Early Bird Special', 'text_vouchers_meta_descr' => 'Surprise a loved one with one of our fabulous Gift Vouchers for the Fitzwilliam Dublin. Perfect for Birthdays, anniversaries, Christmas or even to say Thanks! ', 'fb_reviews_tab' => 0, 'pcip_disable_card_view' => undef, 'flag_show_orderid' => 0, 'action_bar_button_text' => undef, 'flag_noav_app' => 1, 'flag_prepay' => 2, 'text_packagesfb_meta_keywords' => undef, 'affiliate_logo' => undef, 'idhotelgroup' => undef, 'text_events_meta_keywords' => 'Events in The Fitzwilliam, Weddings at the Fitzwilliam, Events in Belfast', 'fb_contact_tab' => 0, 'disable_email_terms' => 0, 'header_color' => undef, 'description' => 'It\'s a swell hotel.', 'mobile_booknow_tab' => 1, 'contactfax' => '', 'loyalty_valueperpoint' => '0', 'ingenico_pspid_v' => undef, 'sagepay_vendorkey_v' => undef, 'skyscanner' => undef, 'logo_small_height' => 53, 'voucher_click_collect_hours' => '0', 'balance_payable_on' => 'Departure', 'ubke_id' => '1B2E371F074F20AF1F950BD5BE2B2A64', 'microsoft_report_link' => '', 'text_packages3_meta_title' => '', 'text_crosssell_meta_keywords' => undef, 'flag_mobile_app' => 0, 'flag_noav_showguest' => 1, 'recaptcha' => 1, 'sagepay_vendorname' => undef, 'cross_packages4' => 1, 'fb_events_tab' => 0, 'sbox_dateoffs' => 0, 'text_vouchers_meta_title' => 'Vouchers for the Fitzwilliam Hotel Dublin, Gift Vouchers in the Fitzwilliam Dublin, Dublin Gift Vouchers', 'commissiontier' => 1, 'specials_perpage' => 2, 'umd5_id' => '492804A56EB9A79A1B03FE7224987D77', 'name' => 'D E', 'text_events_meta_title' => 'Events in The Fitzwilliam, Weddings at the Fitzwilliam, Events in Belfast', 'flag_room_avail_pool' => 0, 'flag_send_confirmation_customer' => 1, 'reviews_short' => 3, 'mobile_contact_tab' => 1, 'tripadvisor' => 1, 'text_packages3_meta_descr' => '', 'spa_content' => 'relax here', 'flag_quick_listview' => 0, 'flag_securemail' => 0, 'flag_group_crossell' => 0, 'flag_sagepay_v' => undef, 'flag_show_review_response' => 0, 'triptease_display' => undef, 'flag_online_voucher_redemption' => 1, 'map_zoom' => 13, 'aband_screen_message_head' => "Don\x{2019}t leave just yet!", 'flag_roompref' => 0, 'timezone' => 'Europe/Dublin', 'flag_sagepay' => undef, 'flag_prestay_email' => 1, 'aband_screen_message_text' => 'Did you know we have a wide range of Special offers available, why not check them out now?
@Callers = (
'/frontend/c/debugdev:add_log',
'/frontend/db/getroomgrid',
'/frontend/c/specials:getcalendar',
'/frontend/c/specials:calendar',
'/frontend/c/specials',
'/frontend/pages/packages2',
'/frontend/pages/autohandler'
);
%ARGS = (
'days' => 32,
'start' => 1776971643,
'hotel_package' => undef,
'idtariffs' => 15130,
'stay' => 1
);
$VAR1 = {};
@Callers = (
'/frontend/c/debugdev:add_log',
'/frontend/db/getroomgrid',
'/frontend/c/specials:getcalendar',
'/frontend/c/specials:calendar',
'/frontend/c/specials',
'/frontend/pages/packages2',
'/frontend/pages/autohandler'
);
%ARGS = (
'start' => 1777633200,
'days' => 32,
'hotel_package' => undef,
'idtariffs' => 15130,
'stay' => 1
);
$VAR1 = {};
@Callers = (
'/frontend/c/debugdev:add_log',
'/frontend/db/getroomtypes',
'/frontend/c/specials',
'/frontend/pages/packages2',
'/frontend/pages/autohandler'
);
%ARGS = ();
SELECT id, name, descr, image <> '' as image, maxpeople, md5_id, naming_singular, naming_plural, (select code from roomcategories where id = idroomcategories) as roomcategory,idhotel,
(SELECT id FROM image_items WHERE active AND iditem = roomtypes_en.id AND idimagetype IN (SELECT id FROM imagetypes WHERE ACTIVE AND name = 'roomtypes_image' LIMIT 1) AND featured) as featured_image,
(SELECT array_agg(id order by (select filepath from images where images.id = image_items.idimage)) FROM image_items WHERE active AND iditem = roomtypes_en.id AND idimagetype IN (SELECT id FROM imagetypes WHERE ACTIVE AND name = 'roomtypes_image' LIMIT 1) AND NOT featured) as gallery_images, zorder, minpeople
FROM roomtypes_en
WHERE active AND idhotel IN (1444) AND enabled
AND id NOT IN (SELECT idroomtype FROM banned_roomtypes WHERE active AND idurlalias = 1670)
--AND is_service IS FALSE
ORDER BY zorder
@Callers = (
'/frontend/c/debugdev:add_log',
'/frontend/db/getspecials',
'/frontend/c/specials',
'/frontend/pages/packages2',
'/frontend/pages/autohandler'
);
%ARGS = (
'all' => 0,
'facilities' => undef,
'hoteltypes' => undef,
'random' => undef,
'select_specific_ratecode' => undef,
'lim' => undef,
'select_ids_only' => 1,
'type' => 'packages2',
'page' => 0,
'max' => undef,
'select_only_available' => undef,
'hotelgrouppackages' => undef,
'hotelratings' => undef,
'order' => undef,
'ratecode' => undef,
'bke_id' => undef,
'perpage' => undef,
'slug' => undef,
'hotel_package' => undef,
'arrival' => undef,
'infinite_scroll' => 1,
'loyalty' => 0,
'dateto' => undef,
'occupancy' => undef,
'activities' => undef,
'tariff' => undef,
'search' => undef,
'county' => undef,
'services' => undef,
'datefrom' => undef,
'themes' => undef,
'hotel_name_order' => undef,
'idhotel' => 1444
);
SELECT * FROM (SELECT t.id, t.name, shortdesc, longdesc,
minstay, validfrom, validto, weekdays, arrive_on,
extract(day from validfrom) as arrival_day,
extract(month from validfrom) as arrival_month,
extract(year from validfrom) as arrival_year,
extract(day from validto) as departure_day,
extract(month from validto) as departure_month,
extract(year from validto) as departure_year,
(validto-validfrom) AS days, room_from_calc, room_from_specials AS room_from, cu.symbol as curr_symbol, md5_id, t.slug,
image <> '' AS image, t.created::date as created, t.changed::date as changed,
CASE WHEN now() < validfrom THEN true ELSE false END AS future,
CASE WHEN now() > validfrom THEN extract(epoch from now()) ELSE extract(epoch from validfrom) END AS arrival,
extract(epoch from validto) as leave,
extract(epoch from validfrom) as efrom,
extract(epoch from validto) as eto, flag_calendar,
extract(epoch from t.changed)::int as echanged,
h.name as hotelname, h.ranking as hotelrating, h.bke_id, h.id as idhotel, price_remark, show_total_price, is_service, show_per_person_rates, book_days_before, consol_descr, t.zorder as priority,
h.gps_lat, h.gps_long,
h.slug as hotelslug, l.name as locationname, l.slug as locationslug, c.name as countyname, c.slug as countyslug, cc.slug as countryslug, h.ranking, h.contactadr as hoteladdress, book_days_before_weekdays,maxstay,t.badge as TARIFFBADGES, (SELECT id FROM image_items WHERE active AND iditem = t.id AND idimagetype IN (SELECT id FROM imagetypes WHERE ACTIVE AND name = 'tarrifs_image' LIMIT 1) AND featured) as featured_image
FROM tarrifs_en t
JOIN hotels_en h ON (h.id = t.idhotel)
JOIN locations l ON (l.id = h.idlocation)
JOIN counties c ON (c.id = l.idcounty)
JOIN countries cc ON (cc.id = c.idcountry)
JOIN currencies cu ON (cu.id = cc.idcurrency)
WHERE t.idhotel = '1444' AND is_corporate is false
AND validto > now()
AND t.active
AND show_on_packages2 AND is_for_loyalty IS FALSE AND NOT t.is_service
AND ( is_banquet) IS NOT TRUE
AND t.id NOT IN (SELECT idtarrif FROM banned_tarrifs WHERE active AND idurlalias = 1670)
) a ORDER BY priority
@Callers = (
'/frontend/c/debugdev:add_log',
'/frontend/db/getspecials',
'/frontend/c/specials',
'/frontend/pages/packages2',
'/frontend/pages/autohandler'
);
%ARGS = (
'ratecode' => undef,
'bke_id' => undef,
'hotelgrouppackages' => undef,
'hotelratings' => undef,
'order' => undef,
'arrival' => undef,
'infinite_scroll' => 1,
'hotel_package' => undef,
'perpage' => undef,
'slug' => undef,
'services' => undef,
'county' => undef,
'search' => undef,
'activities' => undef,
'tariff' => undef,
'loyalty' => 0,
'dateto' => undef,
'idhotel' => 1444,
'themes' => undef,
'hotel_name_order' => undef,
'datefrom' => undef,
'select_specific_ratecode' => undef,
'hoteltypes' => undef,
'facilities' => undef,
'random' => undef,
'all' => 0,
'lim' => undef,
'selected_tarrifs' => [
15130
],
'page' => 0,
'type' => 'packages2',
'max' => undef,
'no_valid_to' => undef
);
SELECT * FROM (SELECT t.id, t.name, shortdesc, longdesc,
minstay, validfrom, validto, weekdays, arrive_on,
extract(day from validfrom) as arrival_day,
extract(month from validfrom) as arrival_month,
extract(year from validfrom) as arrival_year,
extract(day from validto) as departure_day,
extract(month from validto) as departure_month,
extract(year from validto) as departure_year,
(validto-validfrom) AS days, room_from_calc, room_from_specials AS room_from, cu.symbol as curr_symbol, md5_id, t.slug,
image <> '' AS image, t.created::date as created, t.changed::date as changed,
CASE WHEN now() < validfrom THEN true ELSE false END AS future,
CASE WHEN now() > validfrom THEN extract(epoch from now()) ELSE extract(epoch from validfrom) END AS arrival,
extract(epoch from validto) as leave,
extract(epoch from validfrom) as efrom,
extract(epoch from validto) as eto, flag_calendar,
extract(epoch from t.changed)::int as echanged,
h.name as hotelname, h.ranking as hotelrating, h.bke_id, h.id as idhotel, price_remark, show_total_price, is_service, show_per_person_rates, book_days_before, consol_descr, t.zorder as priority,
h.gps_lat, h.gps_long,
h.slug as hotelslug, l.name as locationname, l.slug as locationslug, c.name as countyname, c.slug as countyslug, cc.slug as countryslug, h.ranking, h.contactadr as hoteladdress, book_days_before_weekdays,maxstay,t.badge as TARIFFBADGES, (SELECT id FROM image_items WHERE active AND iditem = t.id AND idimagetype IN (SELECT id FROM imagetypes WHERE ACTIVE AND name = 'tarrifs_image' LIMIT 1) AND featured) as featured_image
FROM tarrifs_en t
JOIN hotels_en h ON (h.id = t.idhotel)
JOIN locations l ON (l.id = h.idlocation)
JOIN counties c ON (c.id = l.idcounty)
JOIN countries cc ON (cc.id = c.idcountry)
JOIN currencies cu ON (cu.id = cc.idcurrency)
WHERE t.idhotel = '1444' AND is_corporate is false
AND validto > now()
AND t.active
AND show_on_packages2 AND is_for_loyalty IS FALSE AND t.id in ('15130') AND NOT t.is_service
AND ( is_banquet) IS NOT TRUE
AND t.id NOT IN (SELECT idtarrif FROM banned_tarrifs WHERE active AND idurlalias = 1670)
) a ORDER BY priority
@Callers = (
'/frontend/c/debugdev:add_log',
'/frontend/db/checkratecodetype',
'/frontend/c/searchbox',
'/frontend/c/specials:quicksearch_open',
'/frontend/c/specials',
'/frontend/pages/packages2',
'/frontend/pages/autohandler'
);
%ARGS = (
'code' => undef
);
(SELECT code, 'wedding' AS type FROM banquets WHERE idhotel = 1444 AND code IS NOT NULL)
UNION
(SELECT code, 'corp' AS type FROM corporations WHERE idhotel = 1444 AND code IS NOT NULL AND idhotelgroup IS NULL)
UNION
(SELECT code, 'discount' AS type FROM discounts WHERE idhotel = 1444 AND code IS NOT NULL AND idhotelgroup IS NULL)
UNION
(SELECT code, 'package' AS type FROM hotel_packages WHERE idhotel = 1444 AND code IS NOT NULL)
UNION
(SELECT code, 'tariff' AS type FROM tarrifs WHERE idhotel = 1444 AND NOT is_banquet AND NOT is_corporate AND code IS NOT NULL)
@Callers = (
'/frontend/c/debugdev:add_log',
'/frontend/db/getroomgrid',
'/frontend/c/specials:getcalendar',
'/frontend/c/specials:calendar',
'/frontend/c/specials',
'/frontend/pages/packages2',
'/frontend/pages/autohandler'
);
%ARGS = (
'days' => 32,
'start' => 1776971643,
'hotel_package' => undef,
'idtariffs' => 15130,
'stay' => 1
);
-- IP 216.73.217.38 | dates: from '23.04.2026' to '25.05.2026' | URL: david.bketest.office.netaffinity.net (1670) agent: Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
SELECT r.idtarrif, rt.id as idroomtype, to_char(a.day, 'YYYY-MM-DD') as day, a.available, (r.rate) as rate, CASE WHEN ro.maxpeople = 0 THEN r.rate ELSE (r.rate)/ro.maxpeople END AS rate_per_person ,
t.show_per_person_rates, t.is_service, t.price_remark, t.price_sum_remark, t.min_rooms2book, t.is_default, t.room_from,
CASE WHEN substring(t.arrive_on from CASE WHEN extract('dow' from a.day)::integer = 0
THEN 7
ELSE extract('dow' from a.day)::integer
END for 1) = '1'
THEN true
ELSE false
END AS arrive_on,
CASE WHEN substring(t.weekdays from CASE WHEN extract('dow' from a.day)::integer = 0
THEN 7
ELSE extract('dow' from a.day)::integer
END for 1) = '1'
THEN true
ELSE false
END AS stay_on,
coalesce(hm.minstay, 0) as minstay, coalesce(rm.minstay, 0) as roomminstay, rt.flag_omit_lowestpricecalc, r.rate as rate_orig, CASE WHEN ro.maxpeople = 0 THEN r.rate ELSE r.rate/ro.maxpeople END as rate_per_person_orig, extract(epoch from a.day) as day_timestamp,
t.maxstay as tmaxstay,t.minstay as tminstay
FROM (select DISTINCT aa.idroomtype, aa.available, aa.day, aa.active, t.id as idtarrif FROM availability aa
JOIN tarrifs t ON (aa.idtarrif = (SELECT CASE WHEN check_pool IS FALSE
THEN tt.id ELSE (SELECT id FROM tarrifs WHERE active AND idhotel = tt.idhotel
AND availability_pool) END FROM tarrifs tt WHERE tt.id = t.id)
)
WHERE t.id IN (15130) AND aa.day BETWEEN '23.04.2026' AND '25.05.2026') as a
JOIN rates r ON (a.idtarrif = r.idtarrif)
JOIN tarrifs_en t ON (t.id = r.idtarrif)
JOIN roomoccupants ro ON (r.idroomoccupant = ro.id AND ro.idroomtype = a.idroomtype)
JOIN roomtypes rt ON (rt.active and rt.enabled and rt.id = ro.idroomtype)
LEFT JOIN hotel_minstay hm ON (hm.startdate = a.day AND hm.active AND hm.idhotel = 1444 AND hm.idroomtype IS NULL AND hm.idenhancement IS NULL AND hm.iddiscount IS NULL AND hm.idtarrif IS NULL AND (hm.idurlalias IS NULL OR hm.idurlalias = 1670) AND hm.minstay != '999999')LEFT JOIN hotel_minstay rm ON (rm.startdate = a.day AND rm.active AND rm.idhotel = 1444 AND rm.idroomtype = ro.idroomtype AND rm.idenhancement IS NULL AND rm.iddiscount IS NULL AND (rm.idtarrif IS NULL OR rm.idtarrif = r.idtarrif) AND (rm.idurlalias IS NULL OR rm.idurlalias = 1670) AND rm.minstay != '999999') WHERE a.active
AND r.day BETWEEN '23.04.2026' AND '25.05.2026'
AND r.day = a.day
AND a.day >= t.validfrom AND a.day < t.validto
AND substring(t.weekdays from CASE WHEN extract('dow' from a.day)::integer = 0 THEN 7 ELSE extract('dow' from a.day)::integer END for 1) = '1'
-- speed up query
-- AND a.idroomtype NOT IN (SELECT idroomtype FROM hotel_minstay WHERE active AND idhotel = 1444 AND a.day=startdate AND minstay = '999999' AND idroomtype IS NOT NULL AND idtarrif IS NULL)
-- query to replace other closeouts queries
AND NOT EXISTS (SELECT 1 FROM hotel_minstay WHERE active AND idhotel = 1444 AND a.day=startdate AND minstay = 999999 AND ((idroomtype IS NULL AND idtarrif IS NULL AND idurlalias IS NULL) OR (idroomtype IS NULL AND idtarrif IS NULL AND idurlalias = 1670) OR (idroomtype = a.idroomtype AND idtarrif IS NULL AND idurlalias IS NULL) OR (idroomtype = a.idroomtype AND idtarrif = r.idtarrif AND idurlalias IS NULL)) AND idenhancement IS NULL AND iddiscount IS NULL)
-- speed up query
-- AND rt.id NOT IN (SELECT idroomtype FROM hotel_minstay WHERE startdate = a.day AND idtarrif = r.idtarrif AND a.idroomtype = idroomtype AND active AND minstay = '999999')
AND a.day BETWEEN '23.04.2026' AND '25.05.2026'
AND a.day-now()::date >= t.book_days_before AND a.day-now()::date <= t.booking_window_days
-- speedup query
-- AND NOT EXISTS (SELECT 1 FROM hotel_minstay WHERE active AND idhotel = 1444 AND a.day=startdate AND minstay = '999999' AND idroomtype IS NULL AND idtarrif IS NULL AND idenhancement IS NULL AND iddiscount IS NULL AND (idurlalias IS NULL OR idurlalias = 1670))
AND r.active AND ro.active
AND ro.is_per_room
-- speed up query
-- AND NOT EXISTS (SELECT 1 FROM hotel_minstay WHERE active AND idhotel = 1444 AND a.day=startdate AND minstay = '999999' AND ((idroomtype IS NULL AND idenhancement IS NULL AND idtarrif IS NULL AND iddiscount IS NULL AND (idurlalias IS NULL OR idurlalias = 1670)) OR (idroomtype = a.idroomtype AND idtarrif IS NULL)))
AND NOT EXISTS (SELECT 1 FROM tarrifblockouts
WHERE active AND idtarrif = t.id AND a.day BETWEEN suspendfrom AND suspendto)
AND a.idroomtype NOT IN (SELECT idroomtype FROM banned_tarrif_roomtypes WHERE active AND idtarrif = r.idtarrif)
and a.available > 0
@Callers = (
'/frontend/c/debugdev:add_log',
'/frontend/db/getroomgrid',
'/frontend/c/specials:getcalendar',
'/frontend/c/specials:calendar',
'/frontend/c/specials',
'/frontend/pages/packages2',
'/frontend/pages/autohandler'
);
%ARGS = (
'start' => 1777633200,
'days' => 32,
'hotel_package' => undef,
'idtariffs' => 15130,
'stay' => 1
);
-- IP 216.73.217.38 | dates: from '01.05.2026' to '02.06.2026' | URL: david.bketest.office.netaffinity.net (1670) agent: Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
SELECT r.idtarrif, rt.id as idroomtype, to_char(a.day, 'YYYY-MM-DD') as day, a.available, (r.rate) as rate, CASE WHEN ro.maxpeople = 0 THEN r.rate ELSE (r.rate)/ro.maxpeople END AS rate_per_person ,
t.show_per_person_rates, t.is_service, t.price_remark, t.price_sum_remark, t.min_rooms2book, t.is_default, t.room_from,
CASE WHEN substring(t.arrive_on from CASE WHEN extract('dow' from a.day)::integer = 0
THEN 7
ELSE extract('dow' from a.day)::integer
END for 1) = '1'
THEN true
ELSE false
END AS arrive_on,
CASE WHEN substring(t.weekdays from CASE WHEN extract('dow' from a.day)::integer = 0
THEN 7
ELSE extract('dow' from a.day)::integer
END for 1) = '1'
THEN true
ELSE false
END AS stay_on,
coalesce(hm.minstay, 0) as minstay, coalesce(rm.minstay, 0) as roomminstay, rt.flag_omit_lowestpricecalc, r.rate as rate_orig, CASE WHEN ro.maxpeople = 0 THEN r.rate ELSE r.rate/ro.maxpeople END as rate_per_person_orig, extract(epoch from a.day) as day_timestamp,
t.maxstay as tmaxstay,t.minstay as tminstay
FROM (select DISTINCT aa.idroomtype, aa.available, aa.day, aa.active, t.id as idtarrif FROM availability aa
JOIN tarrifs t ON (aa.idtarrif = (SELECT CASE WHEN check_pool IS FALSE
THEN tt.id ELSE (SELECT id FROM tarrifs WHERE active AND idhotel = tt.idhotel
AND availability_pool) END FROM tarrifs tt WHERE tt.id = t.id)
)
WHERE t.id IN (15130) AND aa.day BETWEEN '01.05.2026' AND '02.06.2026') as a
JOIN rates r ON (a.idtarrif = r.idtarrif)
JOIN tarrifs_en t ON (t.id = r.idtarrif)
JOIN roomoccupants ro ON (r.idroomoccupant = ro.id AND ro.idroomtype = a.idroomtype)
JOIN roomtypes rt ON (rt.active and rt.enabled and rt.id = ro.idroomtype)
LEFT JOIN hotel_minstay hm ON (hm.startdate = a.day AND hm.active AND hm.idhotel = 1444 AND hm.idroomtype IS NULL AND hm.idenhancement IS NULL AND hm.iddiscount IS NULL AND hm.idtarrif IS NULL AND (hm.idurlalias IS NULL OR hm.idurlalias = 1670) AND hm.minstay != '999999')LEFT JOIN hotel_minstay rm ON (rm.startdate = a.day AND rm.active AND rm.idhotel = 1444 AND rm.idroomtype = ro.idroomtype AND rm.idenhancement IS NULL AND rm.iddiscount IS NULL AND (rm.idtarrif IS NULL OR rm.idtarrif = r.idtarrif) AND (rm.idurlalias IS NULL OR rm.idurlalias = 1670) AND rm.minstay != '999999') WHERE a.active
AND r.day BETWEEN '01.05.2026' AND '02.06.2026'
AND r.day = a.day
AND a.day >= t.validfrom AND a.day < t.validto
AND substring(t.weekdays from CASE WHEN extract('dow' from a.day)::integer = 0 THEN 7 ELSE extract('dow' from a.day)::integer END for 1) = '1'
-- speed up query
-- AND a.idroomtype NOT IN (SELECT idroomtype FROM hotel_minstay WHERE active AND idhotel = 1444 AND a.day=startdate AND minstay = '999999' AND idroomtype IS NOT NULL AND idtarrif IS NULL)
-- query to replace other closeouts queries
AND NOT EXISTS (SELECT 1 FROM hotel_minstay WHERE active AND idhotel = 1444 AND a.day=startdate AND minstay = 999999 AND ((idroomtype IS NULL AND idtarrif IS NULL AND idurlalias IS NULL) OR (idroomtype IS NULL AND idtarrif IS NULL AND idurlalias = 1670) OR (idroomtype = a.idroomtype AND idtarrif IS NULL AND idurlalias IS NULL) OR (idroomtype = a.idroomtype AND idtarrif = r.idtarrif AND idurlalias IS NULL)) AND idenhancement IS NULL AND iddiscount IS NULL)
-- speed up query
-- AND rt.id NOT IN (SELECT idroomtype FROM hotel_minstay WHERE startdate = a.day AND idtarrif = r.idtarrif AND a.idroomtype = idroomtype AND active AND minstay = '999999')
AND a.day BETWEEN '01.05.2026' AND '02.06.2026'
AND a.day-now()::date >= t.book_days_before AND a.day-now()::date <= t.booking_window_days
-- speedup query
-- AND NOT EXISTS (SELECT 1 FROM hotel_minstay WHERE active AND idhotel = 1444 AND a.day=startdate AND minstay = '999999' AND idroomtype IS NULL AND idtarrif IS NULL AND idenhancement IS NULL AND iddiscount IS NULL AND (idurlalias IS NULL OR idurlalias = 1670))
AND r.active AND ro.active
AND ro.is_per_room
-- speed up query
-- AND NOT EXISTS (SELECT 1 FROM hotel_minstay WHERE active AND idhotel = 1444 AND a.day=startdate AND minstay = '999999' AND ((idroomtype IS NULL AND idenhancement IS NULL AND idtarrif IS NULL AND iddiscount IS NULL AND (idurlalias IS NULL OR idurlalias = 1670)) OR (idroomtype = a.idroomtype AND idtarrif IS NULL)))
AND NOT EXISTS (SELECT 1 FROM tarrifblockouts
WHERE active AND idtarrif = t.id AND a.day BETWEEN suspendfrom AND suspendto)
AND a.idroomtype NOT IN (SELECT idroomtype FROM banned_tarrif_roomtypes WHERE active AND idtarrif = r.idtarrif)
and a.available > 0
@Callers = (
'/frontend/c/debugdev:add_log',
'/frontend/db/checkratecodetype',
'/frontend/c/searchbox',
'/frontend/c/site-handler',
'/frontend/pages/packages2',
'/frontend/pages/autohandler'
);
%ARGS = (
'code' => undef
);
(SELECT code, 'wedding' AS type FROM banquets WHERE idhotel = 1444 AND code IS NOT NULL)
UNION
(SELECT code, 'corp' AS type FROM corporations WHERE idhotel = 1444 AND code IS NOT NULL AND idhotelgroup IS NULL)
UNION
(SELECT code, 'discount' AS type FROM discounts WHERE idhotel = 1444 AND code IS NOT NULL AND idhotelgroup IS NULL)
UNION
(SELECT code, 'package' AS type FROM hotel_packages WHERE idhotel = 1444 AND code IS NOT NULL)
UNION
(SELECT code, 'tariff' AS type FROM tarrifs WHERE idhotel = 1444 AND NOT is_banquet AND NOT is_corporate AND code IS NOT NULL)
0.5935 - clearing name pagelayout.html >>> pagelayout.html 0.5959 - david.bketest.office.netaffinity.net cannot find /apps/bke/hotels/websites/david.bketest.office.netaffinity.net/bookings/pagelayout.html >> /frontend/c/pagelayout 0.5963 - david.bketest.office.netaffinity.net returning /apps/bke/hotels/websites/core.bke1.netaffinity.com/bookings/pagelayout.html >> /frontend/c/pagelayout 0.5976 - clearing name includes/head-code.html >>> includes/head-code.html 0.5980 - david.bketest.office.netaffinity.net cannot find /apps/bke/hotels/websites/david.bketest.office.netaffinity.net/includes/head-code.html >> /frontend/c/readfile:get_own_content 0.5987 - david.bketest.office.netaffinity.net returning /apps/bke/hotels/websites/core.bke1.netaffinity.com/includes/head-code.html >> /frontend/c/readfile:get_own_content 0.5994 - clearing name includes/header.html >>> includes/header.html 0.5998 - david.bketest.office.netaffinity.net cannot find /apps/bke/hotels/websites/david.bketest.office.netaffinity.net/includes/header.html >> /frontend/c/readfile:get_own_content 0.6001 - david.bketest.office.netaffinity.net returning /apps/bke/hotels/websites/core.bke1.netaffinity.com/includes/header.html >> /frontend/c/readfile:get_own_content 0.6008 - clearing name includes/footer.html >>> includes/footer.html 0.6011 - david.bketest.office.netaffinity.net cannot find /apps/bke/hotels/websites/david.bketest.office.netaffinity.net/includes/footer.html >> /frontend/c/readfile:get_own_content 0.6014 - david.bketest.office.netaffinity.net returning /apps/bke/hotels/websites/core.bke1.netaffinity.com/includes/footer.html >> /frontend/c/readfile:get_own_content 0.6031 - clearing name includes/bke-searchbox.html?display=overlay&hidden=yes >>> includes/bke-searchbox.html?display=overlay&hidden=yes 0.6035 - david.bketest.office.netaffinity.net cannot find /apps/bke/hotels/websites/david.bketest.office.netaffinity.net/includes/bke-searchbox.html >> /frontend/c/readfile:get_own_content 0.6038 - david.bketest.office.netaffinity.net returning /apps/bke/hotels/websites/core.bke1.netaffinity.com/includes/bke-searchbox.html >> /frontend/c/readfile:get_own_content 0.6861 - clearing name package.html >>> package.html 0.6864 - clearing name special.html >>> special.html 0.6869 - david.bketest.office.netaffinity.net cannot find /apps/bke/hotels/websites/david.bketest.office.netaffinity.net/bookings/packagelong.html >> /frontend/c/specials 0.6872 - david.bketest.office.netaffinity.net cannot find /apps/bke/hotels/websites/david.bketest.office.netaffinity.net/bookings/speciallong.html >> /frontend/c/specials 0.6874 - david.bketest.office.netaffinity.net cannot find /apps/bke/hotels/websites/david.bketest.office.netaffinity.net/bookings/package.html >> /frontend/c/specials 0.6883 - david.bketest.office.netaffinity.net cannot find /apps/bke/hotels/websites/david.bketest.office.netaffinity.net/bookings/special.html >> /frontend/c/specials 0.6886 - david.bketest.office.netaffinity.net cannot find /apps/bke/hotels/websites/core.bke1.netaffinity.com/bookings/packagelong.html >> /frontend/c/specials 0.6892 - david.bketest.office.netaffinity.net cannot find /apps/bke/hotels/frontend/templates/packagelong.html >> /frontend/c/specials 0.6896 - david.bketest.office.netaffinity.net returning /apps/bke/hotels/websites/core.bke1.netaffinity.com/bookings/speciallong.html >> /frontend/c/specials 0.7001 - clearing name quicksearch.html >>> quicksearch.html 0.7004 - clearing name searchbox.html >>> searchbox.html 0.7009 - david.bketest.office.netaffinity.net cannot find /apps/bke/hotels/websites/david.bketest.office.netaffinity.net/bookings/default-quicksearch-jquery.html >> /frontend/c/searchbox 0.7012 - david.bketest.office.netaffinity.net cannot find /apps/bke/hotels/websites/david.bketest.office.netaffinity.net/bookings/default-searchbox-jquery.html >> /frontend/c/searchbox 0.7014 - david.bketest.office.netaffinity.net cannot find /apps/bke/hotels/websites/david.bketest.office.netaffinity.net/bookings/default-quicksearch.html >> /frontend/c/searchbox 0.7016 - david.bketest.office.netaffinity.net cannot find /apps/bke/hotels/websites/david.bketest.office.netaffinity.net/bookings/default-searchbox.html >> /frontend/c/searchbox 0.7019 - david.bketest.office.netaffinity.net cannot find /apps/bke/hotels/websites/david.bketest.office.netaffinity.net/bookings/quicksearch.html >> /frontend/c/searchbox 0.7031 - david.bketest.office.netaffinity.net cannot find /apps/bke/hotels/websites/david.bketest.office.netaffinity.net/bookings/searchbox.html >> /frontend/c/searchbox 0.7041 - david.bketest.office.netaffinity.net returning /apps/bke/hotels/websites/core.bke1.netaffinity.com/bookings/default-quicksearch-jquery.html >> /frontend/c/searchbox 0.7360 - clearing name includes/usp.html >>> includes/usp.html 0.7364 - david.bketest.office.netaffinity.net cannot find /apps/bke/hotels/websites/david.bketest.office.netaffinity.net/includes/usp.html >> /frontend/c/readfile:get_own_content 0.7367 - david.bketest.office.netaffinity.net returning /apps/bke/hotels/websites/core.bke1.netaffinity.com/includes/usp.html >> /frontend/c/readfile:get_own_content 0.7750 - clearing name includes/settings-bar.html >>> includes/settings-bar.html 0.7756 - david.bketest.office.netaffinity.net cannot find /apps/bke/hotels/websites/david.bketest.office.netaffinity.net/includes/settings-bar.html >> /frontend/c/readfile:get_own_content 0.7759 - david.bketest.office.netaffinity.net returning /apps/bke/hotels/websites/core.bke1.netaffinity.com/includes/settings-bar.html >> /frontend/c/readfile:get_own_content 0.7767 - clearing name includes/progress-bar.html >>> includes/progress-bar.html 0.7771 - david.bketest.office.netaffinity.net cannot find /apps/bke/hotels/websites/david.bketest.office.netaffinity.net/includes/progress-bar.html >> /frontend/c/readfile:get_own_content 0.7774 - david.bketest.office.netaffinity.net returning /apps/bke/hotels/websites/core.bke1.netaffinity.com/includes/progress-bar.html >> /frontend/c/readfile:get_own_content 0.7781 - clearing name includes/mobile.html >>> includes/mobile.html 0.7794 - david.bketest.office.netaffinity.net cannot find /apps/bke/hotels/websites/david.bketest.office.netaffinity.net/includes/mobile.html >> /frontend/c/readfile:get_own_content 0.7797 - david.bketest.office.netaffinity.net returning /apps/bke/hotels/websites/core.bke1.netaffinity.com/includes/mobile.html >> /frontend/c/readfile:get_own_content 0.7811 - clearing name includes/made-by-na.html >>> includes/made-by-na.html 0.7815 - david.bketest.office.netaffinity.net cannot find /apps/bke/hotels/websites/david.bketest.office.netaffinity.net/includes/made-by-na.html >> /frontend/c/readfile:get_own_content 0.7818 - david.bketest.office.netaffinity.net returning /apps/bke/hotels/websites/core.bke1.netaffinity.com/includes/made-by-na.html >> /frontend/c/readfile:get_own_content 0.7825 - clearing name includes/slide-panel.html >>> includes/slide-panel.html 0.7828 - david.bketest.office.netaffinity.net cannot find /apps/bke/hotels/websites/david.bketest.office.netaffinity.net/includes/slide-panel.html >> /frontend/c/readfile:get_own_content 0.7832 - david.bketest.office.netaffinity.net returning /apps/bke/hotels/websites/core.bke1.netaffinity.com/includes/slide-panel.html >> /frontend/c/readfile:get_own_content 0.7839 - clearing name includes/searchbox-location.html >>> includes/searchbox-location.html 0.7852 - david.bketest.office.netaffinity.net cannot find /apps/bke/hotels/websites/david.bketest.office.netaffinity.net/includes/searchbox-location.html >> /frontend/c/readfile:get_own_content 0.7856 - david.bketest.office.netaffinity.net returning /apps/bke/hotels/websites/core.bke1.netaffinity.com/includes/searchbox-location.html >> /frontend/c/readfile:get_own_content 0.7867 - clearing name includes/booking-summary-cal.html >>> includes/booking-summary-cal.html 0.7871 - david.bketest.office.netaffinity.net cannot find /apps/bke/hotels/websites/david.bketest.office.netaffinity.net/includes/booking-summary-cal.html >> /frontend/c/readfile:get_own_content 0.7874 - david.bketest.office.netaffinity.net returning /apps/bke/hotels/websites/core.bke1.netaffinity.com/includes/booking-summary-cal.html >> /frontend/c/readfile:get_own_content 0.7979 - clearing name searchbox.html >>> searchbox.html 0.7983 - david.bketest.office.netaffinity.net cannot find /apps/bke/hotels/websites/david.bketest.office.netaffinity.net/bookings/default-searchbox-jquery.html >> /frontend/c/searchbox 0.7986 - david.bketest.office.netaffinity.net cannot find /apps/bke/hotels/websites/david.bketest.office.netaffinity.net/bookings/default-searchbox.html >> /frontend/c/searchbox 0.7988 - david.bketest.office.netaffinity.net cannot find /apps/bke/hotels/websites/david.bketest.office.netaffinity.net/bookings/searchbox.html >> /frontend/c/searchbox 0.7991 - david.bketest.office.netaffinity.net returning /apps/bke/hotels/websites/core.bke1.netaffinity.com/bookings/default-searchbox-jquery.html >> /frontend/c/searchbox 0.8647 - clearing name crosssell.html >>> crosssell.html 0.8653 - david.bketest.office.netaffinity.net cannot find /apps/bke/hotels/websites/david.bketest.office.netaffinity.net/bookings/bkecol-crosssell.html >> /frontend/c/crosssell 0.8657 - david.bketest.office.netaffinity.net cannot find /apps/bke/hotels/websites/david.bketest.office.netaffinity.net/bookings/crosssell.html >> /frontend/c/crosssell 0.8660 - david.bketest.office.netaffinity.net returning /apps/bke/hotels/websites/core.bke1.netaffinity.com/bookings/bkecol-crosssell.html >> /frontend/c/crosssell