All orphan non-free files linked to project namespace on te.wiki

SQL

SELECT 
    ilp.page_title as lnprojpage
    
from  page p
join image ON  p.page_namespace=6  AND p.page_title=img_name
JOIN categorylinks c1 ON p.page_id = c1.cl_from
JOIN imagelinks i ON p.page_title = i.il_to AND i.il_from_namespace =  4 
join revision ON     rev_page = p.page_id AND  rev_parent_id = 0
join actor ON    actor_id=rev_actor
join page ilp ON ilp.page_id=il_from
WHERE c1.cl_to = "All_non-free_media"
# ఈ_వారపు_వ్యాసం/ చరిత్రలో_ఈ_రోజు/ మీకు_తెలుసా?_భండారము/ ఈ_వారపు_బొమ్మ/
ORDER BY p.page_title ASC

SQL

Checking query status...