https://bugzilla.wikimedia.org/show_bug.cgi?id=62598
--- Comment #140 from Ryan Kaldari <rkald...@wikimedia.org> --- SQL queries used... Images deleted: SELECT EXTRACT(YEAR_MONTH FROM log_timestamp) AS month, count(*) AS count FROM logging INNER JOIN tag_summary ON log_id = ts_log_id WHERE tag_summary.ts_tags LIKE 'mobile edit%' AND log_action = 'upload' AND NOT EXISTS ( SELECT img_name FROM image WHERE log_title=img_name ) GROUP BY month; Images uploaded: SELECT EXTRACT(YEAR_MONTH FROM log_timestamp) AS month, count(*) AS count FROM logging INNER JOIN tag_summary ON log_id = ts_log_id WHERE tag_summary.ts_tags LIKE 'mobile edit%' AND log_action = 'upload' GROUP BY month; -- You are receiving this mail because: You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l