set @group = 0;

/* select in order of largest group */
select * from

  /* count the group totals of each group per user and group */
  (select userID,groupmarker,count(groupmarker) AS total
   from

    /* give each consecutive sequence a group number, per user */
    (select *,

      /* restart group number for each user */
      if(userID = @user, userID, @group := 1) AS newuser1,
      /* keep track of current user */
      if(userID = @user, userID, @user := userID) AS newuser2,
      /* while havegoal is true keep same group number */
      if(ordered.havegoal is true, @group, @group := @group+1) AS groupmarker  
      from

        /* matchdata with user selections in the correct order */
        (select ur.userID,m.havegoal
          from ogc_test as ur
          join ogc_matches as m on m.matchID = ur.matchID
          where m.matchdate >= "2011-05-01" and m.matchdate < "2011-06-01"
          order by ur.userID,m.matchdate asc,m.settled desc,m.havegoal desc
        ) AS ordered
  
    ) AS grouped

  group by userID,groupmarker
  ) AS totalled
  
order by total desc
;

select userID, t1.kickoff start_of_run, count(*) num_matches
from   YourTable t1, YourTable t2
where  t1.userID = t2.userID
       and t1.kickoff <= t2.kickoff 
       and t1.goal
       and t2.goal
       and not exists( 
            select 1
            from YourTable t3
            where t3.userId = t1.userID
                   and not t3.goal
                   and t3.kickoff between t1.kickoff and t2.kickoff )
group by userID, t1.kickoff
order by num_of_matches
limit 1