غير مبوبة

SQL

use arwiki_p;

select 
#count(
  page.page_title, page.tl_title
#)
from page 
where page_namespace = 0 
and page_title like '%(%)%'
and page_id not in (select tl_from from templatelinks  where tl_title = 'شريط_بوابات') 
and page_id not in (select cl_from from categorylinks  where cl_to ='صفحات_توضيح') 
and page_id not IN (SELECT tl_from FROM templatelinks WHERE tl_title = "أسمياء" AND tl_namespace = 10 )
and page_id IN (SELECT tl_from FROM templatelinks WHERE tl_title like "بذرة%" AND tl_namespace = 10 )

      #and (page.page_title  like "%(ألبوم)" or page.page_title  like "%(مسلسل)" )
and page_is_redirect = 0 
order by rand()
;
SQL

Checking query status...
