Show all Casino* Accounts

This query is marked as a draft This query has been published by Luke081515.

Shows unlocked Casino accounts ordered by registration date

In general you can fork this query and replace the "AND gu_name like "Casino%"" line to search for acocunts with other prefixes.

SQL

USE centralauth_p;
SELECT gu_name as Username, 
gu_registration AS regdate 
FROM globaluser 
WHERE gu_locked = 0 
AND gu_name like "Casino%" 
ORDER BY gu_registration;

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.

SQL

Checking query status...