Untitled query #76486

SQL

/*
select cl_from from categorylinks
where cl_type like "page"
and cl_to like "جميع_صفحات_التوضيح"
limit 10;
*/
/*
select count(distinct(pl_from)) from pagelinks
where pl_namespace = 0
and pl_from_namespace = 0 
and pl_from not in (
	select cl_from from categorylinks
    where cl_type like "page"
    and cl_to like "جميع_صفحات_التوضيح"
)
and pl_title like "%توضيح%"
*/

select concat("[[:",page_title,"]]") as "page_title",pl_title as "to" from pagelinks
inner join page on page.page_id = pagelinks.pl_from 
where pl_namespace = 0
and pl_from_namespace = 0 
and pl_from not in (
	select cl_from from categorylinks
    where cl_type like "page"
    and cl_to like "جميع_صفحات_التوضيح"
)
and pl_title like "%توضيح%"
limit 1000
SQL

Checking query status...
