use eswiki_p;

Select user_id AS ID, user_name AS Nombre, user_real_name AS User,

FROM user

JOIN recentchanges

WHERE rc_user = 0

AND (inet_aton(rc_user_text) BETWEEN INET_ATON('129.90.0.0') AND INET_ATON ('129.90.255.255')

OR inet_aton(rc_user_text) BETWEEN INET_ATON('150.185.0.0') AND INET_ATON ('150.189.255.255')

OR inet_aton(rc_user_text) BETWEEN INET_ATON('158.160.0.0') AND INET_ATON ('158.160.255.255')

OR inet_aton(rc_user_text) BETWEEN INET_ATON('159.90.0.0') AND INET_ATON ('159.90.255.255')

OR inet_aton(rc_user_text) BETWEEN INET_ATON('161.196.0.0') AND INET_ATON ('161.196.255.255')

OR inet_aton(rc_user_text) BETWEEN INET_ATON('162.122.0.0') AND INET_ATON ('162.122.255.255')

OR inet_aton(rc_user_text) BETWEEN INET_ATON('167.134.0.0') AND INET_ATON ('167.134.255.255')

OR inet_aton(rc_user_text) BETWEEN INET_ATON('167.175.0.0') AND INET_ATON ('167.175.255.255')

OR inet_aton(rc_user_text) BETWEEN INET_ATON('170.179.0.0') AND INET_ATON ('170.179.255.255')

OR inet_aton(rc_user_text) BETWEEN INET_ATON('200.1.0.0') AND INET_ATON ('200.1.5.255')

OR inet_aton(rc_user_text) BETWEEN INET_ATON('200.1.8.0') AND INET_ATON ('200.1.15.255')

OR inet_aton(rc_user_text) BETWEEN INET_ATON('200.1.144.0') AND INET_ATON ('200.1.151.255')

OR inet_aton(rc_user_text) BETWEEN INET_ATON('200.1.164.0') AND INET_ATON ('200.1.171.255')

OR inet_aton(rc_user_text) BETWEEN INET_ATON('200.1.184.0') AND INET_ATON ('200.1.191.255')

OR inet_aton(rc_user_text) BETWEEN INET_ATON('200.2.8.0') AND INET_ATON ('200.2.15.255')

OR inet_aton(rc_user_text) BETWEEN INET_ATON('200.3.0.0') AND INET_ATON ('200.3.9.255')

OR inet_aton(rc_user_text) BETWEEN INET_ATON('200.5.16.0') AND INET_ATON ('200.5.31.255')

OR inet_aton(rc_user_text) BETWEEN INET_ATON('200.5.40.0') AND INET_ATON ('200.5.47.255')

OR inet_aton(rc_user_text) BETWEEN INET_ATON('200.5.128.0') AND INET_ATON ('200.5.191.255')

OR inet_aton(rc_user_text) BETWEEN INET_ATON('200.11.128.0') AND INET_ATON ('200.11.255.255')

OR inet_aton(rc_user_text) BETWEEN INET_ATON('200.14.8.0') AND INET_ATON ('200.14.15.255')

OR inet_aton(rc_user_text) BETWEEN INET_ATON('200.31.128.0') AND INET_ATON ('200.31.143.255')

OR inet_aton(rc_user_text) BETWEEN INET_ATON('200.35.0.0') AND INET_ATON ('200.35.31.255')

OR inet_aton(rc_user_text) BETWEEN INET_ATON('200.35.64.0') AND INET_ATON ('200.35.143.255')

OR inet_aton(rc_user_text) BETWEEN INET_ATON('200.44.0.0') AND INET_ATON ('200.44.159.255')

OR inet_aton(rc_user_text) BETWEEN INET_ATON('200.74.192.0') AND INET_ATON ('200.74.223.255')

OR inet_aton(rc_user_text) BETWEEN INET_ATON('200.75.96.0') AND INET_ATON ('200.75.143.255')

OR inet_aton(rc_user_text) BETWEEN INET_ATON('200.82.128.0') AND INET_ATON ('200.82.143.255'))

and rc_timestamp > 20170614000000;

​