Test

0

Please login or register to vote for this query.

(click on this box to dismiss)

Moderators

Q&A for community managers, administrators, and moderators

SELECT  distinct u.id, t.tagname
         FROM   posts p 
           
                INNER JOIN posttags pt 
                on pt.postid = p.parentid
                
                INNER JOIN users u
                on p.owneruserid = u.id
                
                INNER JOIN Tags t
                on t.id = pt.tagid 
                  
         WHERE  p.posttypeid = 2
                and (t.tagname = 'android' or 
                     t.tagname = 'css' or
                     t.tagname = 'javascript' or
                     t.tagname = 'mysql' or
                     t.tagname = 'python' or
                     t.tagname = 'java' or
                     t.tagname = 'html5' or
                     t.tagname = 'linux' or
                     t.tagname = 'jquery')
                     
                and u.reputation > 15 -- leaves us with the top quartile of the site
                and u.age > 18
                
/* be careful with tag names - all lower case lookup in Tags table */

Enter Parameters

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