Offers

Get sozzled!

Massive bird at a small price.

Dave loves an offer! Especially with chips.

कुकी चुपा चप्स गाजर केक चॉकलेट वेफर फलकेक। तिल स्नैप भालू पंजा तिरामिसु मैकरोन गुम्मी भालू मफिन मार्जिपन मार्जिपन। आइसिंग नद्यपान आइसिंग सूफ्ले केक।

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

Get drunk with mates...

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))