contribs after a year

SQL

SELECT * 
FROM (
  SELECT COUNT(no_contibs.user_name) AS no_contribs
  FROM user AS no_contribs
  WHERE  user_registration 
  BETWEEN (NOW() - INTERVAL 12 MONTH) AND (NOW() - INTERVAL 11 MONTH)  
  AND user_editcount = 0
) AS no_contribs, 
(
  SELECT COUNT(low_contribs.user_name) AS low_contribs
  FROM user AS low_contribs 
  WHERE  user_registration 
  BETWEEN (NOW() - INTERVAL 12 MONTH) AND (NOW() - INTERVAL 11 MONTH)  
  AND user_editcount = BETWEEN 0 AND 500
) AS low_contribs, 
(
  SELECT COUNT(medium_contribs.user_name) AS medium_contribs
  FROM user AS medium_contribs 
  WHERE  user_registration 
  BETWEEN (NOW() - INTERVAL 12 MONTH) AND (NOW() - INTERVAL 11 MONTH)  
  AND user_editcount = BETWEEN 0 AND 500
) AS low_contribs, 

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

Checking query status...
