SQL
AخA
use enwiki_p;
select distinct page_title as English, ll_title as Simple
from page
join langlinks
on ll_from = page_id
where ll_lang = "simple"
and page_title in
(
select page_title
from page
join categorylinks
on cl_from = page_id
where cl_to = "Natureserve_critically_imperiled_species"
)
order by English asc;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.