Untitled query #76689

SQL

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;
SQL

Checking query status...
