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