SET @start_date = '201501012000000';

SET @end_date = '20160101000000';

​

SELECT

  COUNT(log_user) AS total,

  COUNT(CASE WHEN (up_property = "gender" AND up_value = "female") THEN up_user END) AS gender_female,

  COUNT(CASE WHEN (up_property = "gender" AND up_value = "male") THEN up_user END) AS gender_male

FROM

  elwiki_p.user_properties p

JOIN 

  elwiki_p.logging l

ON 

  up_user = log_user

WHERE

  `log_type` = 'newusers' 

AND

  `log_action` = 'create'

AND

  `log_timestamp` BETWEEN @start_date AND @end_date;

​