Offers

To edit the introductory Page Content Module(s) above the offers grid here ( https://www.hi-northampton-bell.cpdev.net/offers/) would be managed within the Site Page Editor. CA > Hotels > Hotel Sites Page Editor > Northampton > Hotel > Manage Page Content.

But it’s not!!

Filter:

No offers match the chosen filter. Please amend your search.

Dave loves an offer! Especially with chips.

Dave's "offer"

Massive bird at a small price.

Cheap turkey!

Get sozzled!

Free min-bar!!

It's Hot Out There! Get a Free Ice Cream Cone

Free icecream!

SELECT DISTINCT
CONCAT('offers-', offers.id) AS reference,
'' AS sub_level,
CONCAT('/offers/', offers.url_slug) AS uri,
'_top' AS target,
heading_approved AS title,
1 AS hide_from_navigation
FROM offers LEFT JOIN dealers ON dealers.id = offers.site_id
WHERE offers.site_id IN (1, 0)
AND heading_approved != ''
AND enabled_approved
AND !qa_declined
AND (!schedule_enabled_approved || (CURRENT_DATE >= schedule_live_approved AND CURRENT_DATE <= schedule_archive_approved))