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, 
  				( SELECT user_editcount FROM simplewiki_p.user WHERE user_ID = SIMPLE_L.log_user ) AS Global_Contributions,
  			    COUNT(SIMPLE_L.log_user) * 1.0 / ( 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 	User_ID
  	ORDER BY 	Ratio_of_global_by_Simple_English_contributions DESC
  	LIMIT		3
);
SQL

Checking query status...
