Untitled query #30265

SQL

USE trwiki_p;
SELECT LEFT(rev_timestamp, 6) AS month, COUNT(*) AS number
FROM revision, page
WHERE rev_timestamp > 20160000000000
AND page_id = rev_page
AND page_namespace = 0
AND (
  rev_comment LIKE "% tarafından yapılan değişiklikler geri alınarak%"
  OR (
    rev_comment LIKE "%sayılı değişiklik geri alınıyor%"
    AND rev_comment LIKE "% Gerekçe: %"
  )
  OR (rev_comment LIKE "Revert%" AND rev_comment LIKE "%TW%")
)
GROUP BY LEFT(rev_timestamp, 6) ORDER BY month DESC;

SELECT LEFT(rev_timestamp, 4) AS year, COUNT(*) AS number
FROM revision, page
WHERE page_id = rev_page
AND page_namespace = 0
AND (
  rev_comment LIKE "% tarafından yapılan değişiklikler geri alınarak%"
  OR (
    rev_comment LIKE "%sayılı değişiklik geri alınıyor%"
    AND rev_comment LIKE "% Gerekçe: %"
  )
  OR (rev_comment LIKE "Revert%" AND rev_comment LIKE "%TW%")
)
GROUP BY LEFT(rev_timestamp, 4) ORDER BY year DESC;
SQL

Checking query status...
