Python Devs Hungary

0

Please login or register to vote for this query.

(click on this box to dismiss)

Gardening and Landscaping

Q&A for gardeners and landscapers

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', 'ipython', 'boost-python', 'cpython', 'ipython-notebook', 'mysql-python', 'ironpython', 'python-2.7', 'python-2.6', 'python-2.x', 'python-3.4', 'python-3.5', 'python-3.6', 'python-3.x', 'python-asyncio', 'python-datetime', 'python-decorators', 'python-docx', 'python-3.3', 'python-idle', 'python-import', 'python-imaging-library', 'python-module', 'python-multiprocessing', 'python-multithreading', 'python-sphinx', 'python-requests', 'python-unicode', 'pythonanywhere', 'python-xarray', 'python-internals', 'python-mock', 'wxpython') AND
                          Class IN (1, 2, 3) AND
                          TagBased = 1
                  ) tag_badges
             ON tag_badges.UserId = u.Id
             
             WHERE LOWER(Location) LIKE '%budapest%' OR
                            LOWER(Location) LIKE '%dunaharaszti%' OR
                            LOWER(Location) LIKE '%gyal%' OR
                            LOWER(Location) LIKE '%nyirmartonfalva%' OR
                            LOWER(Location) LIKE '%csorvas%' OR
                            LOWER(Location) LIKE '%esztergom%' OR
                            LOWER(Location) LIKE '%kunhegyes%' OR
                            LOWER(Location) LIKE '%alsopahok%' OR
                            LOWER(Location) LIKE '%sarmellek%' OR
                            LOWER(Location) LIKE '%edeleny%' OR
                            LOWER(Location) LIKE '%balatonfured%' OR
                            LOWER(Location) LIKE '%koszeg%' OR
                            LOWER(Location) LIKE '%szombathely%' OR
                            LOWER(Location) LIKE '%tiszafured%' OR
                            LOWER(Location) LIKE '%ullo%' OR
                            LOWER(Location) LIKE '%ã‰rd%' OR
                            LOWER(Location) LIKE '%gyula%' OR
                            LOWER(Location) LIKE '%kistelek%' OR
                            LOWER(Location) LIKE '%sarszentmihaly%' OR
                            LOWER(Location) LIKE '%szeged%' OR
                            LOWER(Location) LIKE '%rakocziujfalu%' OR
                            LOWER(Location) LIKE '%kiskunfelegyhaza%' OR
                            LOWER(Location) LIKE '%ajak%' OR
                            LOWER(Location) LIKE '%kecskemã©t%' OR
                            LOWER(Location) LIKE '%ujszilvas%' OR
                            LOWER(Location) LIKE '%pã©cs%' OR
                            LOWER(Location) LIKE '%hegyhatmaroc%' OR
                            LOWER(Location) LIKE '%debrecen%' OR
                            LOWER(Location) LIKE '%mako%' OR
                            LOWER(Location) LIKE '%szolnok%' OR
                            LOWER(Location) LIKE '%apatfalva%' OR
                            LOWER(Location) LIKE '%bã©kã©scsaba%' OR
                            LOWER(Location) LIKE '%klarafalva%' OR
                            LOWER(Location) LIKE '%tiszaujvaros%' OR
                            LOWER(Location) LIKE '%keszu%' OR
                            LOWER(Location) LIKE '%tata%' OR
                            LOWER(Location) LIKE '%kerekegyhaza%' OR
                            LOWER(Location) LIKE '%miskolc%' OR
                            LOWER(Location) LIKE '%kunszentmarton%' OR
                            LOWER(Location) LIKE '%kisujszallas%' OR
                            LOWER(Location) LIKE '%solymar%' OR
                            LOWER(Location) LIKE '%piliscsaba%' OR
                            LOWER(Location) LIKE '%god%' OR
                            LOWER(Location) LIKE '%visegrã¡d%' OR
                            LOWER(Location) LIKE '%budakalasz%' OR
                            LOWER(Location) LIKE '%nagykoros%' OR
                            LOWER(Location) LIKE '%salfold%' OR
                            LOWER(Location) LIKE '%pest%' OR
                            LOWER(Location) LIKE '%hungary%' OR
                            LOWER(Location) LIKE '%budajeno%' OR
                            LOWER(Location) LIKE '%kapuvar%' OR
                            LOWER(Location) LIKE '%karcag%' OR
                            LOWER(Location) LIKE '%szabadbattyan%' OR
                            LOWER(Location) LIKE '%komlo%' OR
                            LOWER(Location) LIKE '%nagynyarad%' OR
                            LOWER(Location) LIKE '%beled%' OR
                            LOWER(Location) LIKE '%szerencs%' OR
                            LOWER(Location) LIKE '%szã©kesfehã©rvã¡r%' OR
                            LOWER(Location) LIKE '%tiszalok%' OR
                            LOWER(Location) LIKE '%szemely%' OR
                            LOWER(Location) LIKE '%gyå‘r%' OR
                            LOWER(Location) LIKE '%kisgyor%' OR
                            LOWER(Location) LIKE '%kismaros%' OR
                            LOWER(Location) LIKE '%totkomlos%' OR
                            LOWER(Location) LIKE '%medgyesegyhaza%' OR
                            LOWER(Location) LIKE '%mateszalka%' OR
                            LOWER(Location) LIKE '%veresegyhaz%' OR
                            LOWER(Location) LIKE '%hodmezovasarhely%' OR
                            LOWER(Location) LIKE '%szajk%'

Enter Parameters

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