SELECT SQL_CALC_FOUND_ROWS  (SzSF5ICBr_tec_occurrences.occurrence_id + 10000000) as occurrence_id
					 FROM SzSF5ICBr_posts  LEFT JOIN SzSF5ICBr_postmeta ON ( SzSF5ICBr_posts.ID = SzSF5ICBr_postmeta.post_id )  LEFT JOIN SzSF5ICBr_postmeta AS mt1 ON ( SzSF5ICBr_posts.ID = mt1.post_id AND mt1.meta_key = 'featured_event' )  LEFT JOIN SzSF5ICBr_tec_occurrences ON SzSF5ICBr_posts.ID = SzSF5ICBr_tec_occurrences.post_id
					 WHERE 1=1  AND SzSF5ICBr_posts.ID NOT IN (6975) AND ( 
  ( 
    ( 
      ( 
        ( 
          SzSF5ICBr_postmeta.meta_key = 'featured_event' 
          OR 
          mt1.post_id IS NULL
        )
      ) 
      AND 
      ( 
        SzSF5ICBr_tec_occurrences.post_id IS NOT NULL
      )
    )
  ) 
  AND 
  ( 
    SzSF5ICBr_tec_occurrences.end_date >= '2026-11-07 14:34:06'
  )
) AND SzSF5ICBr_posts.post_type = 'tribe_events' AND ((SzSF5ICBr_posts.post_status = 'publish')) AND NOT EXISTS ( /* foxridge_same_day_helper_v1 */
                SELECT 1 FROM SzSF5ICBr_tec_occurrences AS fx_earlier
                WHERE fx_earlier.post_id = SzSF5ICBr_tec_occurrences.post_id
                  AND DATE(fx_earlier.start_date) = DATE(SzSF5ICBr_tec_occurrences.start_date)
                  AND fx_earlier.end_date >= '2026-11-07 14:34:06'
                  AND (
                      fx_earlier.start_date < SzSF5ICBr_tec_occurrences.start_date
                      OR (
                          fx_earlier.start_date = SzSF5ICBr_tec_occurrences.start_date
                          AND fx_earlier.occurrence_id < SzSF5ICBr_tec_occurrences.occurrence_id
                      )
                  )
            )
					 GROUP BY SzSF5ICBr_tec_occurrences.occurrence_id
					 ORDER BY 
        COALESCE(
            (
                SELECT MAX(CAST(pm.meta_value AS UNSIGNED))
                FROM SzSF5ICBr_postmeta pm
                WHERE pm.post_id = SzSF5ICBr_posts.ID
                  AND pm.meta_key = 'featured_event'
            ),
            0
        ) DESC
    , CASE
			-- Short events starting today or within 7 days.
			WHEN SzSF5ICBr_tec_occurrences.start_date >= '2026-11-07 00:00:00'
			 AND SzSF5ICBr_tec_occurrences.start_date < '2026-11-14 11:00:00'
			 AND TIMESTAMPDIFF(
				 SECOND,
				 SzSF5ICBr_tec_occurrences.start_date,
				 SzSF5ICBr_tec_occurrences.end_date
			 ) <= 604800
				THEN 0

			-- Long-running events starting soon or already underway.
			WHEN SzSF5ICBr_tec_occurrences.start_date < '2026-11-14 11:00:00'
			 AND SzSF5ICBr_tec_occurrences.end_date >= '2026-11-07 14:34:06'
				THEN 1

			-- Events starting beyond the next 7 days.
			WHEN SzSF5ICBr_tec_occurrences.start_date >= '2026-11-14 11:00:00'
				THEN 2

			ELSE 3
		END ASC, SzSF5ICBr_tec_occurrences.start_date ASC
					 LIMIT 0, 12