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.