Untitled query #27068

SQL

USE commonswiki_p;
SELECT user_name, user_editcount, f.page_title FROM user
JOIN logging ON user_id = log_user
JOIN change_tag ON ct_log_id = log_id
JOIN page AS f ON log_page = f.page_id
WHERE log_type = "upload" AND (log_action = "upload" OR log_action = "overwrite")
#AND EXISTS(SELECT * FROM categorylinks JOIN page AS c ON cl_from = log_page WHERE c.page_namespace = 14 AND c.page_title = "Uploaded_with_Mobile/Android")
LIMIT 100;

SELECT * FROM categorylinks JOIN page AS c ON cl_from = 55001577 WHERE c.page_namespace = 14 AND c.page_title = "Uploaded_with_Mobile/Android";
SQL

Checking query status...
