nlwiki External links that contain an asterisk in the host part

SQL

SELECT page_namespace AS ns, page_title, el_to FROM externallinks, page WHERE
  el_from=page_id AND el_to REGEXP
'(s-e-x)|(zoofilia)|(grusskarte)|(sex(cam|chat|-with|-plugin|-zone))|(adult(?:c'
'hat|live|porn|web\.))|((?:animal|cam|chat|hardcore|live|online|voyeur)sex)|(('
'?:hardcore|teen|xxx)porn)|(lesbiansex\.)|((?:live|cam)girl)|(spycam)|(casino-'
'online)|(online-casino)|(cheap(?:-airfares|coach|est-phone|ghd|holidayaccommo'
'dation|jerseys|sneaker|-xanax))|(nfl(teams)?-?jerseysales?\.com\b)|(\bjerseys'
'\.(?:com|us|org|net)\b)|(\b(?:mlb|nba|nfl|nhl|hot)jersey(\d{3,4})?\.(?:com|us'
'|org|net)\b)|((?:fancy|open|reebok|wholesale|two|whole|china|ebuy|you|\band|b'
'2b|20|affordable|shopping|fans|wonderful|c2c|footballworldcup|superbowl)-?jer'
'seys?\.(?:com|us|org|net)\b)|(jerseys?(mvp|-)?(nba|shops?|goods|whole|wholesa'
'le|soho|release|zones|sale|com|pick|cn|export|supply|trade|site|warehouse|sto'
'p|faves|4u|kk|cc|ab|outlets?|clubhouse|only|buy|planet|911)\.(?:com|us|org|ne'
't)\b)|(\b(?:\d{2,4})?(mlb|nba|nfl|nhl|hot)-?jersey)|(fuelcellmarket)|(paris-h'
'ilton)|(-horoskop)|(viagra(?!nde\.ct\.it\b))|(\bstatic\.net)|(\.hkce\.(?:org|'
'net))';
SQL

Checking query status...
