Fork of مقالاتی که دو ردهٔ درگذشتگان میلادی دارند by Yamaha5
This query is marked as a draft This query has been published by Yamaha5.

SQL

AخA
 
USE fawiki_p;
SELECT DISTINCT page_title, frst.cl_to
FROM categorylinks AS frst INNER JOIN page ON frst.cl_from=page_id and page_namespace=0
WHERE frst.cl_to LIKE 'درگذشتگان%'
AND frst.cl_to NOT LIKE '%قمری%'
AND frst.cl_to not LIKE '%میلادی%'
AND frst.cl_to NOT LIKE '%درگذشتگان_سده%'
AND frst.cl_to NOT LIKE '%_به_علت_%'
AND frst.cl_to NOT LIKE '%_بر_%'
AND frst.cl_to NOT LIKE '%_با_%'
AND frst.cl_to NOT LIKE '%_در_%'
AND frst.cl_to NOT LIKE '%_سوانح_%'
  AND frst.cl_to NOT LIKE '%حا_%'
AND frst.cl_to REGEXP '[۰۱۲۳۴۵۶۷۸۹]+'
AND frst.cl_from IN (
  SELECT cl_from
  FROM categorylinks AS scnd
  WHERE scnd.cl_to LIKE 'درگذشتگان%'
  AND scnd.cl_to NOT LIKE '%قمری%'
  AND scnd.cl_to not LIKE '%میلادی%'
AND scnd.cl_to NOT LIKE '%درگذشتگان_سده%'
AND scnd.cl_to NOT LIKE '%_به_علت_%'
AND scnd.cl_to NOT LIKE '%_بر_%'
AND scnd.cl_to NOT LIKE '%_با_%'
AND scnd.cl_to NOT LIKE '%_در_%'
AND scnd.cl_to NOT LIKE '%_سوانح_%'
  AND scnd.cl_to NOT LIKE '%حا_%'
  AND scnd.cl_to REGEXP '[۰۱۲۳۴۵۶۷۸۹]+'
  AND frst.cl_to <>scnd.cl_to
) order by 1
;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
Submit Query
All SQL code is licensed under CC0 License.

Checking query status...