date_range_scoped_by_user_and_month(start_date, end_date, user, month)

gistfile1.sql

       SELECT id, user_id, activity_month_id, activity_week_id,
              CASE
                WHEN HOUR(starts_on) = 22 THEN DATE(TIMESTAMPADD(HOUR, 2, starts_on))
                WHEN HOUR(starts_on) = 23 THEN DATE(TIMESTAMPADD(HOUR, 1, starts_on))
                ELSE DATE(starts_on)
              END AS starts_on,
              CASE
                WHEN HOUR(ends_on) = 21 THEN DATE(TIMESTAMPADD(HOUR, 2, ends_on))
                WHEN HOUR(ends_on) = 22 THEN DATE(TIMESTAMPADD(HOUR, 1, ends_on))
                ELSE DATE(ends_on)
              END AS ends_on
       FROM activity_weeks INNER JOIN activity_months_activity_weeks ON id = activity_week_id
       WHERE
         user_id = #{user.id} AND activity_month_id = #{month.id}
       HAVING (
           starts_on >= '#{start_date}' AND ends_on   <= '#{end_date}'
         ) OR (
           starts_on <= '#{start_date}' AND starts_on <= '#{end_date}'
           AND
           ends_on   >= '#{start_date}' AND ends_on   <= '#{end_date}'
         ) OR (
           starts_on >= '#{start_date}' AND starts_on <= '#{end_date}' 
           AND
           ends_on   >= '#{start_date}' AND ends_on   >= '#{end_date}'
         )
       ORDER BY starts_on DESC