Kategóriák - Quarry

SQL

USE huwiki_p;
select c2.page_title, c3.page_namespace, c3.page_title 
  from pagelinks c1 
  join page c2 on c1.pl_from = c2.page_id 
  join page c3 on c1.pl_namespace = c3.page_namespace and c1.pl_title = c3.page_title 
  join templatelinks c4 on c3.page_id = c4.tl_from 
 where c2.page_namespace   = 10 
   and c4.tl_namespace     = 10 
   and c4.tl_title         = 'Egyért'
union all 
select c2.page_title, c3.page_namespace, c3.page_title 
  from pagelinks c1 
  join page c2 on c1.pl_from = c2.page_id 
  join page c3 on c1.pl_namespace = c3.page_namespace and c1.pl_title = c3.page_title 
  join redirect c5 on c3.page_id = c5.rd_from 
  join page c6 on c5.rd_namespace = c6.page_namespace and c5.rd_title = c6.page_title 
  join templatelinks c4 on c6.page_id = c4.tl_from 
 where c2.page_namespace   = 10 
   and c4.tl_namespace     = 10 
   and c4.tl_title         = 'Egyért'
order by 1, 2, 3
SQL

Checking query status...
