Error Number: 1054

Unknown column 'idmes' in 'where clause'

SELECT p.id_plaga FROM plaga p left join plaga_familia f on f.id_familia = p.id_familia left join plaga_tipo_multiple tm on tm.id_plaga = p.id_plaga left join plaga_tipo t on t.id_tipo = tm.id_tipo left join plaga_calendario c on c.id_plaga = p.id_plaga where 1 and c.id_mes = idmes and LOWER(SUBSTR(nombre, 1 ,1 )) = 'Z' group by p.id_plaga