جستجو بر اساس رده و زیررده

SQL

use fawiki_p;

with recursive subcategories as (
    select cl_from, cl_to
    from categorylinks
    where cl_to = 'شهرهای_شهرستان_کالین،_تگزاس'

    union all

    select cl2.cl_from, cl2.cl_to
    from categorylinks cl2
    inner join subcategories sc on cl2.cl_to = sc.cl_to
)
select page_title
from page
left join redirect
on rd_from = page_id
inner join categorylinks cl
on page_id = cl.cl_from
inner join subcategories sc
on cl.cl_to = sc.cl_to
where page_namespace = 0
and rd_from is Null
and page_title like '%،%' 
and not (
  page_title like '%،%،%'
  or page_title like '%،%(%'
  or page_title like '%(%،%'
);

SQL

Checking query status...