Untitled query #30722

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) / 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 = User_ID AND
  				Ratio_of_global_by_Simple_English_contributions IS NOT NULL
  
  	GROUP BY 	Contributions_in_Simple_English
  
  	ORDER BY 	Ratio_of_global_by_Simple_English_contributions DESC
  
  	LIMIT		3
);
SQL

Checking query status...
