Untitled query #19914

SQL

use commonswiki_p;
select log_title from logging where log_type="upload" and log_action="upload"
and log_title in (select page_title from categorylinks join page on page_id=cl_from where cl_to="Uploaded_with_Mobile/Android")
and (log_timestamp like "201607%"
or log_timestamp like "201608%"
or log_timestamp like "201609%"
or log_timestamp like "201610%"
or log_timestamp like "201611%"
or log_timestamp like "201612%"
or log_timestamp like "201701%"
or log_timestamp like "201702%"
or log_timestamp like "201703%"
or log_timestamp like "201704%"
or log_timestamp like "201705%"
or log_timestamp like "201706%");
SQL

Checking query status...
