Replicas browser and optimizer
This query is marked as a draft
This query has been published
use hewikisource_p; select title as page_title, base_title from ( select 1 as type, p2.page_id as base_id, p.page_id as sub_id, p.page_id as id, p2.page_title as base_title, p.page_title as title from page p -- where p.page_title not like N'%־%' left join redirect rd on rd.rd_from = p.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="בוט_חוקים" union select 0 as type, p.page_id as id, 0 as sub_id, p.page_id as base_id, p.page_title as title, p.page_title as base_title from page p join categorylinks cat on cat.cl_from = p.page_id where cat.cl_to="בוט_חוקים" order by type, base_title, base_id, sub_id -- order by type to collect nonredirects first ) as res where not title like '%־%' -- limit 100
By running queries you agree to the
and you irrevocably agree to release your SQL under
All SQL code is licensed under
Checking query status...
Report a bug!
Wikimedia Cloud VPS
, written in