Q&A about the site for mechanics and DIY enthusiast owners of cars, trucks, and motorcycles
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