Redirects to category בוט_חוקים

SQL

use hewikisource_p;

/*
select p1.page_id as id, p1.page_title as title from page p1
left join redirect rd on rd.rd_from = p1.page_id and rd.rd_namespace = 0
join page p2 on rd.rd_title = p2.page_title
join categorylinks cat on cat.cl_from = p2.page_id where cat.cl_to="בוט_חוקים"

*/

select p1.page_id as id, p1.page_title as title from page p1
left join (
  redirect rd on rd.rd_from = p1.page_id and rd.rd_namespace = 0
	join page p2 on p2.page_title = rd.rd_title
  union
  join page p2 on p2.page_id = p1.page_id
)
join categorylinks cat on cat.cl_from = p2.page_id where cat.cl_to="בוט_חוקים"

order by p2.page_title, p1.page_title
limit 100
SQL

Checking query status...
