mysql - Count the best from column league -

i have table builded in sql fiddle. query counting how longest run in column more withe value vg1 before come vg2. using 'pero' count it. working.

now have column mix, , need edit query count best longest run column league='mix'.

this current state of query:

select count(*) results join (select max(str_to_date(datum, '%d.%m.%y')) d results more != 'vg1' , home = 'pero') dt on str_to_date(datum, '%d.%m.%y') > dt.d home = 'pero'; 

sqlfiddle: http://sqlfiddle.com/#!9/21dd8/1/0

new version: http://sqlfiddle.com/#!9/e8de48/3/0