Drupal.org Chinese user statistics

gistfile1.sql

// The number of users from China by the end of 2010
SELECT count(users.uid) AS uid 
FROM users users  
LEFT JOIN profile_values profile_values_profile_country ON users.uid = profile_values_profile_country.uid AND profile_values_profile_country.fid = '1' 
WHERE (profile_values_profile_country.value in ('China')) AND (users.created <= 1293836399)

// The number of users from China by the end of 2011
SELECT count(users.uid) AS uid 
FROM users users  
LEFT JOIN profile_values profile_values_profile_country ON users.uid = profile_values_profile_country.uid AND profile_values_profile_country.fid = '1' 
WHERE (profile_values_profile_country.value in ('China')) AND (users.created <= 1325372399)

// The number of users from China by the end of 2012
SELECT count(users.uid) AS uid 
FROM users users  
LEFT JOIN profile_values profile_values_profile_country ON users.uid = profile_values_profile_country.uid AND profile_values_profile_country.fid = '1' 
WHERE (profile_values_profile_country.value in ('China')) AND (users.created <= 1356994799)

// The number of users speaking Simplified or Traditional Chinese by the end of 2010
SELECT count(users.uid) AS uid 
FROM users users  
LEFT JOIN profile_values profile_values_profile_language ON users.uid = profile_values_profile_language.uid AND profile_values_profile_language.fid = '3' 
WHERE (users.created <= 1293836399) AND (profile_values_profile_language.value in ('Chinese, Simplified', 'Chinese, Traditional'))

// The number of users speaking Simplified or Traditional Chinese by the end of 2011
SELECT count(users.uid) AS uid 
FROM users users  
LEFT JOIN profile_values profile_values_profile_language ON users.uid = profile_values_profile_language.uid AND profile_values_profile_language.fid = '3' 
WHERE (users.created <= 1325372399) AND (profile_values_profile_language.value in ('Chinese, Simplified', 'Chinese, Traditional'))

// The number of users speaking Simplified or Traditional Chinese by the end of 2012
SELECT count(users.uid) AS uid 
FROM users users  
LEFT JOIN profile_values profile_values_profile_language ON users.uid = profile_values_profile_language.uid AND profile_values_profile_language.fid = '3' 
WHERE (users.created <= 1356994799) AND (profile_values_profile_language.value in ('Chinese, Simplified', 'Chinese, Traditional'))