Q&A about the site for enthusiasts and scholars of mythology and folklore
SELECT ROW_NUMBER() OVER (ORDER BY Reputation DESC) AS Ind, * FROM Users WHERE LOWER(Location) LIKE LOWER(('%##Location##%')) AND LOWER(AboutMe) LIKE LOWER(('%##content##%')) ORDER BY Reputation, Id DESC