Topic on Talk:Quarry

I want to get articles with images of a the English Wikipedia category. Please help.

https://en.wikipedia.org/wiki/Category:Critically_endangered_plants

i tried by the code

select p.page_title from page p,page p1 where p.page_id in (select cl_from from categorylinks where cl_to = "Critically endangered plants") and p.page_namespace=0 and p1.page_namespace=1 and p1.page_title=p.page_title;

Would joining the page_props table satisfy your needs?

SELECT ..., pp_value
[...]
LEFT JOIN page_props ON pp_page = p.page_id AND pp_propname = 'page_image_free'