Untitled query #30722

SQL

DECLARE @numberOfUsers int(2)
SET		@numberOfUsers = 3

( 
  	SELECT 		'Simple English' AS IAL, 
  				SIMPLE_L.log_user AS 'User ID', 
  				COUNT(SIMPLE_L.log_user) AS 'Contributions in Simple English', 
  				COUNT(SIMPLE_L.log_user) / SIMPLE_U.user_editcount AS 'Ratio of global by Simple English contributions'
  
  	FROM 		simplewiki_p.logging AS SIMPLE_L, 
  				simplewiki_p.user AS SIMPLE_U
  
  	WHERE		SIMPLE_U.user_id = SIMPLE_L.log_user AND
  				COUNT(SIMPLE_L.log_user) / SIMPLE_U.user_editcount IS NOT NULL
  
  	GROUP BY 	SIMPLE_L.log_user
  
  	ORDER BY 	SIMPLE_U.user_editcount / COUNT(SIMPLE_L.log_user) DESC
  
  	LIMIT		@numberOfUsers
);
SQL

Checking query status...
