Replace count(*) with count(1) in the subquery. It could help (?) to improve the performance.
Dennis Tobar Calderón (Enviado desde un móvil)
El 30 dic. 2017 3:10 p. m., "John" phoenixoverride@gmail.com escribió:
I would also find the first log of 2017 and use that instead of the timestamp
Wikimedia Cloud Services mailing list Cloud@lists.wikimedia.org (formerly labs-l@lists.wikimedia.org) https://lists.wikimedia.org/mailman/listinfo/cloud