python

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow Meta en español

Preguntas y respuestas sobre el sitio para programadores y profesionales de la informática

SELECT u.Id AS [User Link],
                            CONCAT('https://stackoverflow.com/users/', u.Id) AS [Profile Link],
                            u.DisplayName,
                            u.Location,
                            u.WebsiteUrl,
                            u.AboutMe,
                            u.Views,
                            u.UpVotes,
                            u.DownVotes
             FROM Users u
        
             JOIN (
                    SELECT DISTINCT UserId
                    FROM Badges
                    WHERE LOWER(Name) IN ('python') AND
                          Class IN (1, 2, 3) AND
                          TagBased = 1
                  ) tag_badges
             ON tag_badges.UserId = u.Id
             
             WHERE LOWER(Location) LIKE '%iași%' OR
                            LOWER(Location) LIKE '%deva%' OR
                            LOWER(Location) LIKE '%arad%' OR
                            LOWER(Location) LIKE '%constanța%' OR
                            LOWER(Location) LIKE '%sibiu%' OR
                            LOWER(Location) LIKE '%tã¢rgu mureåÿ%' OR
                            LOWER(Location) LIKE '%cluj-napoca%' OR
                            LOWER(Location) LIKE '%alba iulia%' OR
                            LOWER(Location) LIKE '%rã¢mnicu vã¢lcea%' OR
                            LOWER(Location) LIKE '%navodari%' OR
                            LOWER(Location) LIKE '%tulcea%' OR
                            LOWER(Location) LIKE '%galaè›i%' OR
                            LOWER(Location) LIKE '%roman%' OR
                            LOWER(Location) LIKE '%piteåÿti%' OR
                            LOWER(Location) LIKE '%bucharest%' OR
                            LOWER(Location) LIKE '%bacău%' OR
                            LOWER(Location) LIKE '%oneåÿti%' OR
                            LOWER(Location) LIKE '%piatra neamå£%' OR
                            LOWER(Location) LIKE '%cernavodäƒ%' OR
                            LOWER(Location) LIKE '%calarasi%' OR
                            LOWER(Location) LIKE '%mediaåÿ%' OR
                            LOWER(Location) LIKE '%petresti%' OR
                            LOWER(Location) LIKE '%botoåÿani%' OR
                            LOWER(Location) LIKE '%craiova%' OR
                            LOWER(Location) LIKE '%buzäƒu%' OR
                            LOWER(Location) LIKE '%pantelimon%' OR
                            LOWER(Location) LIKE '%cuza voda%' OR
                            LOWER(Location) LIKE '%mihai bravu%' OR
                            LOWER(Location) LIKE '%santimbru%' OR
                            LOWER(Location) LIKE '%brașov%' OR
                            LOWER(Location) LIKE '%timișoara%' OR
                            LOWER(Location) LIKE '%targu gangulesti%' OR
                            LOWER(Location) LIKE '%suceava%' OR
                            LOWER(Location) LIKE '%motru%' OR
                            LOWER(Location) LIKE '%teiu%' OR
                            LOWER(Location) LIKE '%giurgiu%' OR
                            LOWER(Location) LIKE '%voronet%' OR
                            LOWER(Location) LIKE '%filipestii de padure%' OR
                            LOWER(Location) LIKE '%borca%' OR
                            LOWER(Location) LIKE '%cetatea de balta%' OR
                            LOWER(Location) LIKE '%alexandria%' OR
                            LOWER(Location) LIKE '%cetatuia%' OR
                            LOWER(Location) LIKE '%cernisoara%' OR
                            LOWER(Location) LIKE '%berzasca%' OR
                            LOWER(Location) LIKE '%miercurea-ciuc%' OR
                            LOWER(Location) LIKE '%miercurea sibiului%' OR
                            LOWER(Location) LIKE '%panciu%' OR
                            LOWER(Location) LIKE '%seini%' OR
                            LOWER(Location) LIKE '%corbeanca%' OR
                            LOWER(Location) LIKE '%urziceni%' OR
                            LOWER(Location) LIKE '%racoasa%' OR
                            LOWER(Location) LIKE '%hunedoara%' OR
                            LOWER(Location) LIKE '%bucu%' OR
                            LOWER(Location) LIKE '%chiajna%' OR
                            LOWER(Location) LIKE '%ramnicu sarat%' OR
                            LOWER(Location) LIKE '%floresti%' OR
                            LOWER(Location) LIKE '%tã¢rgoviåÿte%'

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results