Fork of Pages contains red categories. by ASammour
This query is marked as a draft This query has been published by ASammour.

SQL

AخA
 
use arwiki_p;
SELECT
  page_title, group_concat(pl_title, "****")
FROM page
inner join
pagelinks
on pl_from = page_id
where page_is_redirect = 0
and page_namespace = 0
and pl_title not in (select page_title from page 
                     where
                     page_namespace = 10 
                     and pl_title = page_title
                    )
and pl_from_namespace = 0
and pl_namespace = 10
and page_id not in (select fpp_page_id from flaggedpage_pending where page_id = fpp_page_id)
and pl_title not like "%بذرة%"
and (select rev_timestamp from revision where rev_page = page_id order by rev_timestamp desc limit 1) > DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 50 DAY) 
and pl_title not in (select pl_title 
                    from pagelinks 
                    where pl_from_namespace = 10
                    and pl_namespace =10
                    )
group by page_title
limit 100;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.

Checking query status...