How many ponies are there?

0

Please login or register to vote for this query.

(click on this box to dismiss)

Physical Fitness Meta

Q&A about the site for physical fitness professionals, athletes, trainers, and those providing health-related needs

SELECT Id AS [User Link], Reputation, CreationDate, Age 
FROM Users WHERE 
/* Mane 6 */
LOWER(DisplayName) LIKE '%fluttershy%' OR
LOWER(DisplayName) LIKE '%twilight%' OR
LOWER(DisplayName) LIKE '%sparkle%' OR
LOWER(DisplayName) LIKE '%rainbow dash%' OR
LOWER(DisplayName) LIKE '%applejack%' OR
LOWER(DisplayName) LIKE '%rarity%' OR
LOWER(DisplayName) LIKE '%pinkie%' OR 
/* Supporting characters */ 
LOWER(DisplayName) LIKE '%celestia%' OR
LOWER(DisplayName) LIKE '%luna%' OR
LOWER(DisplayName) LIKE '%cadence%' OR
LOWER(DisplayName) LIKE '%cadance%' OR

LOWER(DisplayName) LIKE '%applebloom%' OR
LOWER(DisplayName) LIKE '%apple bloom%' OR
LOWER(DisplayName) LIKE '%sweetie belle%' OR
LOWER(DisplayName) LIKE '%scootaloo%' OR

LOWER(DisplayName) LIKE '%discord%' OR
LOWER(DisplayName) LIKE '%derpy%' OR
LOWER(DisplayName) LIKE '%octavia%' OR
LOWER(DisplayName) LIKE '%lyra%' OR
LOWER(DisplayName) LIKE '%zecora%'

order by DisplayName

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results