query to find user pages which end in things like .com, .nl

SQL

Use nlwiki_p;
SELECT
  	CONCAT('*[[Gebruiker:', user_name, ']]') as showname,
	user_registration,
	user_editcount
FROM `user`
JOIN ipblocks
where (user_name REGEXP '\\.nl$'
	  or user_name REGEXP '\\.com$'
      or user_name REGEXP '\\.org$'
      or user_name REGEXP '\\.be$'
      or user_name REGEXP '\\.uk$'
      or user_name REGEXP '\\.gov$'
      or user_name REGEXP '\\.org$'
      or user_name REGEXP '\\.edu$'
      or user_name REGEXP '\\.de$'
      or user_name REGEXP '\\.fr$'
      or user_name REGEXP '\\.nu$'
      or user_name REGEXP '\\.tk$'
      or user_name REGEXP '\\.es$'
      or user_name REGEXP '\\.pt$'
      or user_name REGEXP '\\.it$'
      or user_name REGEXP '\\.pl$')
	AND NOT EXISTS (
  				SELECT ipb_address
  				FROM ipblocks
  				WHERE user_name=ipb_address
  				)	
GROUP BY showname
Limit 1000;
SQL

Checking query status...
