Subquery and Join example

This query is marked as a draft This query has been published by Jtmorgan.

For Daisy!

SQL

SELECT                                                                                                                        
        user_id,
     	rev_id,
        page_namespace                                                                                               
    FROM u2041__thr_p.th2_experimental_user
    INNER JOIN enwiki_p.user USING (user_id)
    LEFT JOIN enwiki_p.revision_userindex ON                                                                                                          
        rev_user = user_id AND                                                                                                     
        rev_timestamp between DATE_FORMAT(user_registration,"%Y%m%d%H%i%S")
     	and DATE_FORMAT(invite_date,"%Y%m%d%H%i%S")                                                                                                       
    LEFT JOIN enwiki_p.page ON rev_page = page_id;

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...