search in subcategories (deph=6)

SQL

use hewiki_p;
select page_title from categorylinks inner join page on page_id = cl_from
where (
  (cl_to = 'רבנים'
  OR
  cl_to IN (select page_title from page inner join categorylinks on cl_from = page_id where cl_to = 'רבנים' and cl_type = 'subcat' )
  OR
  cl_to IN (select page_title from page inner join categorylinks on cl_from = page_id where cl_to in (select page_title from page inner join categorylinks on cl_from = page_id where cl_to = 'רבנים' and cl_type = 'subcat' ) and cl_type = 'subcat' )
  )
  and namespace=0
)

SQL

Checking query status...