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

SQL

use hewikisource_p;

select p.page_id as id, p.page_title as title, rd.rd_from from page p
join categorylinks cat on cat.cl_from = p.page_id where cat.cl_to="בוט_חוקים"
order by title
left join redirects rd on rd.rd_title = title
/*
-- select page_title from page
-- join categorylinks on cl_from = page_id where cl_to = "בוט_חוקים"

-- select rd.page_title from redirects 


select
  p1.page_namespace,
  p1.page_title
from redirect as rd
join page p1
on rd.rd_from = p1.page_id
left join page as p2
ON rd_namespace = p2.page_namespace
AND rd_title = p2.page_title
WHERE rd_namespace >= 0
AND p2.page_namespace IS NULL
ORDER BY p1.page_namespace ASC;
*/

limit 10;
SQL

Checking query status...
