!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_from FROM templatelinks, linktarget
            WHERE lt_namespace = 10
            and tl_target_id = lt_id
            and lt_title = "navbox"
        )

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

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

Checking query status...
