+ Responder ao Tópico



  1. #1
    felco
    Visitante

    Padrão Esta query ta certa?

    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

  2. #2
    jamba
    Visitante

    Padrão Esta query ta certa?

    Testou??