1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for science fiction and fantasy enthusiasts

SELECT

    ROW_NUMBER() OVER (ORDER BY Reputation DESC) AS 'ID', 
    --Id [User Link], 
    DisplayName AS 'Name',
    Reputation AS 'Rep',
    UpVotes AS 'Up',
    DownVotes AS 'Down',
    Views AS 'Views',
    CreationDate AS 'Since',
    LastAccessDate AS 'Last Seen',
    Location AS 'Location',
    Id AS 'SO ID',
    AccountId AS 'SE ID'

FROM Users

WHERE LOWER(Location) LIKE '%croatia%' 
OR LOWER(Location) LIKE '%hrvatska%'

ORDER by Reputation DESC, LastAccessDate DESC, CreationDate DESC

fork query

edited feb 27

created feb 24 VBasic2008