Temporary sandbox

Fork of Ruwiki IWRM.js usage → wikitable by A particle for world to form

This query is marked as a draft This query has been published by Wikisaurus.

SQL

USE ruwiki_p;
SELECT
  page_title
FROM page
JOIN categorylinks ON cl_from = page_id
JOIN revision AS our_rev ON rev_page = page_id
WHERE
  page_namespace = 0
  AND cl_to = "Статьи_с_универсальной_карточкой,_которая_предположительно_неуместна"
  AND our_rev.rev_timestamp >= "201810"
  AND (our_rev.rev_user_text = "Jet Jerry"
       OR our_rev.rev_user_text = "Svetlov Artem"
       OR our_rev.rev_user_text = "Den1980-")
  AND EXISTS (
    SELECT rev_len
    FROM revision AS parent_rev
    WHERE
      parent_rev.rev_id = our_rev.rev_parent_id
      AND our_rev.rev_len - parent_rev.rev_len = 48
  )
LIMIT 100;

SQL

Checking query status...