Untitled query #43038

SQL

use arwiki_p;
select ar_p.page_title
from page ar_p, templatelinks as atemp , categorylinks
where atemp.tl_from = ar_p.page_id
and atemp.tl_title in ("بذرة")
AND atemp.tl_namespace = 10
and ar_p.page_is_redirect = 0
and ar_p.page_namespace = 0

and ar_p.page_id in ( select cc.cl_from categorylinks as ff where ff.cl_to = "مقالات_بذور_عامة" )

and ar_p.page_id not in ( select ttt.tl_from from templatelinks as ttt where ttt.tl_title = "بذرة_برنامج_تلفزيوني" AND ttt.tl_namespace = 10 )
and ar_p.page_id = cl_from

#fgh
  and (
 cl_to = "برامج_تلفزيونية" or cl_to like "برامج_تلفزيونية%"
   )

#nnn
group by ar_p.page_title
SQL

Checking query status...
