Untitled query #72639

SQL

select count(distinct pagelinks.pl_title) as "count_of_pages",page.page_title, pl_from from pagelinks
inner join page on page.page_id = pagelinks.pl_from
where pl_from_namespace in (0) and pl_namespace in (0) and page.page_is_redirect = 0
and page_id not in (select cl_from from categorylinks where cl_to like "%جميع_المقالات_التي_بها_وصلات_داخلية_قليلة%" and cl_from = page_id)
and page_id not in (select cl_from from categorylinks where cl_to like "%صفحات_توضيح%" and cl_from = page_id)
and page_id not in (select cl_from from categorylinks where cl_to like "%جميع_مقالات_المجموعات_المفهرسة%" and cl_from = page_id)
group by pl_from
HAVING count_of_pages > 3
SQL

Checking query status...
