Top Users

0

Please login or register to vote for this query.

(click on this box to dismiss)

Physical Fitness Meta

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

SELECT
    TOP (15)
    ROW_NUMBER() OVER(ORDER BY Reputation DESC) AS [#], 
    Id AS [User Link], 
    Reputation,
    Location,
    CONVERT(VARCHAR(10), CreationDate, 101) AS [First],
    CONVERT(VARCHAR(10), LastAccessDate, 101) AS [Last]
FROM
    Users
WHERE    
    LOWER(REPLACE(Location, ' ', '')) LIKE '%bocaraton%'
    OR LOWER(REPLACE(Location, ' ', '')) LIKE '%boyntonbeach%'
    OR LOWER(REPLACE(Location, ' ', '')) LIKE '%delraybeach%'
    OR LOWER(REPLACE(Location, ' ', '')) LIKE '%deerfieldbeach%'
    OR LOWER(REPLACE(Location, ' ', '')) LIKE '%coconutcreek%'
    OR LOWER(REPLACE(Location, ' ', '')) LIKE '%coralsprings%'
    OR LOWER(REPLACE(Location, ' ', '')) LIKE '%margate%'
    OR LOWER(REPLACE(Location, ' ', '')) LIKE '%pompanobeach%'
ORDER BY
    Reputation DESC,
    CreationDate DESC,
    LastAccessDate DESC;

Enter Parameters

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