Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Evrifaessa
.
Toggle Highlighting
SQL
USE trwiki_p; SELECT user_name FROM user AS U WHERE NOT EXISTS (SELECT * FROM ipblocks AS B WHERE U.user_id=B.ipb_user) AND U.user_name ~* "ultrabet|fitness|digital\b|marketing|mr?ktn?g|strategies|corporat(e|ion\b)|company|((co|pty|private|pvt)\.? ?(limited|ltd))\.?$|technolog(y|ies)|industr(y|ies)|(IT)? ?solutions?|laboratories|foundation|\bll(c|p)\.?$|\binc\.?$|\bplc\.?$|managing ?partner|productions?|(creative ?)?software|consult(an(t|cy)|ing)|developers|services?|creations?|apparels|automotive|infotech|enterprises?|holdings|publishings?|cater(ers?|ing)|media]\b|studios?\b|missions|foundation|recordings?|institutes?|university|college|school|district|administration|fashion|fabrics|clothing|gmbh|groups?|ministr(y|ies)|videography|informatics?|fellowship|church|subscribe ?(to])?|sub to|channel|entertainment|affordable|purchase|therapeutic(al|s)|medical|careers|distillery$|brewery|dot(com|net|org|gov)$|publications?|realty|service ?center|keto|\bdiet\b|india$|conference|publishers?|correspondence|propert(y|ies)|real ?estate|rental|time ?share|vacation|tours|interiors|projects?$|agenc(y|ies)|auto ?glass|auto ?repair|plumbing|treatment ?center|global\b|office(?!r)|relocation|financ(e|ial)|funding|hardware\b|graphic ?design\b|online ?store\b|\.tv$|medya"
By running queries you agree to the
Cloud Services Terms of Use
and you irrevocably agree to release your SQL under
CC0 License
.
Submit Query
Stop Query
All SQL code is licensed under
CC0 License
.
Checking query status...