SELECT count(muda.id) as quantidade,
usuario.id,usuario.nome,sum(muda.id) as desempate,
muda.data
FROM mudapatrocinada muda, usuario
WHERE muda.usuarioid = usuario.id
AND muda.data >= '$inicio'
AND muda.data <= '$fim'
AND muda.data NOT IN (SELECT date(data) FROM configuracao WHERE chave = 'mudasdia' AND date(data) <> '0000-00-00')
GROUP BY usuario.id,date(muda.data) HAVING quant > 1