Tewiki:Ennikalu 2024 Articles sans image

SQL

select p1.Page_title from page p1,page p2
where p1.page_id not in (select pp_page from page_props where pp_propname in ("page_image", "page_image_free"))
      and p1.page_namespace=0
      and p1.page_is_redirect=0
      and p1.page_id not in (select pp_page from page_props where pp_propname ="disambiguation")
      and p2.page_title=p1.page_title
      and p2.page_namespace=1
      and p2.page_id in (select cl_from from categorylinks where cl_to = "ఎన్నికలు_2024_ప్రాజెక్టులో_భాగంగా_సృష్టించిన_పేజీలు") 
  
      order by p1.page_title

SQL

Checking query status...