node

0

Please login or register to vote for this query.

(click on this box to dismiss)

Signal Processing

Q&A for practitioners of the art and science of signal, image and video processing

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 ('node', 'node.js', 'node-red', 'node-mongodb-native', 'nodatime', 'nodemcu') AND
                          Class IN (1, 2, 3) AND
                          TagBased = 1
                  ) tag_badges
             ON tag_badges.UserId = u.Id
             
             WHERE LOWER(Location) LIKE '%minsk%' OR
                            LOWER(Location) LIKE '%mogilev%' OR
                            LOWER(Location) LIKE '%brest%' OR
                            LOWER(Location) LIKE '%vitebsk%' OR
                            LOWER(Location) LIKE '%dvor-gomel''%' OR
                            LOWER(Location) LIKE '%hrodna%' OR
                            LOWER(Location) LIKE '%navapolatsk%' OR
                            LOWER(Location) LIKE '%lida%' OR
                            LOWER(Location) LIKE '%horki%' OR
                            LOWER(Location) LIKE '%borisov%' OR
                            LOWER(Location) LIKE '%lyakhovichi%' OR
                            LOWER(Location) LIKE '%radoshkovichi%' OR
                            LOWER(Location) LIKE '%polatsk%' OR
                            LOWER(Location) LIKE '%orsha%' OR
                            LOWER(Location) LIKE '%valer''yanovo%' OR
                            LOWER(Location) LIKE '%baranovichi%' OR
                            LOWER(Location) LIKE '%mazyr%' OR
                            LOWER(Location) LIKE '%lyaskavichy%' OR
                            LOWER(Location) LIKE '%zhodzina%' OR
                            LOWER(Location) LIKE '%zaslawye%' OR
                            LOWER(Location) LIKE '%lahoysk%' OR
                            LOWER(Location) LIKE '%shklow%' OR
                            LOWER(Location) LIKE '%mozyr''%' OR
                            LOWER(Location) LIKE '%dzyarzhynsk%' OR
                            LOWER(Location) LIKE '%pinsk%'

Enter Parameters

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