contribs after a year

SQL

SELECT * 
FROM 
#( SELECT COUNT(no_c.user_name) AS no_contribs FROM user AS no_c WHERE  user_registration BETWEEN (NOW() - INTERVAL 12 MONTH) AND (NOW() - INTERVAL 11 MONTH) AND user_editcount = 0) AS no_contribs, 
#( SELECT COUNT(low_c.user_name) AS low_contribs FROM user AS low_c WHERE  user_registration BETWEEN (NOW() - INTERVAL 12 MONTH) AND (NOW() - INTERVAL 11 MONTH) AND user_editcount BETWEEN 0 AND 99) AS low_contribs, 
(
  SELECT medium_c.user_name AS medium_contribs, medium_c.editcount AS editcount
  FROM user AS medium_c
  WHERE  user_registration 
  BETWEEN (NOW() - INTERVAL 12 MONTH) AND (NOW() - INTERVAL 11 MONTH)  
  AND user_editcount BETWEEN 100 AND 4999
) AS medium_contribs, 

(
  SELECT high_c.user_name AS high_contribs,  high_c.editcount AS editcount
  FROM user AS high_c
  WHERE  user_registration 
  BETWEEN (NOW() - INTERVAL 12 MONTH) AND (NOW() - INTERVAL 11 MONTH) 
  AND user_editcount > 5000
) AS high_contribs;
SQL

Checking query status...
