!temp to pages

SQL

SELECT 
lt_title,
count(*) 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 page_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 page_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(lt_title) desc
limit 150;
SQL

Checking query status...
