SELECT DISTINCT * FROM (
            SELECT * FROM (
                SELECT * FROM (
                    SELECT
                      events.*,
                      upcoming_events_times.*
                    FROM
                      (
                        SELECT
                          *
                        FROM
                          events_times
                        WHERE
                          events_times.start_date > NOW() + INTERVAL '1 day' AND
                          events_times.end_date < NOW() + INTERVAL '3 months'
                      ) AS upcoming_events_times
                        LEFT JOIN events ON (events.id = upcoming_events_times.events_id)
                    WHERE
                      events.deleted = 'f' AND
                      events.featured_home != 'No'
                ) AS all_events
              EXCEPT
              SELECT * FROM (
                    SELECT
                      events.*,
                      upcoming_events_times.*
                    FROM
                      (
                         SELECT
                           *
                         FROM
                           events_times
                         WHERE
                           events_times.start_date > NOW() + INTERVAL '1 day' AND
                           events_times.end_date < NOW() + INTERVAL '3 months'
                      ) AS upcoming_events_times
                        LEFT JOIN events ON (events.id = upcoming_events_times.events_id)
                    WHERE
                      events.deleted = 'f' AND
                      events.TYPE = 'Basketball' AND
                      events.featured_home != 'No'
                    ORDER BY start_date ASC
                    LIMIT ALL
                    OFFSET 2
                ) AS next_two_basketball
            ) AS events_plus_two_basketball
            EXCEPT
            SELECT * FROM (
            SELECT
            events.*,
            upcoming_events_times.*
            FROM
            (
             SELECT
             *
             FROM
             events_times
             WHERE
             events_times.start_date > NOW() + INTERVAL '1 day' AND
             events_times.end_date < NOW() + INTERVAL '3 months'
            ) AS upcoming_events_times
            LEFT JOIN events ON (events.id = upcoming_events_times.events_id)
            WHERE
            events.deleted = 'f' AND
            events.TYPE = 'Hockey' AND
            events.featured_home != 'No'
            ORDER BY start_date ASC
            LIMIT ALL
            OFFSET 2
            ) AS next_two_hockey
          UNION
          SELECT * FROM (
            SELECT
            events.*,
            upcoming_events_times.*
            FROM
            (
              SELECT
              *
              FROM
              events_times
              WHERE
              events_times.end_date > NOW()
            ) AS upcoming_events_times
            LEFT JOIN events ON (events.id = upcoming_events_times.events_id)
            WHERE
            events.deleted = 'f' AND
            events.featured_home = 'Yes'
          ) AS overridden_events
          ORDER BY start_date ASC
        ) full_results ORDER BY start_date ASC;