Untitled query #30724

SQL

( 
  	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) / (SELECT user_editcount FROM simplewiki_p.user WHERE user_ID = SIMPLE_L.log_user) AS 'Ratio of global by Simple English contributions'
  
  	FROM 		simplewiki_p.logging AS SIMPLE_L
  
  	GROUP BY 	SIMPLE_L.log_user
  
  	ORDER BY 	COUNT(SIMPLE_L.log_user) / (SELECT user_editcount FROM simplewiki_p.user WHERE user_ID = SIMPLE_L.log_user) DESC
	HAVING		COUNT(SIMPLE_L.log_user) / (SELECT user_editcount FROM simplewiki_p.user WHERE user_ID = SIMPLE_L.log_user) >0
  	LIMIT		3
);
SQL

Checking query status...
