!temp to pages

SQL

SELECT 
lt_title,
count(tl_from) as a
FROM templatelinks, linktarget#, page
where lt_namespace = 10 
and tl_target_id = lt_id
#and tl_from_namespace = 0
#and page_title = lt_title
#and page_namespace = lt_namespace


and lt_id in (
            SELECT tl.tl_from FROM templatelinks tl, linktarget lt
            WHERE lt.lt_namespace = 10
            and tl.tl_target_id = lt.lt_id
            and lt.lt_title = "Navbox"
        )

AND lt_id NOT IN (SELECT ll_from FROM langlinks WHERE ll_lang = 'ar' AND ll_from = page_id)

AND tl_from IN (SELECT ll_from FROM langlinks WHERE ll_lang = 'ar' AND ll_from = tl_from)


#and lt_title like "%Infobox_%"
group by lt_title
order by COUNT(tl_from) desc
limit 150;
SQL

Checking query status...
