Kotlin

0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for mechanics and DIY enthusiast owners of cars, trucks, and motorcycles

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 ('android', 'kotlin') AND
                          Class IN (1, 2, 3) AND
                          TagBased = 1
                  ) tag_badges
             ON tag_badges.UserId = u.Id
             
             WHERE LOWER(Location) LIKE '%melbourne%' OR
                            LOWER(Location) LIKE '%port melbourne%' OR
                            LOWER(Location) LIKE '%south melbourne%' OR
                            LOWER(Location) LIKE '%north melbourne%'

Enter Parameters

Options:
Switch to main site
Hold tight while we fetch your results
{"cc_re__cc_re__cc_by_sa_4_0": ["/a>\r\n                <a href=\"https://data.stackexchange.com\">data</a>\r\n                <a href=\"https://stackexchange.com/legal\">legal</a>\r\n                <strong><a href=\"https://meta.stackexchange.com/contact\">contact us</a></strong>\r\n                <strong><a href=\"https://meta.stackexchange.com\">feedback</a></strong>\r\n            </div>\r\n            <div id=\"copyright\">\r\n                site design / logo &copy; 2021 Stack Exchange Inc; \r\n                user contributions licensed under <a href=\"https://creativecommons.org/licenses/by-sa/4.0/\" rel=\"license\">cc by-sa</a>; see the <a href=\"https://stackoverflow.com/help/licensing\">licensing help page</a> for more info\r\n            </div>\r\n            <div id=\"revision\">rev 2021.6.16.81</div>\r\n        </div>\r\n    </div>\r\n    <noscript>\r\n        <div id=\"noscript-warning\">\r\n            Data Explorer works best with JavaScript enabled</div>\r\n    </noscript>\r\n    <script>\r\n(function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){\r\n(i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date("], "copyright__copyright__copyright": ["ss IN (1, 2, 3) AND\n                          TagBased = 1\n                  ) tag_badges\n             ON tag_badges.UserId = u.Id\n             \n             WHERE LOWER(Location) LIKE '%melbourne%' OR\n                            LOWER(Location) LIKE '%port melbourne%' OR\n                            LOWER(Location) LIKE '%south melbourne%' OR\n                            LOWER(Location) LIKE '%north melbourne%'\n\nEnter Parameters\n\nOptions:\nSwitch to main site\nHold tight while we fetch your results"]}