Images uploaded from Commons mobile app (Android) between Jul 2016 and Jun 2017

SQL

use commonswiki_p;
select page_title, cl_timestamp from categorylinks join page on page_id=cl_from where cl_to="Uploaded_with_Mobile/Android" 

and (cl_timestamp like "2016-7%" or cl_timestamp like "2016-8%" or cl_timestamp like "2016-9%" or cl_timestamp like "2016-10%" or cl_timestamp like "2016-11%" or cl_timestamp like "2016-12%" or cl_timestamp like "2017-6%" or cl_timestamp like "2017-7%" or cl_timestamp like "2017-8%" or cl_timestamp like "2017-9%" or cl_timestamp like "2017-10%" or cl_timestamp like "2017-11%" or cl_timestamp like "2017-12%")

SQL

Checking query status...