Find country name socks

SQL

Use enwiki_p;
SELECT user_name
FROM user
JOIN ipblocks ON user_id=ipb_user 
WHERE user_registration >= 20170101000000 #AND user_registration <= 20190731000000
AND user_editcount > 0
AND HOUR(user_registration) >= 3 and HOUR(user_registration) <= 5
AND length(user_name) >=8 AND length(user_name) <=12
AND (
    user_name like ("Japa%") 
	OR user_name like ("Cana%")
	OR user_name like ("Cypr%")
	OR user_name like ("Russ%")
	OR user_name like ("Pola%") 
	OR user_name like ("Germ%") 
	OR user_name like ("Alba%") 
	OR user_name like ("Mold%") 
	OR user_name like ("Pola%") 
	OR user_name like ("Esto%") 
	OR user_name like ("Jord%") 
	OR user_name like ("Germ%") 
	OR user_name like ("Chec%") 
	OR user_name like ("Neth%") 
	OR user_name like ("Belg%") 
	OR user_name like ("Hung%") 
	OR user_name like ("Croa%") 
	OR user_name like ("Cana%") 
	OR user_name like ("Guam%") 
	OR user_name like ("Alba%") 
  	OR user_name like ("Mexi%")
  	OR user_name like ("Newz%")
  	OR user_name like ("Bang%")
  	OR user_name like ("Viet%")
  	OR user_name like ("Mace%")
  	OR user_name like ("Port%")
  	OR user_name like ("Serb%")
  	OR user_name like ("Swed%")
  	OR user_name like ("Ital%")
  	OR user_name like ("Chin%")
)
AND NOT user_name REGEXP "[0-9 \-\.]"
ORDER BY user_name
LIMIT 6500;
SQL

Checking query status...
