Tewiki:People pages sans Infobox

SQL

SELECT distinct page_title FROM page p1, revision
where p1.page_id not in (select tl_from from templatelinks, linktarget
                      where lt_id = tl_target_id
                      and tl_from_namespace =0  
                      and (lt_title like "%సమాచారపెట్టె%" or lt_title like "%Infobox%"))
	and rev_page=p1.page_id
    and rev_timestamp like "2024%"
    and rev_parent_id=0
    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 p1.page_title not in (select p2.page_title from page p2 where p2.page_namespace=1 
                              and p2.page_id in (select tl_from from templatelinks,linktarget
                                                 where lt_id = tl_target_id
                                                 and lt_title like "%Infobox_requested%" and tl_from_namespace=1))
	and p1.page_title not like "%ఎన్నిక%"
    and p1.page_title not like "%నియోజకవర్గం%"
    and p1.page_title not like "%జాబితా%"

order by p1.page_title
SQL

Checking query status...
