0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for members of the workforce navigating the professional setting

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', 'android-2.2-froyo', 'android-3.0-honeycomb', 'android-4.0', 'android-4.2-jelly-bean', 'android-4.4-kitkat', 'android-5.0-lollipop', 'android-6.0-marshmallow', 'android-actionbar', 'android-7.0-nougat', 'android-adapter', 'android-alertdialog', 'android-animation', 'android-annotations', 'android-alarms', 'android-camera-intent', 'android-broadcastreceiver', 'android-billing', 'android-arrayadapter', 'android-appwidget', 'android-assets', 'android-camera', 'android-camera2', 'android-canvas', 'android-cardview', 'android-constraintlayout', 'android-contentresolver', 'android-contentprovider', 'android-context', 'android-databinding', 'android-design-library', 'android-dialogfragment', 'android-emulator', 'android-edittext', 'android-drawable', 'android-broadcast', 'android-espresso', 'android-file', 'android-fileprovider', 'android-fragmentactivity', 'android-fragments', 'android-glide', 'android-gradle', 'android-ibeacon', 'android-intent', 'android-intentservice', 'android-layout', 'android-library', 'android-lifecycle', 'android-linearlayout', 'android-listfragment', 'android-listview', 'android-loadermanager', 'android-manifest', 'android-maps', 'android-maps-v2', 'android-mapview', 'android-menu', 'android-ndk', 'android-notifications', 'android-pendingintent', 'android-permissions', 'android-preferences', 'android-resources', 'android-sdcard', 'android-service', 'android-source', 'android-spinner', 'android-sqlite', 'android-studio', 'android-support-library', 'android-syncadapter', 'android-tabhost', 'android-textview', 'android-theme', 'android-toolbar', 'android-ui', 'android-vectordrawable', 'android-view', 'android-viewpager', 'android-volley', 'android-wear', 'android-webview', 'android-widget', 'android-xml', 'androidplot', 'facebook-android-sdk', 'google-drive-android-api', 'google-maps-android-api-2', 'ibeacon-android', 'mpandroidchart', 'rx-android', 'xamarin.android', 'android-asynctask', 'android-bluetooth', 'android-activity') AND
                          Class IN (1, 2, 3) AND
                          TagBased = 1
                  ) tag_badges
             ON tag_badges.UserId = u.Id
             
             WHERE LOWER(Location) LIKE '%pittsburgh%' OR
                            LOWER(Location) LIKE '%boston%' OR
                            LOWER(Location) LIKE '%philadelphia%' OR
                            LOWER(Location) LIKE '%austin%' OR
                            LOWER(Location) LIKE '%new york%'

fork query

edited oct 21 19

created oct 10 19 anonymous