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 

LOWER(DisplayName) LIKE '%pony%' OR 
LOWER(DisplayName) LIKE '%ponies%' OR 
LOWER(DisplayName) LIKE '%pone%' OR 

/* 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 */ 

-- Princesses 
LOWER(DisplayName) LIKE '%celestia%' OR
-- LOWER(DisplayName) LIKE '%luna%' OR
LOWER(DisplayName) LIKE '%cadence%' OR
LOWER(DisplayName) LIKE '%cadance%' OR

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

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

Enter Parameters

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