mysql:research@dbstore1004.eqiad.wmnet [cswiki]> EXPLAIN SELECT user_id,user_name FROM `user` JOIN `user_properties` ON ((user_id = up_user) AND up_property = 'growthexperiments-homepage-variant') WHERE up_value = 'control' AND (user_id > 1000) ORDER BY user_id ASC LIMIT 100;